Skip main navigation
Sold for $2,060,000
  • $2,060,000

    254 W 40th Ave, San Mateo, CA 94403

    4beds
    2,274sqft
    Single Family Residence, Residential
    Built in 1953
    5,035 Square Feet Lot
    $2,091,700 Zestimate®
    $906/sqft
    $7,418 Estimated rent

    Home value

    $2,091,700

    $1.88M - $2.32M

    $7,418/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $7,418/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $7,418/mo

    Rent Zestimate®

    Refinance and save

    $12,985/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $12,985/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    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!

    Zillow last checked:

    Listing updated:

    Listed by:

    Alex Lehr 00867442 650-766-5300,

    Guide Real Estate 650-766-5300

    Bought with:

    , 02146792

    Magnify Real Estate

    Source: MLSListings Inc,MLS#: ML81998753MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 2
    • Full bathrooms: 2
    Rooms
    • Room types: Bonus Room
    Bedroom
    • Features: GroundFloorBedroom, PrimarySuiteRetreat, WalkinCloset, PrimaryBedroomonGroundFloor, BedroomonGroundFloor2plus
    Bathroom
    • Features: PrimaryStallShowers, ShoweroverTub1, Tile, FullonGroundFloor
    Dining room
    • Features: BreakfastBar, DiningArea
    Family room
    • Features: SeparateFamilyRoom
    Kitchen
    • Features: Countertop_Tile, ExhaustFan
    Heating
    • Forced Air
    Cooling
    • None
    Appliances
    • Included: Dishwasher, Exhaust Fan, Electric Oven/Range
    • Laundry: In Garage
    Features
    • Walk-In Closet(s)
    • Flooring: Carpet, Hardwood
    • Number of fireplaces: 2
    • Fireplace features: Family Room, Living Room, Wood Burning
    Interior area
    • Total structure area: 2,274
    • Total interior livable area: 2,274 sqft

    Property

    Parking
    • Total spaces: 3
    • Parking features: Attached, Off Street
    • Attached garage spaces: 2
    Features
    • Exterior features: Back Yard, Fenced
    • Fencing: Wood
    • Has view: Yes
    • View description: Hills
    Lot
    • Size: 5,035 Square Feet
    • Features: Sloped Down
    Details
    • Parcel number: 042221090
    • Zoning: R10006
    • Special conditions: Standard

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Traditional
    • Property subtype: Single Family Residence, Residential
    Materials
    • Foundation: Concrete Perimeter
    • Roof: Composition, Shingle
    Condition
    • New construction: No
    • Year built: 1953

    Utilities & green energy

    • Gas: PublicUtilities
    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Public Utilities, Water Public

    Community & HOA

    Location
    • Region: San Mateo

    Financial & listing details

    • Price per square foot: $906/sqft
    • Tax assessed value: $135,413
    • Annual tax amount: $2,577
    • Date on market: 3/20/2025
    • Listing agreement: ExclusiveRightToSell
    • Listing terms: CashorConventionalLoan

    Price history

    DateEventPrice
    9/12/2025Listing removed$6,750$3/sqft
    Source: Zillow Rentals Report a problem
    9/10/2025Listed for rent$6,750$3/sqft
    Source: Zillow Rentals Report a problem
    4/17/2025Sold$2,060,000+5.6%$906/sqft
    Source: MLSListings Inc #ML81998753 Report a problem
    4/16/2025Pending sale$1,950,000$858/sqft
    Source: MLSListings Inc #ML81998753 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$2,577 -9.8%$135,413 +2%
    2024$2,856 +11.6%$132,759 +2%
    2023$2,559 +5.6%$130,157 +2%
    2022$2,424 +8.2%$127,606 +2%
    2021$2,241 +4.7%$125,105 +1%
    2020$2,139 +6.3%$123,823 +2%
    2019$2,013 +4.1%$121,396 +2%
    2018$1,935 +18.9%$119,016 +2%
    2017$1,627 +9.1%$116,683 +2%
    2016$1,492 +7.9%$114,396 +1.5%
    2015$1,382 $112,679 +2%
    2014$1,382 $110,473 +0.5%
    2013-- $109,975 +2%
    2012-- $107,820
    2011-- $107,820 +2.8%
    2010-- $104,918 -0.2%
    2009-- $105,169 +2%
    2008-- $103,108 +2%
    2007-- $101,087 +2%
    2006-- $99,106
    2005-- $99,106 +4%
    2004-- $95,260 +1.9%
    2003-- $93,515 +2%
    2002-- $91,683 +2%
    2001-- $89,887 +2%
    2000-- $88,126
    Find assessor info on the county website

    Neighborhood: Southeast Hillsdale

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: LaurelElementary_1
    • Middle: AbbottMiddle
    • High: HillsdaleHigh
    • District: SanMateoFosterCityElementary

    Source: MLSListings Inc. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $2,091,700
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $2,091,700