Prevu by reAlpha
BuySellBlogBrowse Listings

509 Crescent AvenueSan Mateo, CA 94402

For Sale

$3,888,000

Smart Buyer Rebate $38,880

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.

Listed by Sternsmith Group

·

Compass

·

6506783847

Last updated October 29, 2026

·

Source: MLSL #ML82065540

Listing Facts

  • TypeSingle-family
  • NeighborhoodSan Mateo Park
  • Bedrooms5
  • Bathrooms4
  • Days on Prevu9
  • Size2,940 sqft
  • Price per sqft$1,322

Amenities

  • Dishwasher
  • Private Outdoor Space
  • Parking

Location

Mortgage Calculator

Listing History

10/23/2026
Listed by Compass
$3,888,000
  1. 10/23/2026$3,888,000
    Listed by Compass

Property Details for 509 Crescent Avenue

Exterior

Construction

  • Roof: Composition
  • Stories: 2
  • Stories Total: 2
  • Year Built: 1923
  • Exterior Features: Balcony

Features

  • Fencing: Fenced
  • Patio And Porch Features: Deck, Patio

Measurements

  • Building Area Total: 2,940
  • Lot Features: Back Yard
  • Lot Size Area: 8,670
  • Lot Size Source: Assessor
  • Lot Size Units: Square Feet

Financial

Taxes

  • Parcel Number: 032-021-040

Interior

Features

  • Appliances: Dishwasher, Refrigerator, Range Hood, Built-In Range, Washer/Dryer
  • Fireplace Features: Living Room
  • Fireplace: Yes
  • Fireplaces Total: 1
  • Flooring: Carpet, Tile, Wood
  • Interior Features: Kitchen Island

Measurements

  • Living Area: 2,940

Rooms

  • Bathrooms Full: 4
  • Bedrooms Total: 5

Other

Location

  • City Region: San Mateo Park / El Cerrito Park

Parking

Parking

  • Garage Spaces: 2
  • Garage: Yes
  • Parking Features: Detached

Schools

Elementary School

  • Elementary School District: San Mateo-Foster City Elementary

High School

  • High School District: San Mateo Union High

Utilities

Equipment

  • Heating: Forced Air, Natural Gas, Central
  • Has Heating: Yes
  • Sewer: Public Sewer
  • Water Source: Public

Frequently Asked Questions

How many bedrooms and bathrooms does this single-family home have?

There are 5 bedrooms and 4 bathrooms in this single-family home at 509 Crescent Avenue.

Does this single-family home have parking?

Yes, there are 2 parking spaces available for 509 Crescent Avenue.

How does 509 Crescent Avenue compare to other single-family homes in San Mateo Park?

This single-family home is listed 47% below the average price for single-family homes in San Mateo Park and has been on the market for 80 less days than the typical home in this area.

What is the square footage on this single-family home?

According to the MLS, this listing is 2,940 sqft.

509 Crescent Avenue is a 5-bedroom, 4-bath single-family home for sale in SAN MATEO CA 94402. On Prevu for 9 days at $3,888,000. This residence features 2,940 square feet of living space, located in San Mateo Park. The median listing price for single-family homes in this area is $4,691,500. Property amenities include private outdoor space, dishwasher, and parking. Browse more single-family home listings in San Mateo.

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 Prevu Real Estate are marked with the Internet Data Exchange and detailed information about them includes the names of the listing brokers and listing agents. Based on information from the MLSListings MLS as of 10/29/2026. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Data Services by Constellation Data Labs. IDX display powered by Prevu Real Estate. Copyright 2026 MLSListings Inc. All rights reserved.

Full MLS Disclaimers

Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.