509 Madera Drive

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.

Days on Market

12 days

Current Status

Active

Original Price

$2,398,000

List Price

$2,398,000

On Market Date

Jul 10, 2025

Property Type

Single Family Home

Area

428 - San Mateo Terrace Etc.

Zip Code

94403

MLS ID

ML82014074

APN

039-102-050

Year Built

1947

Stories in Building

1

Possession

Unavailable

Data Source

MLSL

Origin MLS System

MLSListings, Inc.

Bed

3

Bath

3

Primary - Stall Shower(s), Shower over Tub - 1, Skylight, Stall Shower - 2+

Parking

5

Detached Garage, Off-Street Parking, On Street, Room for Oversized Vehicle

SQ FT

2,180

SQ FT Source

Unavailable

Lot SQ FT

7,379.0

Lot Acres

0.169399 Acres

Kitchen

Built-in BBQ Grill, Countertop - Quartz, Dishwasher, Hood Over Range, Oven - Gas, Oven Range - Gas, Refrigerator, Skylight

Cooling

Central AC

Dining Room

Dining Area

Disclosures

Natural Hazard Disclosure

Family Room

Separate Family Room

Flooring

Hardwood, Tile

Foundation

Crawl Space

Fire Place

Gas Burning

Heating

Central Forced Air - Gas

Laundry

In Utility Room, Washer / Dryer

Fee

Unavailable

MLS and other Information regarding properties for sale as shown in Theo have been obtained from various sources such as sellers, public records, agents and other third parties. This information may relate to the condition of the property, permitted or unpermitted uses, zoning, square footage, lot size/acreage or other matters affecting value or desirability. Unless otherwise indicated in writing, neither brokers, agents nor Theo have verified, or will verify, such information. If any such information is important to buyer in determining whether to buy, the price to pay or intended use of the property, buyer is urged to conduct their own investigation with qualified professionals, satisfy themselves with respect to that information, and to rely solely on the results of that investigation.

School data provided by GreatSchools. School service boundaries are intended to be used as reference only. To verify enrollment eligibility for a property, contact the school directly.