We can give you advice on home buying,selling and investments but we are not trained or licensed in other fields. As much as we would like to help,Realtors have gotten into trouble this way.
You need to talk to the hazard disclosure company or a professional in Earthquake Engineering or Geology to get a thorough and accurate answer.
I have seen buyers cancel transactions after receiving the NHD report and finding the subject property was on or close to an earthquake fault. Buyers must make their own assessments of the level of risk â€“ real or perceived â€“ that they are comfortable with after receiving and reviewing the NHD report.
Most homes in Calif. are is some sort of natural zone.
There are a few lakes, example; Lake DeValle in Livermore, if that Dam breaks, water will travel through Alameda Creek toward the Bay, traveling through parts of Fremont. Since this has never happened, we don't really know how much water would travel and what type of damage - if any. This is an example of a dam inundation zone. Milpitas has a large lake off of Calaveras Road, however I'm not sure there is a dam.
Iliquefaction would be the earth moving during an earthquake. Whether you are located on harder or softer soil.
You can look this information up on the website they likely provided.
hope this helps,
Good luck and best wishes in your new home,