602 Mystic Ln, Foster City, CA 94404, USA


Property Overview:

This beautifully remodeled waterfront home is tucked away at the end of a quiet, tree-lined cul-de-sac with panoramic views of Wide Water and San Mateo Hills. The residence features 3 bedrooms (including a versatile loft converted to a bedroom), 2.5 bathrooms, and a spacious open layout. The main-level primary suite offers a remodeled en-suite bath and direct access to a private backyard. The home is in immaculate move-in condition with fresh paint inside and out, new flooring, and fully renovated bathrooms.


Neighborhood Highlights:

  • Serene, private setting at the end of a cul-de-sac on a sheltered waterway
  • Stunning water and hillside views
  • Quiet, tree-lined streets with a peaceful ambiance
  • Award-winning model in a sought-after community

Property Features:

  • 3 bedrooms (including a flexible loft/office/den/guest room)
  • 2.5 bathrooms (all fully renovated with contemporary fixtures)
  • Dramatic living room with soaring ceilings, fireplace, and expansive windows framing water views
  • Stylish new kitchen with sleek finishes and all-new appliances
  • Main-level primary suite with remodeled en-suite bath and backyard access
  • Upstairs en-suite bedroom with high, arched ceilings
  • Freshly painted inside and out; new flooring and carpet throughout
  • Built-in cabinetry and bookshelves
  • Spacious two-car garage with attic storage
  • Modern amenities: A/C, EV charger, and solar panels

Location Benefits:

  • Waterfront living with direct access to tranquil waterway
  • Private backyard perfect for relaxing or entertaining by the water
  • Close to parks, trails, and outdoor recreation
  • Convenient access to shopping, dining, and major commute routes
  • Ideal for families, professionals, or anyone seeking a peaceful, scenic lifestyle

Price and Status History

date type price
1993-06-29 Sold 398000
2001-06-20 Sold 770000
2001-08-17 Sold 766250
2006-06-29 Sold 398000
2006-10-02 For Sale 1175000
2006-10-15 Sold 1175000
2006-11-14 Sold 1175000
2009-07-20 For Sale 1215000
2009-08-17 For Sale 1195000
2009-08-28 Pending NaN
2009-08-31 For Sale NaN
2009-09-16 Pending NaN
2009-09-17 Pending NaN
2009-10-15 Sold 1150000
2023-07-31 For Sale 2388000
2023-08-19 Pending NaN
2023-08-30 Sold 2388000
2025-04-17 For Sale 2658000
2025-04-22 Pending NaN

Superfund Enterprise Management System

SITE NAME ADDRESS FEDERAL FACILITY NPL STATUS NON-NPL STATUS CONTAMINANTS SEMS EPA ID DISTANCE (MILES)
BIG HORN GYPSUM CO. Postal Address is unavailable for the Site, San Mateo, CA 94404, USA N N RO 0 CAN000905640 0.78

Toxic Release Inventory

No data found within 1.0 miles for this property.

Integrated Compliance Information System - Air

No data found within 1.0 miles for this property.

Flood Risk Info

fld_zone very high impact: up to 0.0001 miles high impact: up to 0.2 miles moderate impact: up to 0.5 miles low-moderate impact: up to 1.5 miles
A 0 0 0 4
AE 0 1 0 8
AH 0 0 0 0
AO 0 0 0 2
VE 0 0 0 0

Flood Zone Type

code meaning
A 1% annual chance flood zone determined using approximate methods. No BFEs shown. Flood insurance and management standards apply.
AE 1% annual chance flood zone determined by detailed methods. BFEs shown. Insurance and floodplain management required.
AH Shallow flooding (ponding) zones with depths between 1-3 feet. BFEs shown. Insurance and management required.
AO Shallow flooding (sheet flow) zones with depths 1-3 feet. BFEs or average depths shown. High-velocity areas may exist.
VE Coastal 1% annual chance flood zone with wave action. BFEs shown. Insurance and management required.

Earthquake Risk Info

zone_name quad_name very high impact: up to 0.0001 miles high impact: up to 2.0 miles moderate impact: up to 10.0 miles
San Andreas - Peninsula Montara Mountain 0 0 1
San Andreas - Peninsula San Mateo 0 0 1
San Andreas - Peninsula Woodside 0 0 1

Landslide Risk Info

lscat very high impact: up to 0.0001 miles high impact: up to 0.04 miles moderate impact: up to 0.1 miles low-moderate impact: up to 0.2 miles
8 0 0 0 0

Liquefaction Risk Info

Suscept very high impact: up to 0.0001 miles high impact: up to 0.05 miles moderate impact: up to 0.5 miles low-moderate impact: up to 1.0 miles
High 0 0 0 0
Very high 1 0 2 8

Wild fire Risk Info

haz_class very high impact: up to 0.0001 miles high impact: up to 0.5 miles moderate impact: up to 1.5 miles low-moderate impact: up to 3.0 miles
High 0 0 0 0
Very High 0 0 0 0

Traffic Noise by Hour x Weekday

Not enough data points

Airplane Noise by Hour x Weekday

hour_of_day Monday Tuesday Wednesday Thursday Friday Saturday Sunday
0 2 2 3 2 2 2 1
1 1 1 2 2 2 2 1
2 1 2 2 3 2 2 2
3 1 2 1 1 1 1 1
4 1 1 1 1 1 1 1
5 1 1 2 1 1 2 1
6 2 2 3 3 3 3 3
7 2 3 1 2 2 2 2
8 3 3 3 2 4 3 3
9 5 7 5 4 5 7 5
10 6 6 10 7 7 8 7
11 7 8 7 7 9 10 9
12 8 6 6 8 8 6 6
13 8 9 9 9 7 11 8
14 5 9 8 8 9 8 7
15 5 5 6 5 7 6 8
16 5 7 6 8 6 6 7
17 4 6 5 5 6 5 5
18 4 4 4 4 6 3 5
19 4 5 5 5 4 3 4
20 3 3 3 3 3 3 3
21 2 3 2 2 3 2 3
22 2 1 2 2 2 1 1
23 2 3 2 2 3 3 3