Home | San Mateo County | San Mateo | 94402 | 509 Crescent Ave
MLS: ML82065540 | Status: Active | Price: $3,888,000
Beds/Baths: 5 / 4
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 5 | 4 | 2,940 | 8,670 | 1923 |
| Date | Time | Hosted By |
|---|---|---|
| Friday, October 23 | 4:30 pm - 6:00 pm | Sternsmith Group |
| Saturday, October 24 | 2:00 pm - 4:00 pm | Sternsmith Group |
| Sunday, October 25 | 2:00 pm - 4:00 pm | Sternsmith Group |
| Monday, October 26 | 12:00 pm - 1:00 pm | Sternsmith Group |
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.
| Field | Value |
|---|---|
| MLS # | ML82065540 |
| MLS Source | MLSListings, Inc. |
| Days on Site | 0 |
| Feature | Details |
|---|---|
| Bedrooms | Primary Suite/Retreat, More than One Bedroom on Ground Floor |
| Bathrooms | Full on Ground Floor |
| Kitchen | Countertop - Stone, Island with Sink |
| Appliances | Dishwasher, Hood Over Range, Oven Range - Built-In, Gas, Refrigerator, Washer/Dryer |
| Dining Room | Dining Area, Formal Dining Room |
| Family Room | Separate Family Room |
| Fireplace | Living Room |
| Flooring | Carpet, Tile, Wood |
| Cooling | None |
| Heating | Central Forced Air - Gas |
| Feature | Details |
|---|---|
| Roof | Composition |
| Foundation | Concrete Perimeter |
| Feature | Details |
|---|---|
| Garage/Parking | Detached, Garage: 2 Car(s) |
| Elementary District | San Mateo-Foster City Elementary |
| High School District | San Mateo Union High |
| Sewer | Public Sewer |
| Water | Public |
| Zoning | R1000A |
Sternsmith Group
Compass
License #: 01999389,01733080
Phone: (650) 678-3847
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| San Mateo Park Elementary School | public | K-5 | 0.06 mi | 2 |
| South Hillsborough School | public | K-5 | 0.57 mi | 9 |
| Washington Elementary School | public | K-5 | 0.84 mi | 7 |
| Burlingame High School | public | 9-12 | 1.00 mi | 10 |
| San Mateo High School | public | 9-12 | 1.01 mi | 9 |
| North Hillsborough School | public | K-5 | 1.02 mi | 9 |
| McKinley Elementary School | public | K-5 | 1.05 mi | 8 |
| San Mateo Adult | public | UG | 1.05 mi | N/A |
| Crocker Middle School | public | 6-8 | 1.07 mi | 8 |
| Baywood Elementary School | public | K-5 | 1.28 mi | 7 |
| Aragon High School | public | 9-12 | 1.52 mi | 10 |
| North Shoreview Montessori Elementary School | public | K-8 | 1.57 mi | 10 |
| BSD Preschool | public | UG | 1.64 mi | N/A |
| Roosevelt Elementary School | public | K-5 | 1.64 mi | 6 |
| Sunnybrae Elementary School | public | K-5 | 1.73 mi | 2 |
| Borel Middle School | public | 6-8 | 1.76 mi | 8 |
| West Hillsborough School | public | K-5 | 1.83 mi | 9 |
| Hoover Elementary | public | K-5 | 2.16 mi | 8 |
| LEAD Elementary | public | K-5 | 2.27 mi | 2 |
| Lincoln Elementary School | public | K-5 | 2.34 mi | 8 |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 739-741 Linden Ave | $4,500,000 | 6 | 4/2 | 5,109 | Active |
| 1324 Cortez Ave | $3,395,000 | 4 | 3 | 1,710 | Active |
| 1280 Balboa Ave | $4,488,000 | 5 | 3 | 2,680 | Active |
| 826 Walnut Ave | $4,495,000 | 5 | 3 | 2,895 | Active |
©2026 MLSListings Inc. All rights reserved. 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. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MLSListings Inc.
Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.
This listing information is up-to-date as of October 23, 2026. For the most current information, please contact Sternsmith Group, (650) 678-3847.