509 Madera Dr, San Mateo, CA 94403 - Photo 1

1/1

$2,600,000

Sold
Closed
Single Family
3 Beds
3 Full Baths
2,180 Sq. Ft.
2 Car Garage

1/1

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

Full Property Details

Full Property Details for 509 Madera Dr

General

Sold For: $2,600,000
Status: Closed
Type: Single Family
Source: RE_Infolink
MLS ID: ML82014074
Added to Site: 219 day(s) ago

Interior

Interior Features: High Ceiling , Skylight, Vaulted Ceiling , Walk-In Closet
Fireplace(s): Gas-Burning
Flooring: Hardwood, Tile

Rooms

Bathrooms

Total Bathrooms: 3
Full Bathrooms: 3
Bathroom Features: Primary - Stall Shower(s), 1 Shower over Tub, Skylight , 2 Stall Showers or More

Bedrooms

Total Bedrooms: 3
Bedroom Features: Primary Suite / Retreat, Walk-In Closet

Other Rooms

Family Room: Separate Family Room
Kitchen: Built-In Barbeque Grill, Countertop - Quartz, Dishwasher, Hood over Range, Gas Oven, Gas Oven/Range, Refrigerator, Skylight
Laundry: In Utility Room, Washer / Dryer

Additional Information

Extras: Not Applicable

Parking

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

Location

Area: San Mateo Terrace Etc.
County: San Mateo
Cross Streets: Alameda de las Pulgas

Heating & Cooling

Cooling Type: Central AC
Heating Type: Central Air (Gas/Forced Air)

Utilities

Sewer: Public Sewer
Water: Public
Utility Description: Public Utilities

Structural Information

Construction: Detached
Foundation: Crawlspace
Roof: Composition
Square Feet: 2,180
Year Built: 1947

Lot Features

Lot Size (Acres): 0.1694
Minimum Lot Size: 7379
Lot Size (Sq. Ft.): 7,379
Grounds/Landscape: Balcony / Patio, Deck , Firepit, Low Maintenance, Outdoor Kitchen
Zoning: R10006

What's Your Home Worth?

* Indicates a required field

For a complimentary comparative market analysis, please contact us so we can discuss your home's value.

Your Property Information

Address optional

City *State *

Zip Code optional

Your Contact Information

First Name *Last Name *

Email Address *

Phone Number *

Comment *

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Submit, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

Meet the listing agent

— 509 Madera Dr —

Caitlin Beanan

CalRE#: 01965149

Email Me

(650) 576-3994 mobile

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender

NMLS#: 1598647

Get Pre-Approved

Schools

Schools serving 509 Madera Dr

School Districts:San Mateo-Foster City Elementary School District, San Mateo Union High School District

Name	Grades	Distance
Meadow Heights Elementary School 2619 Dolores Street, San Mateo, CA 94403	K-5	0.4 mi
Abbott Middle School 600 36th Avenue, San Mateo, CA 94403	6-8	1.1 mi
Aragon High School 900 Alameda de las Pulgas, San Mateo, CA 94402	9-12	0.7 mi

Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 509 Madera Dr

Date

Details

Price

Change

Source

8/15/2025

Sold

$2,600,000

8.42%

MLS

7/10/2025

Listed

$2,398,000

—

MLS

Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

1500 Willow Ave 301, Burlingame, CA 94010 - Photo 1

Just Listed

$895,000

Open House

1500 Willow Ave 301 Burlingame, CA 94010

Condo
Active
Updated 1 day ago

2
Beds
2
Total Baths
1,453
Sq. Ft.

Listed by Compass, Raziel A. Ungar

1228 Capuchino Ave, Burlingame, CA 94010 - Photo 1

Just Listed

$1,950,000

Open House

1228 Capuchino Ave Burlingame, CA 94010

Single Family
Active
Updated 2 days ago

3
Beds
1
Total Bath
1,400
Sq. Ft.

Listing provided by Victoria Maxwell, Real Estate Broker, Victoria L Maxwell

