MLS Listings Updated Daily

Search Coastside and Peninsula Homes for Sale

Browse Half Moon Bay homes for sale and explore listings throughout El Granada, Moss Beach, Montara, Pacifica, and the San Mateo County Coastside.

Save
Ask
Tour
Hide
Share
$3,888,000
11 Days On Site

509 Crescent Avenue
SAN MATEO, CA 94402

For Sale|Single Family Residence|Active
5
Beds
4
Total Baths
4
Full Baths
2,940
SqFt
$1,322
/SqFt
1923
Built
County:
San Mateo
Listed by of Sternsmith Group of Compass (650) 678-3847
509 Crescent Avenue509 Crescent Avenue509 Crescent Avenue509 Crescent Avenue
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

Enter an interest rate to see your estimated monthly payment.
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

Set on an expansive 8,670-square-foot lot in coveted San Mateo Park, 509 Crescent Avenue offers an exceptional blend of timeless character, privacy, and effortless indoor-outdoor living. A gracious formal living room and elegant dining room create beautiful spaces for entertaining, while the kitchen serves as the heart of everyday life, opening naturally to the backyard. Outside, a generous lawn framed by mature trees creates a private setting for play, gatherings, and relaxed afternoons at home. Inside, approximately 2,940 square feet unfold across a versatile five-bedroom, four bath floor plan. Two bedrooms on the main level offer flexibility for guests, a home office, or multigenerational living, while upstairs are three additional bedrooms, including the primary suite and two secondary bedrooms that share a full bath. A generous family room provides additional space to gather, and a detached two-car garage adds convenience and flexibility. Enjoy all that San Mateo Park has to offer tree-lined streets, beautiful homes, neighborhood block parties, and walkability. Just minutes from downtown Burlingame, 509 Crescent offers a rare combination of space, privacy, charm, and convenience in one of the Peninsulas most beloved neighborhoods.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$3,888,000
Days On Site 
11 Days
Bedrooms 
5
Inside Area (SqFt) 
2,940 sqft
Total Baths 
4
Full Baths 
4
Partial Baths 
N/A
Lot Size 
0.199 Acres
Year Built 
1923
MLS Number 
ML82065540
Status 
Active
Property Tax 
N/A
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
yesterdayListing updated with changes from the MLS
2 weeks agoListing first seen on site
General Features
Cross Street 
W. Bellevue Ave
Disclosures 
https://hlm.homelight.com/link/509-Crescent-Avenue-lkvfju7g
Foundation 
Concrete Perimeter
Garage 
Yes
Garage Spaces 
2
Number Of Stories 
2
Parking 
Detached
Property Sub Type 
Single Family Residence
Sewer 
Public Sewer
SqFt Total 
2940
Water Source 
Public
Zoning 
R1000A
Interior Features
Appliances 
DishwasherRefrigeratorRange HoodBuilt-In RangeWasher/Dryer
Fireplace 
Yes
Fireplace Features 
Living Room
Fireplaces 
1
Flooring 
CarpetTileWood
Heating 
Forced AirNatural GasCentral
Interior 
Kitchen Island
Save
Ask
Tour
Hide
Share
Exterior Features
Exterior 
Balcony
Fencing 
Fenced
Lot Features 
Back Yard
Patio And Porch 
DeckPatio
Pool Features 
None
Roof 
Composition
Community Features
School District 
San Mateo Union High
Schools
School District
San Mateo Union High
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listed by of Sternsmith Group of Compass (650) 678-3847



The data relating to real estate for sale on this display comes in part from the Internet Data Exchange program of the MLSListings™ MLS system. Real estate listings held by brokerage firms other than eXp Realty are marked with the Internet Data Exchange icon and detailed information about them includes the names of the listing brokers and listing agents. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Copyright 2026, MLS Listings, Inc..
Last checked: 2026-11-04 04:19 AM UTC

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share
Scroll to Top