627 Bayview Ave, Millbrae, CA 94030, USA


Property Overview:

Vintage Charmer with Views For Days is a single-family home featuring 2 bedrooms, 1 bathroom, and approximately 950 sq. ft. of living space. Built with a flowy floor plan and an abundance of natural light from numerous windows, this home offers a refreshed, show-ready vibe. The property includes an attached 1-car garage, central forced air heating, and is situated on a lot with expansion potential.


Neighborhood Highlights:

  • Prime Location:

    • 3-minute walk to Millbrae Montessori and nearby play areas.
    • Close to San Bruno City Park, Junipero Serra Park, Capuchino High School, Green Hills Country Club, Crystal Springs Trail, Downtown shopping & restaurants.
    • Excellent access to BART, Caltrain, Highways 280 & 101, and SFO airport.
  • School Districts:

    • Millbrae Elementary School District
    • San Mateo Union High School District

Property Features:

  • Open and Airy Layout:

    • Flowy floor plan maximizes space and light.
    • Bevy of windows throughout for natural light.
  • Vintage Accents & Modern Updates:

    • Refinished original hardwood floors
    • Statement fireplace
    • Intentionally retained vintage details
  • Outdoor Living:

    • Gardens and mature fruit trees
    • Backyard is garden party-ready—ideal for al fresco dining with Bay views
    • Sub-area and open backyard offer expansion potential
  • Ample Storage:

    • Multiple storage spaces throughout the home.
  • No HOA Fees


Location Benefits:

  • 10/10 Location Score:
    • Walkable to schools, parks, and amenities.
    • Commuter-friendly with easy access to transit and major freeways.
    • Family-friendly neighborhood with recreation and shopping nearby.

Additional Details:

  • MLS #ML81964042
  • Zoning: R10006
  • Foundation: Concrete Perimeter
  • Roof: Composition, Shingle
  • Sewer/Water: Public
  • Cooling: None
  • Heating: Central Forced Air
  • Garage/Parking: Attached, 1 car

Stop in and #swoon—you’re going to love it!

Price and Status History

date type price
1993-12-01 Sold 260000
2022-07-27 Pending NaN
2023-09-10 Off Market NaN
2024-05-23 For Sale 1398000
2024-06-06 Pending NaN
2024-06-21 Pending NaN
2024-07-03 Sold 1550000
2024-07-08 Sold 1550000

Superfund Enterprise Management System

No data found within 1.0 miles for this property.

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 1 0 3
AE 0 0 0 5
AH 0 0 0 3
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
Northern San Gregorio Montara Mountain 0 0 1
Northern San Gregorio San Francisco South 0 0 0
Northern San Gregorio San Mateo 0 0 0
San Andreas - Peninsula Montara Mountain 0 1 0
San Andreas - Peninsula San Francisco South 0 0 1
San Andreas - Peninsula San Mateo 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 0 0

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 2 0
Very High 0 0 0 2

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 4 5 4 4 5 6 5
1 3 3 3 4 3 2 2
2 1 2 2 2 2 2 2
3 1 1 1 1 1 1 1
4 1 1 1 1 1 1 2
5 2 3 2 2 2 2 3
6 4 4 5 5 5 5 4
7 5 5 5 6 5 6 6
8 6 5 5 6 5 6 5
9 9 7 6 8 8 8 7
10 7 5 6 7 6 5 5
11 10 8 9 9 9 10 10
12 8 6 7 8 7 7 6
13 11 10 11 11 10 9 11
14 8 9 9 8 10 7 7
15 5 4 7 7 6 6 6
16 8 6 6 7 7 6 6
17 7 7 8 7 7 6 6
18 5 4 4 5 4 4 6
19 7 8 8 8 7 6 6
20 3 6 4 5 4 4 4
21 6 5 5 6 6 4 6
22 4 4 3 4 3 4 4
23 7 7 6 8 7 7 7