OFF MARKET

Off Market Jun 2016 for $2.3M

$3,359,624

Est. refi paymentEst. refi $14,957/mo

•

3 ba

•

1,000

sq ft

509 Avila Rd, San Mateo, CA 94402

About this home

Rebuilt in 2010, this gorgeous Aragon residence offers a truly superior and sophisticated lifestyle. The spacious floorplan includes 4 bedrooms, 3 bathrooms, high-end finishes, custom details throughout, vaulted ceilings, recessed lighting, gorgeous Brazilian hardwood floors throughout living area, custom gourmet kitchen, limestone backsplash, and a large island that opens up to the family room. The master bedroom suite features vaulted ceilings, large master bathroom with soak-in tub and stall shower. The inviting patio with landscaped yard is perfect for entertaining. Highly desirable neighborhood with top rated schools. This is a must see!

Single-familyProperty Type

1937Year Built

5,000 sq ftLot Size

$3,360Est. Price/Sq.Ft.

1 car garageParking

Listed by • Redfin

•877-973-3346 (broker)

Bought with Raziel A. Ungar •DRE #01701234 • Coldwell Banker Realty

•650-558-4200 (broker)

Source:San Francisco MLS #427272

Redfin Estimate

$3,359,624

$1.0M since sold in June 2016$58K since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 8.9% higher than the average sale price ($3.09M) of 5 comparable homes.

SOLD JUL 30, 2026
$3,610,000
A
3 beds3 baths2,450 sq ft
401 Castilian Way, San Mateo, CA 94402
SOLD JUN 3, 2026
$3,100,000
B
4 beds2.5 baths2,410 sq ft
510 Aragon Blvd, San Mateo, CA 94402
SOLD MAY 7, 2026
$3,500,000
C
4 beds2.5 baths2,340 sq ft
229 Aragon Blvd, San Mateo, CA 94402
SOLD SEP 4, 2025
$2,550,000
D
3 beds3 baths2,199 sq ft
409 Seville Way, San Mateo, CA 94402
SOLD AUG 11, 2026
$2,670,000
E
3 beds2 baths2,025 sq ft
1549 Locust St, San Mateo, CA 94402

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$1,734,244

Est. take-home

List your home with Redfin and save $16,798

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$5,726/mo

Redfin rental estimate

List your home for rent

Market trends in 94402, CA

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

107.2%

1.0% MoM

Median sale price

$2.7M

$59K MoM

Avg. days on market

12d

0 days MoM

Recently sold homes

8 MoM

New listings for sale

$4,198,000
5 beds2.5 baths2,970 sq ft
769 Crescent Ave, San Mateo, CA 94402
OPEN TODAY, 10AM TO 12PM
$2,398,000
4 beds5 baths2,940 sq ft
1710-1712 Gum St, San Mateo, CA 94402
$2,788,000
4 beds3 baths2,944 sq ft
942 S Eldorado St, San Mateo, CA 94402
$4,488,000
4 beds3 baths2,668 sq ft
440 Hobart Ave, San Mateo, CA 94402
$1,195,000
3 beds1 bath1,935 sq ft
610 S Amphlett Blvd, San Mateo, CA 94402
See all

Provided by Redfin

Sale history for 509 Avila Rd

Date

Event

Price

Public Records

Jun 28, 2016

Sold

$2,320,000

$2,320/sq ft

Public Records

Dec 1, 2014

Sold

$2,280,000

$2,280/sq ft

MLSListings #ML81439503

Nov 10, 2014

Pending

—

Nov 10, 2014

Sold

$2,280,000

$2,280/sq ft

Nov 6, 2014

Listed

$1,928,000

$1,928/sq ft

+19

Rebuilt in 2010, this spacious floorplan includes 4 BD, 3 BA, high-end finishes & custom details, vaulted ceilings, recessed lighting, gorgeous Brazilian hardwood floors in living area, custom gourmet kitchen, limestone backsplash, & a large island. The master bedroom suite features large master bath with soak-in tub & stall shower. Inviting patio with landscaped yard. Top rated schools. Must see!

San Francisco MLS #427272

Dec 1, 2014

Sold

$2,280,000

$2,280/sq ft

Nov 10, 2014

Pending

—

Nov 6, 2014

Listed

$1,928,000

$1,928/sq ft

Public Records

Oct 25, 1996

Sold

$390,000

$390/sq ft

Public Records

Mar 20, 1986

Sold

$230,000

$230/sq ft

Public Records

Sep 14, 1984

Sold

$150,000

$150/sq ft

Year

Property tax

Land + Additions

Assessment*

2025

$33,249 (+0.3%)

$2,016,477 + $784,854

$2,801,331

2024

$33,164 (+4.1%)

