423 North Claremont Street, San Mateo, CA 94401-5402, USA


Property Overview:

  • San Mateo properties include both condo and single-family home options, offering a range of amenities and layouts.
  • Example listings feature 2-4 bedrooms, 2 bathrooms, and multiple garages (2-car attached, 3-car detached).
  • Prices range from $498,000 (condo) to higher for larger homes with extensive amenities.
  • Built as recently as 1997, with many modern upgrades and move-in ready interiors.

Neighborhood Highlights:

  • Prime San Mateo location: Close to downtown, dining, and shopping.
  • Quiet cul-de-sac and West San Mateo settings offer tranquility and accessibility.
  • Family-friendly neighborhoods with flat, usable lots and outdoor amenities.
  • Horsetown USA area offers equestrian facilities and a country lifestyle within city limits.

Property Features:

  • Detached Condo:

    • 2 bedrooms, 2 bathrooms, 2-car garage.
    • HOA-maintained yard for care-free living with single-family home amenities.
  • Single-Family Home:

    • 3 bedrooms, 2 bathrooms, office/4th bedroom.
    • 2-car front garage plus 3-car detached garage/workshop.
    • Chef’s kitchen: Custom soft-close cabinets, pull-outs, stainless steel appliances, double ovens, huge island with cooktop and retractable hood, granite counters.
    • Open floor plan: Kitchen flows into family and living rooms, both with fireplaces.
    • Family room: Soaring tongue-and-groove ceiling, built-ins, custom wainscoting, plantation shutters.
    • Primary suite: Walk-in closet, custom travertine tile shower with dual heads.
    • Tile and carpet flooring throughout.
    • Extensive patio with allumawood cover, raised garden beds, fruit trees (apple, lime, pomegranate, orange), herb garden.
    • Barn: 4 stalls, large turnouts, hitching post, flagpoles, horseshoe pit.
    • Additional structures: Dog house, sheds, playhouse, concrete RV driveway, carport.
    • Upgraded systems: New HVAC, whole house fan, multiple subpanels (including 220V and 30 amp for garage/workshop).
    • Freshly painted interior.
  • Updated Condo Unit:

    • 3 bedrooms, including primary suite with private balcony.
    • Open floor plan with vaulted ceilings, fireplace, and balcony.
    • Modern kitchen and dining area.
    • Two-car garage with custom storage.

Location Benefits:

  • Easy access to public transportation and major highways—ideal for commuters.
  • Perfect for families, entertaining, gardening, and even equestrian activities.
  • Low-maintenance options (condo with HOA) and spacious, amenity-rich homes available.
  • Blend of comfort, style, and convenience in the heart of San Mateo.

Price and Status History

date type price
2001-02-06 For Sale NaN
2004-12-30 Sold 580000
2008-11-12 Sold 365000
2022-07-27 Pending NaN
2024-01-01 Price Estimation 915779
2024-01-27 For Sale 998000
2024-02-26 Sold 1020000
2024-03-22 Sold 1075000
2024-04-25 For Sale 1075000
2024-05-03 For Sale 1049999
2024-05-06 Sold 1025000
2024-06-13 Sold 1025000

Superfund Enterprise Management System

SITE NAME ADDRESS FEDERAL FACILITY NPL STATUS NON-NPL STATUS CONTAMINANTS SEMS EPA ID DISTANCE (MILES)
UNIVERSAL COATINGS OFF 280 EUGENE A DORAN BRG, San Mateo, CA 94401, USA N N NF 0 CAD980637037 0.85

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 0 1 30
AH 0 0 0 0
AO 0 0 0 0
VE 0 0 0 3

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 Francisco South 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 0 0 1 1

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 1

Traffic Noise by Hour x Weekday

hour_of_day Monday Tuesday Wednesday Thursday Friday Saturday Sunday
0 48 NaN 48 52 53 45 52
1 41 52 52 NaN NaN 46 47
2 51 NaN 47 52 51 53 54
3 NaN 56 NaN 54 50 NaN 49
4 51 45 46 52 NaN 47 NaN
5 50 51 47 49 NaN 51 44
6 NaN 43 46 47 45 NaN 48
7 NaN 45 42 43 NaN 43 NaN
8 NaN NaN 46 44 43 31 45
9 NaN NaN 43 45 44 NaN 42
10 44 NaN NaN NaN 44 NaN 45
11 NaN NaN 31 46 41 NaN NaN
12 34 42 40 NaN NaN 42 41
13 NaN 46 38 44 NaN NaN 41
14 46 32 NaN 43 40 NaN NaN
15 NaN 47 46 NaN 47 NaN 49
16 45 54 33 51 49 NaN 51
17 45 NaN 50 51 48 NaN 51
18 NaN NaN 52 52 NaN NaN 51
19 50 NaN 51 49 52 57 53
20 50 49 48 47 NaN NaN 54
21 48 53 48 49 NaN NaN 48
22 NaN 49 44 51 55 45 53
23 50 50 52 NaN 46 NaN 49

Airplane Noise by Hour x Weekday

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