


Listing Courtesy of:
MLSlistings Inc. / Coldwell Banker Realty / Caitlin Beanan - Contact: 650-576-3994

509 Madera Drive San Mateo, CA 94403
Active
$2,398,000
OPEN HOUSE TIMES
-
OPENSat, Jul 121:00 pm - 4:00 pm
-
OPENSun, Jul 131:00 pm - 4:00 pm
Description
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.
MLS #:
ML82014074
ML82014074
Lot Size
7,379 SQFT
7,379 SQFT
Type
Single-Family Home
Single-Family Home
Year Built
1947
1947
School District
938
938
County
San Mateo County
San Mateo County
Listed By
Caitlin Beanan, DRE #01965149 CA, Coldwell Banker Realty, Contact: 650-576-3994
Source
MLSlistings Inc.
Last checked Jul 11 2025 at 3:02 AM GMT+0000
MLSlistings Inc.
Last checked Jul 11 2025 at 3:02 AM GMT+0000
Bathroom Details
- Full Bathrooms: 3
Interior Features
- In Utility Room
- Washer / Dryer
Kitchen
- Built-In Bbq Grill
- Countertop - Quartz
- Dishwasher
- Hood Over Range
- Oven - Gas
- Oven Range - Gas
- Refrigerator
- Skylight
Property Features
- Balcony / Patio
- Deck
- Fire Pit
- Low Maintenance
- Outdoor Kitchen
- Fireplace: Gas Burning
- Foundation: Crawl Space
Heating and Cooling
- Central Forced Air - Gas
- Central Ac
Flooring
- Hardwood
- Tile
Exterior Features
- Roof: Composition
Utility Information
- Utilities: Public Utilities, Water - Public
- Sewer: Sewer - Public
School Information
- High School: Aragon High
Garage
- Detached Garage
- Off-Street Parking
- On Street
- Room for Oversized Vehicle
Stories
- 1
Living Area
- 2,180 sqft
Additional Information: Burlingame | 650-576-3994
Location
Estimated Monthly Mortgage Payment
*Based on Fixed Interest Rate withe a 30 year term, principal and interest only
Listing price
Down payment
%
Interest rate
%Mortgage calculator estimates are provided by Coldwell Banker Real Estate LLC and are intended for information use only. Your payments may be higher or lower and all loans are subject to credit approval.
Disclaimer: The data relating to real estate for sale on this website comes in part from the Broker Listing Exchange program of the MLSListings Inc.TM MLS system. Real estate listings held by brokerage firms other than the broker who owns this website are marked with the Internet Data Exchange icon and detailed information about them includes the names of the listing brokers and listing agents. Listing data updated every 30 minutes.
Properties with the
icon(s) are courtesy of the MLSListings Inc.
Listing Data Copyright 2025 MLSListings Inc. All rights reserved. Information Deemed Reliable But Not Guaranteed.
Properties with the

Listing Data Copyright 2025 MLSListings Inc. All rights reserved. Information Deemed Reliable But Not Guaranteed.