$1,976,939 + $769,465

$2,746,404

2023

$31,870 (+0.6%)

$1,938,176 + $754,378

$2,692,554

2022

$31,665 (+2.6%)

$1,900,173 + $739,587

$2,639,760

2021

$30,863 (+3.0%)

$1,862,915 + $725,086

$2,588,001

2020

$29,961 (+3.3%)

$1,826,388 + $710,869

$2,537,257

2019

$29,017 (+3.8%)

$1,807,661 + $703,580

$2,511,241

2018

$27,946

$1,772,217 + $689,785

$2,462,002

2017

$27,961 (+2.6%)

$1,703,400 + $663,000

$2,366,400

2016

$27,263 (+3.1%)

$1,703,400 + $663,000

$2,366,400

2015

$26,436 (+171.1%)

$1,157,385 + $1,157,385

$2,314,770

2014

$9,751 (+5.2%)

$259,070 + $543,376

$802,446

2012

$9,273 (+2.8%)

$257,900 + $540,922

$798,822

2011

$9,023 (+1.6%)

$252,844 + $530,317

$783,161

2010

$8,883 (+56.7%)

$247,887 + $519,920

$767,807

2009

$5,670 (+0.2%)

$246,035 + $516,035

$762,070

2008

$5,659

$246,620 + $246,620

$493,240

Tax history for 509 Avila Rd

Year

Property tax

Land + Additions

Assessment*

2025

$33,249 (+0.3%)

$2,016,477 + $784,854

$2,801,331

2024

$33,164 (+4.1%)

$1,976,939 + $769,465

$2,746,404

2023

$31,870 (+0.6%)

$1,938,176 + $754,378

$2,692,554

2022

$31,665 (+2.6%)

$1,900,173 + $739,587

$2,639,760

2021

$30,863 (+3.0%)

$1,862,915 + $725,086

$2,588,001

2020

$29,961 (+3.3%)

$1,826,388 + $710,869

$2,537,257

2019

$29,017 (+3.8%)

$1,807,661 + $703,580

$2,511,241

2018

$27,946

$1,772,217 + $689,785

$2,462,002

2017

$27,961 (+2.6%)

$1,703,400 + $663,000

$2,366,400

2016

$27,263 (+3.1%)

$1,703,400 + $663,000

$2,366,400

2015

$26,436 (+171.1%)

$1,157,385 + $1,157,385

$2,314,770

2014

$9,751 (+5.2%)

$259,070 + $543,376

$802,446

2012

$9,273 (+2.8%)

$257,900 + $540,922

$798,822

2011

$9,023 (+1.6%)

$252,844 + $530,317

$783,161

2010

$8,883 (+56.7%)

$247,887 + $519,920

$767,807

2009

$5,670 (+0.2%)

$246,035 + $516,035

$762,070

2008

$5,659

$246,620 + $246,620

$493,240

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Zoning

R1C

Single-Family Residence Districts

The R1 Single-Family Residence Districts are intended to create, preserve and enhance areas suitable for single-family dwellings with a substantial presence of open space and opportunities for outdoor living. The R1 districts are intended to protect the character and variety of neighborhoods, preserve privacy and prevent burdens on public facilities, while allowing reasonable housing opportunities for families.

Permitted uses

Include but are not limited to:

Day care facility
Housing-Single unit
Housing-Mobile home park

Property details

Interior

Bathroom Information
# of Full Baths: 3

Heating & Cooling
Air Conditioning Type: Central

Fireplace Information
# of Fireplaces: 1
Has Fireplace

Room Information
# of Rooms: 8

Exterior

Exterior Information
Physical Condition: Good
Building Style Type: Ranch
Construction Type: Wood/Steel
Building Construction Quality: Good
Exterior Wall: Stucco
Building Type: Detached
Building Improvement Type: Detached

View Information
View: Good

Property Information
Subdivision Name: ARAGON SUB 5
Living Sq. Ft: 1,000
Ground Floor Sq. Ft: 1,000
Building Sq. Ft: 1,260
# of Stories: 1
Legal Description: LOT 8 BLOCK 26 ARAGON SUB NO 5 RSM 20/73 74 CITY OF SAN MATEO

Parking & Garage Information
# of Parking Spaces: 1
Parking Type: Attached Garage
Garage/Parking Sq. Ft: 260
Garage / Carport Type: Attached

Lot Information
# of Buildings: 1
Land Sq. Ft: 5,000
Legal Lot Number: 8
Legal Block Number: 26
Acres: 0.1148
Depth Footage: 100
Front Footage: 50
Zoning Code: R10006
County Use Description: SINGLE FAMILY

Utility Information
Sewer Type: Public
Water Service Type: Public

Financial

Assessor Information
Assessment Year: 2026

