509 Madera Dr

2,180 Sq. Ft.
$1,193 / Sq. Ft.
2,180
Sq. Ft.
$1,193
per Sq. Ft.

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...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.

Property Details for 509 Madera Drive

MLS City Name
SAN MATEO
Building Type
Detached
Garage Spaces
2
Parking Spaces
3
Cross Street
Alameda de las P
LISTING UPDATED: 08/15/2025 02:09 PM

Property Details for 509 Madera Drive

StatusSold
MLS #ML82014074
Days on Compass11
Taxes-
HOA Fees-
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeSingle-Family Homes / Detached
Year Built1947
Lot Size0.17 AC / 7,379 SF
CountySan Mateo County

Location

Listing Courtesy of Coldwell Banker Realty, Caitlin Beanan, DRE #01965149

Sold By Compass, Julie Flouty, DRE #01901710

Add your commute

Virtual Tour

Building Information for 509 Madera Drive

Stories1Year Built1947Building Size-Lot Size0.17 AC / 7,379 SF

Payment Calculator

Get preapproved with
OriginPoint Mortgage or Rocket Mortgage1

$14,661 per month

30 year fixed, 6.15% Interest

Principal and Interest

$12,672

Property Taxes

$1,989

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 509 Madera Drive

Features
Room Information
  • Bathroom: Primary - Stall Shower(s), Shower over Tub - 1, Skylight, Stall Shower - 2+
  • Bedrooms: Primary Suite / Retreat, Walk-in Closet
  • Dining Room: Dining Area
  • Family Room: Separate Family Room
  • Kitchen: Built-in BBQ Grill, Countertop - Quartz, Dishwasher, Hood Over Range, Oven - Gas, Oven Range - Gas, Refrigerator, Skylight
  • Number of Full Bathrooms: 3
Features
  • Amenities: High Ceiling, Skylight, Vaulted Ceiling, Walk-in Closet
  • Fireplace: Yes
  • Fireplaces: Gas Burning
  • Fireplaces Min: 1
  • Flooring: Hardwood, Tile
  • Laundry: In Utility Room, Washer / Dryer
  • Living SqFt: 2180
  • Pool: No
Utilities
  • Cooling: Central AC
  • Heating: Central Forced Air - Gas
  • Sewer Septic: Sewer - Public
  • Utilities: Public Utilities
  • Water: Public
Garage
  • Garage and Parking: Detached Garage, Off-Street Parking, On Street, Room for Oversized Vehicle
  • Garage Max: 2
  • Garage Min: 2
Property Details
Homeowners Association
  • HOA Exists: 0
  • HOA Fee: $0
Property Details
  • Area Text: San Mateo Terrace Etc.
  • Roof: Composition
  • Stories: One Story
  • Subclass: Single Family Home
  • Year Built Source: Assessor
  • Street Number: 509
  • Street Name: Madera
  • Street Suffix: Drive
  • Area ID: 428
Lot / Property Details
Building Information
  • Number Of Stories: 1
  • Structure SqFt: 2180
  • Structure SqFt Source: Assessor
  • Age: 78
Development Information
  • Zoning Detail: R10006
Location Information
  • Parcel Number: 039-102-050
  • County Name: San Mateo
  • City Name: SAN MATEO
  • City Postal ID: 62
  • Postal Code: 94403
  • Elementary School District: 938
  • High School District Text: San Mateo Union High
  • High School Text: Aragon High
Lot Information
  • Foundation: Crawl Space
  • Horse Property: No
  • Lot Acres: .17
  • Lot Size Area Maximum Units: Square Feet
  • Lot Size Area Minimum Units: Square Feet
  • Lot Size Source: Assessor
  • Yard Grounds: Balcony / Patio, Deck, Fire Pit, Low Maintenance, Outdoor Kitchen

Property History for 509 Madera Drive

DateEvent & SourcePriceAppreciation
Aug 15, 2025

Sold

MLSListings #ML82014074

$2,600,000
Aug 15, 2025

Sold

EBRD #ML82014074

$2,600,000
Aug 8, 2025

Sold (Public Record)

Public Record #1909678592

$2,600,000

+6.8% / yr

Jul 21, 2025

