$2,600,000
SOLD AUG 15, 2025
3 Beds
3 Baths
2,180 Sq Ft
7,379 Sq Ft Lot

Recently Sold

$1,193 Per Sq Ft

8% Above List Price

10 Days on Market

Highlights

  • Primary Bedroom Suite
  • Skyline View
  • Vaulted Ceiling
  • Aragon High School Rated A+
  • Deck
  • Wood Flooring

About This Home

As of August 2025

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.

Last Agent to Sell the Property

Caitlin McGinty

Coldwell Banker Realty License #01965149 Listed on: 07/10/2025

Coldwell Banker Realty

Last Buyer's Agent

Julie Flouty

Compass License #01901710

Compass

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

Home Details

Home Type

Single Family

Est. Annual Taxes

$23,863

Year Built

Built in 1947

Lot Details

0

Parking

2

Listing Details

  • Subclass: Single Family Home
  • Age: 78
  • Listing Class: Residential
  • Structure Sq Ft: 2180
  • Year Built: 1947
  • Zoning Description: R10006
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: Separate Family Room
  • Fireplace: Gas Burning
  • Dining Room: Dining Area
  • Kitchen: Built-in BBQ Grill, Countertop - Quartz, Dishwasher, Hood Over Range, Oven - Gas, Oven Range - Gas, Refrigerator, Skylight
  • Living Sq Ft: 2180
  • Stories: 1
  • Bedrooms: Primary Suite / Retreat, Walk-in Closet
  • Laundry: In Utility Room, Washer / Dryer
  • Flooring: Hardwood, Tile
  • Fireplaces Min: 1
  • Maximum Numberof Bedrooms: 3
  • Minimum Numberof Bedrooms: 3
  • Full Bathrooms: 3
  • Total Bedrooms: 3
  • Bathroom: Primary - Stall Shower(s), Shower over Tub - 1, Skylight, Stall Shower - 2+
  • Fireplace: Yes

Exterior Features

  • Foundation: Crawl Space
  • Roof: Composition
  • Yard/Grounds: Balcony / Patio, Deck, Fire Pit, Low Maintenance, Outdoor Kitchen

Garage/Parking

  • Garage Spaces: 2
  • Parking Spaces: 3
  • Garage Max: 2
  • Garage Min: 2
  • Garage Parking Features: Detached Garage, Off-Street Parking, On Street, Room for Oversized Vehicle

Utilities

  • Cooling System: Central AC
  • Heating System: Central Forced Air - Gas
  • Sewer/Septic System: Sewer - Public

Association/Amenities

  • Amenities Miscellaneous: High Ceiling, Skylight, Vaulted Ceiling, Walk-in Closet

Schools

  • School District: San Mateo Union High
  • High School: Aragon High
  • High School: 602

Lot Info

  • Parcel Number: 039-102-050
  • Lot Acres: 0.1694
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 7379.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 7379.00

Multi Family

  • Utilities: Public Utilities

MLS Schools

  • High School District Text: San Mateo Union High
  • High School Text: Aragon High

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Nov 13, 2019
Sold by
Riva Jim De La and Riva Roxanne A De La
Bought by
Mangum Kristen Suzanne and Mangum Robert Edward

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,423,200
Outstanding Balance
$1,258,667
Interest Rate
3.65%
Mortgage Type
New Conventional
Estimated Equity
$1,073,260

Purchase Details

Closed on
Jun 4, 2019
Sold by
Delariva Jim De and De La Riva Roxanne A
Bought by
Delariva Jim and Delariva La Riva

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$350,000
Interest Rate
4.2%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
May 24, 2019
Sold by
Delariva Jim De and De La Riva Roxanne A
Bought by
Delariva Jim and Delariva La Riva

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$350,000
Interest Rate
4.2%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Jun 24, 2011
Sold by
Dela Riva Roxanne A
Bought by
Delariva Jim and Delariva Roxanne A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$110,250
Interest Rate
4.54%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Nov 9, 2006
Sold by
Dela Riva Jim and De La Riva Roxanne
Bought by
Delariva Jim and Delariva Roxanne A

Purchase Details

Closed on
May 16, 2006
Sold by
Dela Riva Roxanne
Bought by
Delariva Jim and Delariva Roxanne

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$887,000
Interest Rate
6.22%
Mortgage Type
Negative Amortization

Purchase Details

Closed on
Sep 10, 2004
Sold by
Delariva Jim and Delariva Roxanne
Bought by
Delariva Roxanne

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$150,000
Interest Rate
5.94%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Nov 29, 2001
Sold by
Noble John A and Cherene Noble Angela
Bought by
Delariva Jim and Delariva Roxanne

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$556,000
Interest Rate
6.75%

Purchase Details

Closed on
Sep 16, 1997
Sold by
Appling David A and Bloch Elizabeth A Tr
Bought by
Noble John A and Cherene Noble Angela

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$388,000
Interest Rate
7.12%
Source: Public Records

