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.
Pending
$2,398,000
509 Madera Dr, San Mateo, CA 94403
3beds
2,180sqft
Est.:
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
- 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#: ML82014074

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
Video & virtual tour
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