Pending

EBRD #ML82014074

Jul 21, 2025

Pending

MLSListings #ML82014074

Jul 10, 2025

Listed (Active)

EBRD #ML82014074

$2,398,000
Jul 10, 2025

Listed (Active)

MLSListings #ML82014074

$2,398,000
Nov 15, 2019

Sold

EBRD #ML81769469

$1,779,000
Nov 15, 2019

Sold

MLSListings #ML81769469

$1,779,000
Nov 13, 2019

Sold (Public Record)

Public Record #657645803

$1,779,000

+5.4% / yr

Oct 25, 2019

Pending

MLSListings #ML81769469

Oct 25, 2019

Pending

EBRD #ML81769469

Oct 7, 2019

Price Change

MLSListings #ML81769469

$1,898,000
Sep 20, 2019

Listed (Active)

EBRD #ML81769469

$1,958,000
Sep 20, 2019

Listed (Active)

MLSListings #ML81769469

$1,958,000
Apr 5, 2011

Price Change

RESFAR #80117857

$778,880
Dec 28, 2001

Sold (Public Record)

Public Record #82288449

$695,000
Dec 28, 2001

Sold

EBRD #ML80158284

$695,000
Dec 28, 2001

Sold

MLSListings #ML80158284

$695,000
Nov 14, 2001

Pending

EBRD #ML80158284

Nov 14, 2001

Pending

MLSListings #ML80158284

Oct 29, 2001

Listed (Active)

EBRD #ML80158284

$699,996
Oct 29, 2001

Listed (Active)

MLSListings #ML80158284

$699,996
Sep 23, 2001

Expired

MLSListings #ML80141168

$779,000
Sep 23, 2001

Expired

RESFAR #80141168

Sep 23, 2001

Expired

EBRD #ML80141168

Sep 5, 2001

Withdrawn

RESFAR #80131835

Jul 23, 2001

Listed (Active)

RESFAR #80141168

$779,000
Jul 23, 2001

Listed (Active)

EBRD #ML80141168

$779,000
Jul 23, 2001

Listed (Active)

MLSListings #ML80141168

$779,000
Jun 15, 2001

Withdrawn

RESFAR #80117857

Jun 8, 2001

Withdrawn

EBRD #ML80131835

Jun 8, 2001

Withdrawn

MLSListings #ML80131835

Jun 5, 2001

Price Change

RESFAR #80131835

$799,000
Jun 5, 2001

Listed (Active)

RESFAR #80131835

$628,000
Jun 5, 2001

Listed (Active)

MLSListings #ML80131835

$628,000
Jun 5, 2001

Listed (Active)

EBRD #ML80131835

$628,000
May 7, 2001

Withdrawn

EBRD #ML80117857

May 7, 2001

Withdrawn

MLSListings #ML80117857

May 5, 2001

Withdrawn

RESFAR #80110538

Apr 4, 2001

Price Change

RESFAR #80117857

$828,500
Apr 4, 2001

Listed (Active)

MLSListings #ML80117857

$828,500
Apr 4, 2001

Withdrawn

MLSListings #ML80110538

Apr 4, 2001

Listed (Active)

RESFAR #80117857

$778,880
Apr 4, 2001

Withdrawn

EBRD #ML80110538

Apr 4, 2001

Listed (Active)

EBRD #ML80117857

$828,500
Mar 4, 2001

Listed (Active)

MLSListings #ML80110538

$829,000
Mar 4, 2001

Listed (Active)

RESFAR #80110538

$829,000
Mar 4, 2001

Listed (Active)

EBRD #ML80110538

$829,000
DateEvent & SourcePrice
08/15/2025

Sold

MLSListings #ML82014074

$2,600,000
08/15/2025

Sold

EBRD #ML82014074

$2,600,000
08/08/2025

Sold (Public Record)

Public Record #1909678592

$2,600,000

+6.8% / yr

07/21/2025

Pending

EBRD #ML82014074

07/21/2025

Pending

MLSListings #ML82014074

07/10/2025

Listed (Active)

EBRD #ML82014074

$2,398,000
07/10/2025

Listed (Active)

MLSListings #ML82014074

$2,398,000
11/15/2019

Sold

