503 Hemlock Ave, Millbrae, CA 94030, USA


Property Overview:

503 Hemlock is an updated single-family home built around 1941, showcasing the era’s quality craftsmanship blended with modern aesthetics and conveniences. The home offers flexible living space and is thoughtfully finished to maximize natural lighting. The property is zoned C10000 and is listed under MLS #ML81968295.


Property Features:

  • Flexible Living Space: Includes a finished loft and partially finished attic (not included in calculated living space).
  • Backyard Amenities:
    • Pergola
    • Gas-connected barbecue
    • Non-conforming finished shed (not included in living space)
  • Kitchen:
    • Island with sink
    • Skylight(s)
    • Cooktop - Gas, Dishwasher, Hood Over Range, Oven - Built-In
  • Bathroom:
    • Primary bath with stall shower(s)
  • Fireplace: Located in the living room
  • Garage/Parking:
    • Attached garage for 1 car
  • Heating:
    • Fireplace and forced air
  • Roof:
    • Shingle
  • Utilities:
    • Public sewer and public water
  • School Districts:
    • Millbrae Elementary
    • San Mateo Union High

Additional Details:

  • Open House Dates:
    • Friday, 6/7: 5:30 pm – 7 pm
    • Saturday, 6/8: 1 pm – 4 pm
    • Sunday, 6/9: 1 pm – 4 pm
  • Offer Deadline:
    • Thursday, 6/13/24 by 5:30 pm (please allow 48 hours for response)
  • Buyer’s Brokerage Compensation: 2.50%
  • Lot Zoning: C10000
  • No HOA fees
  • No cooling system
  • No pool
  • No family room

Location Benefits:

  • Conveniently located near Millbrae and San Mateo school districts
  • Commuter-friendly with access to local amenities
  • Ideal for entertaining with backyard features and flexible indoor spaces

Price and Status History

date type price
1999-12-17 Sold 401000.0
2007-08-10 Sold 760000.0
2015-03-30 Sold 800000.0
2015-11-23 Off Market 383462.4
2024-06-04 For Sale 1380000.0
2024-06-13 Pending NaN
2024-06-26 Sold 1530000.0
2024-07-03 Sold 1530000.0

Superfund Enterprise Management System

SITE NAME ADDRESS FEDERAL FACILITY NPL STATUS NON-NPL STATUS CONTAMINANTS SEMS EPA ID DISTANCE (MILES)
OXYTRAL 895 Mitten Road, Burlingame, CA 94010-1303, USA N N NF 0 CAD982359036 0.8

Toxic Release Inventory

FACILITY NAME ADDRESS TOTAL FORMS LAST FORM YEAR RISK SCREENING FACILITY ID DISTANCE (MILES)
GARRATT-CALLAHAN CO BURLINGAME 50 Ingold Road, Burlingame, CA 94010-2206, USA 18 2023 Yes 94010SCHLZ50ING 0.71
METROPOLITAN FURNITURE CORP 1635 Rollins Road, Burlingame, CA 94010-2301, USA 3 1992 N/A 94010MTRPL1635R 0.90

Integrated Compliance Information System - Air

PLANT NAME ADDRESS OPERATING STATUS DISTANCE (MILES)
GUITTARD CHOCOLATE 10 Guittard Road, Burlingame, CA 94010-2203, USA OPR: Operating 0.55
CLARION HOTEL AT SF AIRPORT 401 East Millbrae Avenue, Millbrae, CA 94030-3111, USA OPR: Operating 0.66

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 1 8
AE 0 1 0 2
AH 0 0 0 2
AO 0 0 0 0
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 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 2
Very High 0 0 0 2

Traffic Noise by Hour x Weekday

hour_of_day Monday Tuesday Wednesday Thursday Friday Saturday Sunday
0 58 59 59 59 59 59 59
1 58 58 NaN 57 NaN 58 58
2 58 57 57 57 59 58 57
3 58 57 NaN NaN 59 58 58
4 57 56 57 58 NaN 58 58
5 54 55 57 56 56 NaN 58
6 54 56 54 NaN 55 56 56
7 56 52 NaN 53 NaN 55 54
8 54 54 54 55 54 51 NaN
9 53 54 54 53 54 55 54
10 54 NaN 54 53 54 55 51
11 53 54 51 53 54 NaN 53
12 54 54 53 54 NaN 53 54
13 NaN 55 56 54 55 54 54
14 56 55 54 56 57 56 54
15 58 58 58 59 61 59 54
16 57 57 58 58 57 57 57
17 56 56 58 56 56 NaN 58
18 58 57 57 NaN 58 59 58
19 58 59 60 58 61 NaN 58
20 58 58 60 NaN 59 63 60
21 59 58 60 58 NaN NaN 58
22 NaN 58 58 NaN NaN 58 59
23 58 59 58 59 59 NaN 58

Airplane Noise by Hour x Weekday

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