Skip main navigation
Pending
  • $2,398,000

    509 Madera Dr, San Mateo, CA 94403

    3beds
    2,180sqft
    : 
    Single Family Residence,
    Built in 1947
    7,379 Square Feet Lot
    $2,464,800 Zestimate®
    $1,100/sqft
    $-- HOA

    What's special

    Recently updated kitchenTowering pergolaPrivacy and tranquilitySeparate family roomSleek quartz countertopsFloor-to-ceiling windowsHandcrafted dining table
    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.
    34 days
    on Zillow
    |
    1,746
    |
    103
    |

    Zillow last checked: 7 hours ago

    Listing updated: July 22, 2025 at 07:13am

    Listed by:

    Caitlin Beanan 01965149 650-576-3994,

    Coldwell Banker Realty

    Source: MLSListings Inc,MLS#: ML82014074MLS Logo
    Travel times

    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 Square Feet
    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 & HOA

    Location
    • Region: San Mateo

    Financial & listing details

    • Price per square foot: $1,100/sqft
    • Tax assessed value: $1,907,443
    • Annual tax amount: $23,863
    • Date on market: 7/10/2025
    • Listing agreement: ExclusiveRightToSell
    • Loading