EBRD #ML81769469

$1,779,000
11/15/2019

Sold

MLSListings #ML81769469

$1,779,000
11/13/2019

Sold (Public Record)

Public Record #657645803

$1,779,000

+5.4% / yr

10/25/2019

Pending

MLSListings #ML81769469

10/25/2019

Pending

EBRD #ML81769469

10/07/2019

Price Change

MLSListings #ML81769469

$1,898,000
09/20/2019

Listed (Active)

EBRD #ML81769469

$1,958,000
09/20/2019

Listed (Active)

MLSListings #ML81769469

$1,958,000
04/05/2011

Price Change

RESFAR #80117857

$778,880
12/28/2001

Sold (Public Record)

Public Record #82288449

$695,000
12/28/2001

Sold

EBRD #ML80158284

$695,000
12/28/2001

Sold

MLSListings #ML80158284

$695,000
11/14/2001

Pending

EBRD #ML80158284

11/14/2001

Pending

MLSListings #ML80158284

10/29/2001

Listed (Active)

EBRD #ML80158284

$699,996
10/29/2001

Listed (Active)

MLSListings #ML80158284

$699,996
09/23/2001

Expired

MLSListings #ML80141168

$779,000
09/23/2001

Expired

RESFAR #80141168

09/23/2001

Expired

EBRD #ML80141168

09/05/2001

Withdrawn

RESFAR #80131835

07/23/2001

Listed (Active)

RESFAR #80141168

$779,000
07/23/2001

Listed (Active)

EBRD #ML80141168

$779,000
07/23/2001

Listed (Active)

MLSListings #ML80141168

$779,000
06/15/2001

Withdrawn

RESFAR #80117857

06/08/2001

Withdrawn

EBRD #ML80131835

06/08/2001

Withdrawn

MLSListings #ML80131835

06/05/2001

Price Change

RESFAR #80131835

$799,000
06/05/2001

Listed (Active)

RESFAR #80131835

$628,000
06/05/2001

Listed (Active)

MLSListings #ML80131835

$628,000
06/05/2001

Listed (Active)

EBRD #ML80131835

$628,000
05/07/2001

Withdrawn

EBRD #ML80117857

05/07/2001

Withdrawn

MLSListings #ML80117857

05/05/2001

Withdrawn

RESFAR #80110538

04/04/2001

Price Change

RESFAR #80117857

$828,500
04/04/2001

Listed (Active)

MLSListings #ML80117857

$828,500
04/04/2001

Withdrawn

MLSListings #ML80110538

04/04/2001

Listed (Active)

RESFAR #80117857

$778,880
04/04/2001

Withdrawn

EBRD #ML80110538

04/04/2001

Listed (Active)

EBRD #ML80117857

$828,500
03/04/2001

Listed (Active)

MLSListings #ML80110538

$829,000
03/04/2001

Listed (Active)

RESFAR #80110538

$829,000
03/04/2001

Listed (Active)

EBRD #ML80110538

$829,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 509 Madera Drive

Taxable ValueLand$1,203,008Additions$742,583Total$1,945,591
Tax Record2024$23,863 ($1,989 / month)
Home Facts
Beds3Total Finished SqFt2,180 SqFtAbove Grade Finished SqFt2,180 SqFtStories1Lot Size7,379 SqFtStyleSingle Family ResidenceYear Built1947Year Renovated1956ZoningR10006CountySAN MATEOAPN039-102-050

Schools near 509 Madera Drive

This home is within San Mateo Union High School District.
Rating
School
Type
Grades
Distance
Public - K to 5
Public - 6 to 8
Public - 9 to 12
Public - K to 5
Rating
School
Distance
Meadow Heights Elementary School
PublicK to 5

Abbott Middle School
Public6 to 8

Aragon High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Coldwell Banker Realty, Caitlin Beanan, DRE #01965149

Based on information from one of the following Multiple Listing Services: San Francisco Association of Realtors, the MLSListings MLS, the BAREIS MLS, the EBRD MLS, Shasta Association of REALTORS® Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by San Francisco Association of Realtors, the MLSListings MLS, the BAREIS MLS, the EBRD MLS, Shasta Association of REALTORS® is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.