Public facts

Beds: 4
Baths: 3.0
Sq. Ft.: 1,000
Stories: 1.0
Lot Size: 5,000 square feet
Style: Single Family Residential
Year Built: 1937
Year Renovated: 1987
County: San Mateo County
APN: 034243070

Home facts updated by county records on Sep 2, 2026

Around this home

Schools

Baywood Elementary School

Public K-5 • Assigned • 0.3mi

7/10

Borel Middle School

Public 6-8 • Assigned • 0.2mi

8/10

Aragon High School

Public 9-12 • Assigned • 0.2mi

10/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Local insights from Redfin agents

San Mateo stayed one of the Peninsula's busiest markets. Homes averaged 110% of asking price, and buyers continue to compete for updated homes in neighborhoods like Aragon, Baywood and Beresford Park.
1 month ago • San Mateo
Sasai Zhang
Redfin Premier agent
182 deals
Was this helpful?

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

2/10 Heat Factor

7 days above 86° expected this year, 15 days in 30 years

1/10 Wind Factor

Minimal risk of severe winds over next 30 years

7/10 Air Factor

12 unhealthy days expected this year, 12 days in 30 years

Provided by First Street

Historical weather

San Mateo, CA • 94402

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 10.8 hours in June and 5 hours in December, placing it above the U.S. average for solar exposure.

10.8 hrs

5 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$3.19M – $3.86M

Reach more buyers when you sell with Redfin. Save up to $33,596 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

$2,898,000

4 beds3 baths2,010 sq ft

751 27th Ave, San Mateo, CA 94403

3D WALKTHROUGH

$11,475,000

6 beds7 baths6,430 sq ft

280 Uplands Dr, Hillsborough, CA 94010

$4,488,000

4 beds3 baths2,668 sq ft

440 Hobart Ave, San Mateo, CA 94402

$2,788,000

4 beds3 baths2,944 sq ft

942 S Eldorado St, San Mateo, CA 94402

$2,599,000

3 beds2.5 baths2,319 sq ft

39 Live Oak Dr, San Mateo, CA 94403

New listings for sale in 94402

$4,198,000

5 beds2.5 baths2,970 sq ft

769 Crescent Ave, San Mateo, CA 94402

OPEN TODAY, 10AM TO 12PM3D & VIDEO TOUR

$2,398,000

4 beds5 baths2,940 sq ft

1710-1712 Gum St, San Mateo, CA 94402

$2,788,000

4 beds3 baths2,944 sq ft

942 S Eldorado St, San Mateo, CA 94402

$4,488,000

4 beds3 baths2,668 sq ft

440 Hobart Ave, San Mateo, CA 94402

$1,195,000

3 beds1 bath1,935 sq ft

610 S Amphlett Blvd, San Mateo, CA 94402

Home values near 509 Avila Rd

Data from public records.

Address	Redfin Estimate
506 Avila Rd, San Mateo, CA 3 Beds \| 3 Baths \| 1370 Sq. Ft.	$2,678,312
518 Avila Rd, San Mateo, CA 4 Beds \| 3 Baths \| 2610 Sq. Ft.	$3,370,136

Address	Redfin Estimate
514 Avila Rd, San Mateo, CA 2 Beds \| 1 Baths \| 1300 Sq. Ft.	$2,256,597
413 Avila Rd, San Mateo, CA 3 Beds \| 3 Baths \| 2160 Sq. Ft.	$2,291,848

Address	Redfin Estimate
502 Avila Rd, San Mateo, CA 5 Beds \| 3.5 Baths \| 3054 Sq. Ft.	$3,220,994
409 Avila Rd, San Mateo, CA 4 Beds \| 3 Baths \| 2390 Sq. Ft.	$3,185,939

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

94010 homes for sale
94402 homes for sale
94403 homes for sale
94404 homes for sale
94002 homes for sale

Houses for rent in San Mateo	Agents near me	Irvine, CA homes for sale	San Mateo Housing Market
Houses for sale near me	San Diego, CA homes for sale	Fremont, CA homes for sale
Land for sale near me	San Francisco, CA homes for sale	Pasadena, CA homes for sale
Open Houses near me	Los Angeles, CA homes for sale	San Mateo Property Records
Condos for sale near me	San Jose, CA homes for sale	CA New Listings

Central San Mateo homes for sale
Northwest Heights homes for sale
Aragon / Baywood homes for sale

San Jose homes for sale
San Francisco homes for sale
Fremont homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 94402, CA

Sale history for 509 Avila Rd

Tax history for 509 Avila Rd

Zoning

Property details

Around this home

Schools

Lifestyle

Local insights from Redfin agents

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 94402

Home values near 509 Avila Rd

More real estate resources