---
listing_id: ML81998753
status: Closed
price: 2060000
beds: 4
baths_full: 2
baths_half: 0
sqft_living: 2274
sqft_lot: 5035
lot_acres: 
year_built: 1953
property_type: Residential
property_subtype: Single Family Residence
address: "254 W 40th"
city: San Mateo
state: CA
zip: 94403
county: "San Mateo County"
lat: 37.528711
lng: -122.299292
days_on_market: 400
hoa_fee: 
hoa_frequency: 
garage_spaces: 2
list_agent: "Alex Lehr"
list_office: "Guide Real Estate"
list_agent_phone: "(650) 766-5300"
list_agent_license: 00867442
mls_source: MLSL
modified: 2026-01-30
transaction_type: recentlySold
---

Home | San Mateo County | San Mateo | 94403 | 254 W 40th

254 W 40th, San Mateo, CA 94403

MLS: ML81998753 | Status: Sold | Price: $2,060,000
Beds/Baths: 4 / 2
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
4 2 2,274 5,035 1953

Remarks

Fantastic living in San Mateo is here on 40th! This timelessly treasured home has been held in the same family for 54 years and the legacy is now ready to be carried on by you! Where do I begin? Perfectly placed in this 2,274 sqft 4 bedroom 2 bath retreat, you'll enjoy the freshly painted (inside and out) with new and refinished flooring, new lighting, incredible views, family room, separate office, dining room, spacious and fully fenced yard, enclosed front porch and so much more! Walking distance to Molly Stone, Bel-Mateo shopping center along with easy access to Highway 101, 280, San Francisco airport, walking trails and everything else the Bay Area provides. Don't take my word for it...Put this home at the top of your must see list!

MLS Listing Information

Field Value
MLS # ML81998753
MLS Source MLSListings, Inc.

Features

Interior Features

Feature Details
Bedrooms Ground Floor Bedroom, Primary Suite/Retreat, Walk-in Closet, Primary Bedroom on Ground Floor, More than One Bedroom on Ground Floor
Bathrooms Primary - Stall Shower(s), Shower over Tub - 1, Tile, Full on Ground Floor
Kitchen Countertop - Tile, Exhaust Fan
Appliances Dishwasher, Exhaust Fan, Oven Range - Electric
Dining Room Breakfast Bar, Dining Area
Family Room Separate Family Room
Fireplace Family Room, Living Room, Wood Burning
Flooring Carpet, Hardwood
Laundry In Garage
Cooling None
Heating Forced Air

Exterior Features

Feature Details
Roof Composition, Shingle
Foundation Concrete Perimeter
Style Traditional

Parking, School, and Other Information

Feature Details
Garage/Parking Attached Garage, Off-Street Parking, Garage: 2 Car(s)
Elementary District San Mateo-Foster City Elementary
High School District San Mateo Union High
Sewer Public Sewer
Water Public
Zoning R10006

Contact Information

Alex Lehr
Guide Real Estate
License #: 00867442
Phone: (650) 766-5300

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Laurel Elementary School public K-5 0.43 mi 3
Abbott Middle School public 6-8 0.53 mi 4
George Hall Elementary School public K-5 0.74 mi 9
Hillsdale High School public 9-12 0.85 mi 9
Beresford Elementary School public K-5 0.93 mi 4
Central Elementary School public K-5 0.95 mi 9
Cipriani Elementary School public K-5 0.99 mi 8
Meadow Heights Elementary School public K-5 1.19 mi 7
Nesbit Elementary School public K-8 1.35 mi 6
Ralston Intermediate School public 6-8 1.36 mi 10
Fiesta Gardens International Elementary School public K-5 1.37 mi 4
Mariposa Upper Elementary School public 4,5 1.53 mi 10
Tierra Linda Middle School public 6-8 1.53 mi 10
College Park Elementary School public K-5 1.60 mi 9
Carlmont High School public 9-12 1.70 mi 10
Fox Elementary School public K-5 1.83 mi 10
Foster City Elementary School public K-5 1.85 mi 9
Borel Middle School public 6-8 1.91 mi 8
San Mateo County Special Education School public K-12 2.00 mi N/A
San Mateo County Rop School public 11-12 2.00 mi N/A

Disclosures

©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 January 30, 2026. For the most current information, please contact Alex Lehr, (650) 766-5300.