839 Crossway Rd, Burlingame, CA 94010 - Photo 1

Just Listed

$4,688,000

Open House

839 Crossway Rd Burlingame, CA 94010

Single Family
Active
Updated 2 days ago

5
Beds
4
Total Baths
3,075
Sq. Ft.

Listed by eXp Realty of California Inc, Mike Danao

1144 Bernal Ave, Burlingame, CA 94010 - Photo 1

Just Listed

$4,450,000

Open House

1144 Bernal Ave Burlingame, CA 94010

Single Family
Active
Updated 22 hours ago

4
Beds
5
Total Baths
2,710
Sq. Ft.

Listed by Golden Gate Sotheby's International Realty, Jenn Gilson

1111 Laguna, Burlingame, CA 94010 - Photo 1

Price Reduced

-$151,000 (-4.79%)

$2,999,000

1111 Laguna Burlingame, CA 94010

Single Family
Active
Updated 3 days ago

6
Beds
4
Total Baths
3,050
Sq. Ft.

Listed by Margaret Duffy (CalRE#: 01810445) (650) 676-0294

1433 Floribunda Ave 8, Burlingame, CA 94010 - Photo 1

1433 Floribunda Ave 8 Burlingame, CA 94010

Condo
Active
Updated 2 days ago

2
Beds
3
Total Baths
1,314
Sq. Ft.

Listed by Compass, John Sayage

219 Commons Ln, Foster City, CA 94404 - Photo 1

219 Commons Ln Foster City, CA 94404

Townhouse
Active
Updated 1 day ago

2
Beds
2
Total Baths

Listed by Alliance Bay Realty, Jun Li and Alliance Bay Realty, Fiona Yi Shi

400 El Camino Real 107, Belmont, CA 94002 - Photo 1

400 El Camino Real 107 Belmont, CA 94002

Condo
Active
Updated 4 days ago

3
Beds
3
Total Baths
1,770
Sq. Ft.

Listed by Fei Cheng (CalRE#: 02225245) (202) 830-7998

467 22nd Ave, San Mateo, CA 94403 - Photo 1

Sold

$2,975,000

467 22nd Ave San Mateo, CA 94403

Single Family
Closed

3
Beds
4
Total Baths
2,509
Sq. Ft.

Listed by Compass, Jeannette Dane
Sold by Apr, Rosa Baltodano

472 Gymkhana Rd, San Mateo, CA 94403 - Photo 1

Sold

$2,345,000

472 Gymkhana Rd San Mateo, CA 94403

Single Family
Closed

3
Beds
2
Total Baths
1,840
Sq. Ft.

Listed by KW Advisors, The Laugesen Team
Sold by Fqlt, Jocelyn Xie and Sean Chen, Broker, Anna J Wang

445 23rd Ave, San Mateo, CA 94403 - Photo 1

Sold

$2,360,000

445 23rd Ave San Mateo, CA 94403

Single Family
Closed

3
Beds
2
Total Baths
1,560
Sq. Ft.

Listed by Intero Real Estate Services, Connie Gerlach and Eva Yao (CalRE#: 02105559)
Sold by Ivy Liang (CalRE#: 02045256)

722 26th Ave, San Mateo, CA 94403 - Photo 1

Sold

$2,300,000

722 26th Ave San Mateo, CA 94403

Single Family
Closed

3
Beds
2
Total Baths
1,710
Sq. Ft.

Listed by Intero Real Estate Services, Julie Halpin
Sold by Daniel Choi (CalRE#: 02022554)

509 Madera Dr, San Mateo, CA 94403 (MLS# ML82014074) is a Single Family property that was sold at $2,600,000 on August 15, 2025. This property was listed by Caitlin Beanan from our Burlingame Office.Want to learn more about 509 Madera Dr? Do you have questions about finding other Single Family real estate for sale in San Mateo? You can browse all San Mateo real estate or contact a Coldwell Banker agent to request more information.

509 Madera Dr San Mateo, CA 94403