Similar Homes in San Mateo, CA

  • 706 S Humboldt St, San Mateo, CA 94402

    $1,968,000

    • 3 Beds
    • 1.5 Baths
    • 1,630 Sq Ft
    • 706 S Humboldt St
    • San Mateo, CA

    Set on an expansive 7,000 +/- square foot R2, level lot, this property offers incredible potential for future expansion or the addition of an ADU. Whether you envision creating a multi-generational living space, generating rental income, or simply designing your dream backyard retreat, the possibilities are endless. Located in one of San Mateo's most enticing and charming neighborhoods, this

    Julie Flouty Compass

    Section Image
  • 800 26th Ave, San Mateo, CA 94403

    $3,100,000

    • 3 Beds
    • 2.5 Baths
    • 2,940 Sq Ft
    • 800 26th Ave
    • San Mateo, CA

    Sweeping Golf Course & Bay Views in Coveted Beresford Park Neighborhood. Nestled at the end of a tranquil cul-de-sac in San Mateos highly desirable Beresford Park neighborhood, this spacious home offers approx. 2,940 sq ft of refined living on a generous, park-like 9,000+ sq ft lot. Enjoy stunning vistas of the Peninsula Country Club golf course & the bay beyond. The elegant floor plan features

    Greg Garcia Sequoia Realty Services

    Section Image
  • 1513 Oak St, San Mateo, CA 94402

    $2,288,000

    • 3 Beds
    • 2 Baths
    • 1,580 Sq Ft
    • 1513 Oak St
    • San Mateo, CA

    Welcome to this sunny 1580 SF 3-bed, 2-bath home located in the sought-after Husing Estates area of SM. Great curb appeal, inviting front porch, lovely entry into an expansive, high-ceiling living room with recessed lights & a wood-burning fireplace, plus a large light-filling picture window. Spacious remodeled kitchen offers an abundance of cabinetry and counter space, plus a six-burner gas

    Miriam Chirko Coldwell Banker Realty

    Section Image
  • 1224 Tilia St Unit 218, San Mateo, CA 94402

    $1,988,000

    • 3 Beds
    • 2 Baths
    • 1,450 Sq Ft
    • 1224 Tilia St
    • Unit 218
    • San Mateo, CA

    Welcome to a charming single-family home located in the heart of San Mateo. This inviting residence boasts 1,450 square feet of comfortable living space with three bedrooms and two full bathrooms with a bonus room off the garage. The home's kitchen is a highlight, featuring modern amenities such as a new gas cooktop, new quartz countertops, new built-in double oven, new dishwasher, garbage

    Stephanie Russell Elite Properties

    Section Image
  • 674 Barneson Ave, San Mateo, CA 94402

    $2,198,000

    • 3 Beds
    • 2 Baths
    • 2,610 Sq Ft
    • 674 Barneson Ave
    • San Mateo, CA

    FIRST TIME ON THE MARKET IN 60 YEARS! Here is a Truly Unique Opportunity to Add Value and Build Out your Dream Home on this EXTREMELY RARE Prime West Side San Mateo 21,076 Square Foot Lot! On a Flag lot, this Parcel can be Described as a Park with Endless Possibilities. Must See to Appreciate! Property Recently Appraised at just over 2.8M. Motivated Seller! No pre-emptive offers please.

    Neel Bhatia Coldwell Banker Realty

    Section Image
  • 1202 Woodland Dr, San Mateo, CA 94402

    $1,999,000

    • 3 Beds
    • 2 Baths
    • 1,550 Sq Ft
    • 1202 Woodland Dr
    • San Mateo, CA

    Owned and lovingly maintained by the same family for decades, 1202 Woodland Drive is a sprawling ranch-style home located in one of San Mateos most desirable neighborhoods. This light-filled 3-bedroom, 2-bath residence offers timeless curb appeal, a functional single-level layout, and thoughtful updates throughout. Enjoy an updated kitchen with quartz countertops and a brand-new stainless steel

    Stephen Marshall Christie's International Real Estate Sereno

    Section Image
  • 1223 Rhus St, San Mateo, CA 94402

    $1,998,000

    • 2 Beds
    • 1 Bath
    • 1,150 Sq Ft
    • 1223 Rhus St
    • San Mateo, CA

    Welcome to this enchanting and timeless 2-bedroom, 1-bath gem nestled in the heart of San Mateo. Set on a picturesque, tree-lined street, this home blends vintage charm with tasteful, modern updates. Step into a light-filled, open-concept kitchen featuring a Monogram range, statuario marble countertops, and sleek stainless-steel appliances. The inviting dining and living rooms offer comfortable,

    Julie Alsaegh Compass

    Section Image
  • 529 Hobart Ave, San Mateo, CA 94402

    $2,598,000

    • 4 Beds
    • 3 Baths
    • 1,499 Sq Ft
    • 529 Hobart Ave
    • San Mateo, CA

    Exquisitely renovated luxury custom-built home combining elegance, comfort, and modern convenience. The open-concept living, dining, and kitchen area creates an inviting atmosphere for both everyday living and memorable gatherings. Two primary suites, two additional bedrooms, and a stylish hall bath offer flexibility for family or guests. The gourmet chefs kitchen, appointed with premium

    David Wang Keller Williams Palo Alto

    Section Image
  • 643 28th Ave, San Mateo, CA 94403

    $2,698,000

    • 4 Beds
    • 3 Baths
    • 2,470 Sq Ft
    • 643 28th Ave
    • San Mateo, CA

    Welcome to this beautifully updated 4 bed, 3 bath home in the coveted Beresford Park neighborhood. Reimagined down to the studs in 2002, this home offers the ideal modern layout. The open kitchen with walk-in pantry, stainless steel appliances, and 6-burner gas range flows into both the dining & family rooms- perfect for entertaining or everyday living. The two-level floor plan includes 3

    Casey Sternsmith Compass

    Section Image

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

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
Source: Public Records

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
Source: Public Records

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
Source: MLSListings

Tax History Compared to Growth

Source: Public Records

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
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML82014074

MLSListings

APN: 039-102-050