Celebrating 10 years: fixed fees, full service, fast responses

Property search · The Consumer Protection Brokerage

Every listing shows your estimated rebate.

The green number on each home is what could come back to you: the buyer-broker fee (typically 2 to 3%) minus our flat $9,750. No other search shows you this, because no other brokerage gives it back.

At a glance

509 Crescent Avenue, SAN MATEO, CA, 94402

$3,888,000·4 bd·4 ba·MLSListings #ML82065540

Estimated Arrivva buyer rebate$68,000 to $107,000

Every completed rebate is published: see all 211 closings.

Listing data from MLSListings. Rebate estimate calculated by Arrivva.

Save
Ask
Tour
Hide
Share
$3,888,000
2 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
Call Now: (408) 868-2620
Is this the listing for you? We can help make it yours.
(408) 868-2620
Upcoming Open Houses
Sun, Oct 25, 2:00 PM - 4:00 PM
Mon, Oct 26, 12:00 PM - 1:00 PM
509 Crescent Avenue509 Crescent Avenue509 Crescent Avenue509 Crescent Avenue
Save
Ask
Tour
Hide
Share

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 
2 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
9 hours agoListing updated with changes from the MLS
2 days 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-10-25 04:49 PM 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

*Estimate only. Actual rebate may vary based on final price, lender requirements, MLS rules, and broker policies.

Questions about this listing

How much could a buyer get back on 509 Crescent Avenue, SAN MATEO, CA, 94402?
Arrivva estimates a buyer rebate of $68,000 to $107,000 on this listing. The buyer-broker fee, typically 2 to 3% of the price, goes back to you minus Arrivva's flat $9,750 fee. Every completed rebate is published on the Arrivva results page. See every completed closing
How do I schedule a tour of 509 Crescent Avenue, SAN MATEO, CA, 94402?
Set up a quick chat with Arrivva by phone or video. The team confirms showing availability fast, tours the home with you, and walks you through offer strategy and the rebate math before you commit to anything. Set up a time to talk

Found a home you love?

Schedule a free consultation to lock in your rebate before you offer.

Calls and texts are answered by Amy, our AI assistant, who can answer questions and help you book.