Skip main navigation
Sold for $2,600,000 on 08/15/25
  • $2,600,000

    509 Madera Dr, San Mateo, CA 94403

    3beds
    2,180sqft
    Single Family Residence
    Built in 1947
    7,379 Square Feet Lot
    $2,600,300 Zestimate®
    $1,193/sqft
    $7,143 Estimated rent

    Owner options

    List your home for rent

    $7,143/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,143/mo

    Rent Zestimate®

    Refinance and save

    $16,148/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

    $16,148/mo

    Est. payment

    What's special

    Welcome to 509 Madera Drive, a stunning 3-bed, 3-bath home in the highly desirable San Mateo Terrace neighborhood. Elevated above the street, this 2,180 sq. ft. residence offers a rare sense of privacy and tranquility from the moment you arrive. Inside, soaring vaulted ceilings and floor-to-ceiling windows flood the living area with natural light, creating a warm and inviting atmosphere. The recently updated kitchen features sleek quartz countertops and a skylight that brings in soft, airy brightness perfect for everyday living and entertaining. A separate family room with its own full bath provides incredible flexibility, ideal as a guest suite, home office, or playroom. The backyard is a true showstopper, thoughtfully designed for entertaining and relaxation. Enjoy a towering pergola, built-in grill and kitchen, custom concrete bench seating around a plumbed fire pit, and a handcrafted dining table. A raised patio offers a perfect setting for relaxing afternoons or casual games. A detached two-car garage with accordion window opens to the yard, creating an ideal indoor-outdoor flow for hosting. Conveniently located near Peninsula Golf & Country Club, 25th Ave shops and dining, Beresford and Borel Parks, and Hwy 92, this home offers exceptional style, comfort, and location.

    Zillow last checked: 7 hours ago

    Listing updated: August 15, 2025 at 07:11am

    Listed by:

    Caitlin Beanan 01965149 650-576-3994,

    Coldwell Banker Realty 650-558-4200

    Bought with:

    Julie Flouty, 01901710

    Compass

    Source: MLSListings Inc,MLS#: ML82014074MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 3
    • Full bathrooms: 3
    Bedroom
    • Features: PrimarySuiteRetreat, WalkinCloset
    Bathroom
    • Features: PrimaryStallShowers, ShoweroverTub1, Skylight, StallShower2plus
    Dining room
    • Features: DiningArea
    Family room
    • Features: SeparateFamilyRoom
    Kitchen
    • Features: Skylights
    Heating
    • Central Forced Air Gas
    Cooling
    • Central Air
    Appliances
    • Included: Built in BBQ Grill, Dishwasher, Range Hood, Gas Oven, Gas Oven/Range, Refrigerator, Washer/Dryer
    • Laundry: In Utility Room
    Features
    • High Ceilings, One Or More Skylights, Vaulted Ceiling(s), Walk-In Closet(s)
    • Flooring: Hardwood, Tile
    • Number of fireplaces: 1
    • Fireplace features: Gas
    Interior area
    • Total structure area: 2,180
    • Total interior livable area: 2,180 sqft

    Property

    Parking
    • Total spaces: 3
    • Parking features: Detached, Off Street, On Street, Oversized
    • Garage spaces: 2
    Features
    • Stories: 1
    • Patio & porch: Balcony/Patio, Deck
    • Exterior features: Fire Pit
    Lot
    • Size: 7,379 sqft
    Details
    • Parcel number: 039102050
    • Zoning: R10006
    • Special conditions: Standard

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Materials
    • Foundation: Crawl Space
    • Roof: Composition
    Condition
    • New construction: No
    • Year built: 1947

    Utilities & green energy

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

    Community & neighborhood

    Location
    • Region: San Mateo

    Other

    Other facts
    • Listing agreement: ExclusiveRightToSell
    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,600,300