
509 Madera Dr San Mateo, CA 94403
Beresford Park NeighborhoodHighlights
- Primary Bedroom Suite
- Skyline View
- Vaulted Ceiling
- Aragon High School Rated A+
- Deck
- Wood Flooring
About This Home
As of August 2025Welcome 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.
Last Agent to Sell the Property
Coldwell Banker Realty License #01965149 Listed on: 07/10/2025

Home Details
Home Type
- Single Family
Est. Annual Taxes
- $23,863
Year Built
- Built in 1947
Lot Details
- 7,379 Sq Ft Lot
- Grass Covered Lot
- Zoning described as R10006
Parking
- 2 Car Detached Garage
- On-Street Parking
- Off-Street Parking
Home Design
- Composition Roof
Interior Spaces
- 2,180 Sq Ft Home
- 1-Story Property
- Vaulted Ceiling
- Skylights in Kitchen
- Gas Fireplace
- Separate Family Room
- Dining Area
- Skyline Views
- Crawl Space
Kitchen
- Gas Oven
- Range Hood
- Dishwasher
- Quartz Countertops
Flooring
- Wood
- Tile
Bedrooms and Bathrooms
- 3 Bedrooms
- Primary Bedroom Suite
- Walk-In Closet
- 3 Full Bathrooms
- Bathtub with Shower
- Walk-in Shower
Laundry
- Laundry in Utility Room
- Washer and Dryer
Outdoor Features
- Balcony
- Deck
- Outdoor Kitchen
- Fire Pit
- Built-In Barbecue
Utilities
- Forced Air Heating and Cooling System
Listing and Financial Details
- Assessor Parcel Number 039-102-050
Ownership History
Purchase Details
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.Purchase Details
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.Purchase Details
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.Purchase Details
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.Purchase Details
Purchase Details
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.Purchase Details
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.Purchase Details
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.Purchase Details
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.Similar Homes in San Mateo, CA
Home Values in the Area
Average Home Value in this Area
Purchase History
Date | Type | Sale Price | Title Company |
---|---|---|---|
Grant Deed | $1,779,000 | Old Republic Title Company | |
Interfamily Deed Transfer | -- | First American Title Co | |
Interfamily Deed Transfer | -- | First American Title Co | |
Interfamily Deed Transfer | -- | Stewart Title Of California | |
Interfamily Deed Transfer | -- | Stewart Title Of California | |
Interfamily Deed Transfer | -- | Stewart Title Of California | |
Interfamily Deed Transfer | -- | None Available | |
Interfamily Deed Transfer | -- | Stewart Title Of Ca Inc | |
Interfamily Deed Transfer | -- | Stewart Title Of California | |
Grant Deed | $695,000 | Fidelity National Title Co | |
Grant Deed | $485,000 | Old Republic Title Ins Compa |
Mortgage History
Date | Status | Loan Amount | Loan Type |
---|---|---|---|
Open | $1,423,200 | New Conventional | |
Previous Owner | $350,000 | Credit Line Revolving | |
Previous Owner | $828,000 | New Conventional | |
Previous Owner | $110,250 | Credit Line Revolving | |
Previous Owner | $729,750 | New Conventional | |
Previous Owner | $887,000 | Negative Amortization | |
Previous Owner | $150,000 | Credit Line Revolving | |
Previous Owner | $742,500 | Unknown | |
Previous Owner | $75,000 | Credit Line Revolving | |
Previous Owner | $600,000 | Unknown | |
Previous Owner | $49,000 | Credit Line Revolving | |
Previous Owner | $556,000 | No Value Available | |
Previous Owner | $99,200 | Stand Alone Second | |
Previous Owner | $135,000 | Credit Line Revolving | |
Previous Owner | $70,000 | Credit Line Revolving | |
Previous Owner | $500,000 | Unknown | |
Previous Owner | $388,000 | No Value Available | |
Closed | $47,000 | No Value Available |
Property History
Date | Event | Price | Change | Sq Ft Price |
---|---|---|---|---|
08/15/2025 08/15/25 | Sold | $2,600,000 | +8.4% | $1,193 / Sq Ft |
07/21/2025 07/21/25 | Pending | -- | -- | -- |
07/10/2025 07/10/25 | For Sale | $2,398,000 | -- | $1,100 / Sq Ft |
Tax History Compared to Growth
Tax History
Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
---|---|---|---|---|
2025 | $23,863 | $1,945,591 | $1,203,008 | $742,583 |
2023 | $23,863 | $1,870,044 | $1,156,295 | $713,749 |
2022 | $23,638 | $1,833,377 | $1,133,623 | $699,754 |
2021 | $22,334 | $1,797,430 | $1,111,396 | $686,034 |
2020 | $21,399 | $1,779,000 | $1,100,000 | $679,000 |
2019 | $12,366 | $952,247 | $460,195 | $492,052 |
2018 | $11,743 | $933,577 | $451,172 | $482,405 |
2017 | $11,094 | $915,273 | $442,326 | $472,947 |
2016 | $11,184 | $897,327 | $433,653 | $463,674 |
2015 | $10,945 | $883,851 | $427,140 | $456,711 |
2014 | $10,960 | $866,538 | $418,773 | $447,765 |
Agents Affiliated with this Home
-
Seller's Agent in 2025
Caitlin McGinty
Coldwell Banker Realty
(650) 576-3994
1 in this area
46 Total Sales
-
Buyer's Agent in 2025
Julie Flouty
Compass
(650) 504-6900
7 in this area
189 Total Sales
Map
Source: MLSListings
MLS Number: ML82014074

APN: 039-102-050
- 2001 Alameda de Las Pulgas Unit 174
- 1919 Alameda de Las Pulgas Unit 97
- 1919 Alameda de Las Pulgas Unit 38
- 1919 Alameda de Las Pulgas Unit 26
- 1919 Alameda de Las Pulgas Unit 126
- 1951 Ofarrell St Unit 203
- 800 26th Ave
- 1513 Oak St
- 1224 Tilia St Unit 218
- 674 Barneson Ave
- 220 26th Ave
- 1202 Woodland Dr
- 1223 Rhus St
- 529 Hobart Ave
- 643 28th Ave
- 2506 Sage St
- 2432 Willow Way Unit 811
- 2305 Red Oak Ct
- 2434 Willow Way
- Plan B at The Heights - Overlook