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.
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
What's special
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#: ML82014074

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