540 Chelmsford Rd, Hillsborough, CA 94010

Off market sep 2023 for $5.6M

$7,783,721

Est. refi paymentEst. refi $37,185/mo

•

4,125

sq ft

540 Chelmsford Rd, Hillsborough, CA 94010

About this home

ARCHITECTURAL HAUTE COUTURE: LOWER HILLSBOROUGH CLASSIC, RE-IMAGINED!!! A Secret Office fit for James Bond?! A Primary Walk-In Closet the size of your first New York apartment?! Welcome to a world of character and quality! Built in 1930, this English Country estate bridges the best of storybook chic with a fully remodeled lifestyle of modern luxury. Walk directly from kitchen to yard with no stairs! The energy soars "of the moment" with re-imagined renovations. White marble finishes, appliances by Wolf and Sub-Zero, & expert custom cabinetry cascade throughout 4,125 sq. ft. of destinations. * 4 beds, 4.5 baths, plus Office and Lower Level Media Room. * 3 En Suites with remodeled bathrooms together * Additional Loft Level for playroom/4th bed with bath * Lower Level Media Room or Gym adjoins Mud Room * Total Privacy in Rear Yard * Updated Marvin windows and doors * Chelmsford Road is a rarely available location within 1.2 miles of downtown Burlingame and 0.7 mile to South Elementary!

Single-familyProperty Type

1930Year Built

0.35 acresLot Size

$1,887Est. Price/Sq.Ft.

2 car garageParking

Listed by Geoffrey Nelson •DRE #01313666 • Coldwell Banker Realty

Bought with Geoffrey Nelson •DRE #01313666 • Coldwell Banker Realty

Redfin checked: a minute ago

•Source:MLSListings #ML81935027

Redfin Estimate

$7,783,721

$2.1M since sold in September 2023$219K since October

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 24.3% higher than the average sale price ($6.26M) of 6 comparable homes.

SOLD SEP 14, 2026
$6,000,000
A
4 beds3.5 baths3,440 sq ft
336 Brentwood Rd, Hillsborough, CA 94010
SOLD MAY 11, 2026
$6,700,000
B
4 beds4.5 baths3,380 sq ft
755 Bromfield Rd, Hillsborough, CA 94010
SOLD MAR 11, 2026
$6,500,000
C
4 beds4.5 baths3,710 sq ft
414 Edgewood Rd, San Mateo, CA 94402
SOLD OCT 13, 2026
$6,800,000
D
4 beds3.5 baths3,802 sq ft
128 Clark Dr, San Mateo, CA 94402
SOLD JUN 9, 2026
$5,420,000
E
4 beds3 baths3,680 sq ft
641 Crescent Ave, San Mateo, CA 94402
SOLD OCT 23, 2026
$6,155,000
F
4 beds3.5 baths3,380 sq ft
342 Parrott Dr, 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

$3,123,076

Est. take-home

List your home with Redfin and save $38,919

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$9,993/mo

Redfin rental estimate

List your home for rent

Market trends in 94010, CA

Last updated October 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-list price

106.2%

0.5% MoM

Median sale price

$3.6M

$417K MoM

Avg. days on market

17d

3 days MoM

Recently sold homes

110

8 MoM

New listings for sale

OPEN TODAY, 1:30PM TO 4PM
$5,295,000
3 beds3 baths2,575 sq ft
1580 Barroilhet Ave, Burlingame, CA 94010
OPEN TODAY, 2PM TO 4PM
$2,398,000
3 beds3 baths995 sq ft
804 Howard Ave, Burlingame, CA 94010
OPEN TODAY, 2PM TO 4PM
$3,998,000
3 beds3 baths2,630 sq ft
952 Tournament Dr, Hillsborough, CA 94010
$3,500,000
— beds— baths4,144 sq ft
Chula Vis, Burlingame, CA 94010
1123 Chula Vista Ave, Burlingame, CA 94010
$3,500,000
— beds— baths4,144 sq ft
1123 Chula Vista Ave, Burlingame, CA 94010
OPEN TODAY, 2PM TO 4PM
$5,488,000
5 beds4.5 baths4,255 sq ft
200 Darrell Rd, Hillsborough, CA 94010
$13,999,000
5 beds5.5 baths5,155 sq ft
2170 Edgecourt Dr, Hillsborough, CA 94010
$4,900,000
— beds— baths7,722 sq ft
1441 Bellevue Ave, Burlingame, CA 94010
$4,900,000
4 beds4 baths7,722 sq ft
Bellevue, Hillsborough, CA 94010
$3,698,000
4 beds3 baths2,730 sq ft
2104 Hale Dr, Burlingame, CA 94010
See all

Provided by Redfin

Sale history for 540 Chelmsford Rd

Year

Property tax

Land + Additions

Assessment*

2025

$70,523 (+2.1%)

$3,953,520 + $1,924,740

$5,878,260

2024

$69,068 (+59.8%)

$3,876,000 + $1,887,000

$5,763,000

2023

$43,231 (+4.2%)

$3,800,000 + $1,850,000

$5,650,000

2022

$41,480 (+2.2%)

$2,414,562 + $931,185

$3,345,747

2021

$40,601 (+1.8%)

$2,367,218 + $912,927

$3,280,145

2020

$39,880 (+2.4%)

$2,320,802 + $895,028

$3,215,830

2019

$38,941 (+3.1%)

$2,297,006 + $885,851

$3,182,857

2018

$37,779 (+1.8%)

$2,251,967 + $868,482

$3,120,449

2017

$37,119 (+2.7%)

$2,164,521 + $834,759

$2,999,280

2016

$36,131 (+11.7%)

$2,164,521 + $834,759

$2,999,280

2015

$32,345 (+2.7%)

$2,122,080 + $818,392

$2,940,472

2014

$31,499 (+422.1%)

$2,049,261 + $502,069

$2,551,330

2012

$6,033 (+9.2%)

$2,040,000 + $499,800

$2,539,800

2011

$5,526 (+3.1%)

$71,655 + $177,525

$249,180

2010

$5,359 (+1.5%)

$70,250 + $174,045

$244,295

2009

$5,278 (+2.1%)

$69,725 + $172,745

$242,470

2008

$5,171

$69,891 + $173,156

$243,047

Tax history for 540 Chelmsford Rd

Year

Property tax

Land + Additions

Assessment*

2025

$70,523 (+2.1%)

$3,953,520 + $1,924,740

$5,878,260

2024

$69,068 (+59.8%)

$3,876,000 + $1,887,000

$5,763,000

2023

$43,231 (+4.2%)

$3,800,000 + $1,850,000

$5,650,000

2022

$41,480 (+2.2%)

$2,414,562 + $931,185

$3,345,747

2021

$40,601 (+1.8%)

$2,367,218 + $912,927

$3,280,145

2020

$39,880 (+2.4%)

$2,320,802 + $895,028

$3,215,830

2019

$38,941 (+3.1%)

$2,297,006 + $885,851

$3,182,857

2018

$37,779 (+1.8%)

$2,251,967 + $868,482

$3,120,449

2017

$37,119 (+2.7%)

$2,164,521 + $834,759

$2,999,280

2016

$36,131 (+11.7%)

$2,164,521 + $834,759

$2,999,280

2015

$32,345 (+2.7%)

$2,122,080 + $818,392

$2,940,472

2014

$31,499 (+422.1%)

$2,049,261 + $502,069

$2,551,330

2012

$6,033 (+9.2%)

$2,040,000 + $499,800

$2,539,800

2011

$5,526 (+3.1%)

$71,655 + $177,525

$249,180

2010

$5,359 (+1.5%)

$70,250 + $174,045

$244,295

2009

$5,278 (+2.1%)

$69,725 + $172,745

$242,470

2008

$5,171

$69,891 + $173,156

$243,047

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

Public record

Public record
Permits

Beds

Baths

4.5

Stories

Lot width

—

Lot depth

—

Lot size

0.35 Acres

Year renovated

1964

Sq. Ft.

2,955

Year built

1930

Style

Single Family Residential

County

San Mateo County

APN

031205060

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Sep 2, 2026.

Property details

Parking

Garage Information
# of Garage Spaces: 2
Has Attached Garage: Yes

Parking Information
Has Garage: Yes
Parking Features: Attached Garage

Interior

Virtual Tour

Bedroom Information
Bedroom Features: Primary Suite/Retreat

Bathroom Information
# of Baths (Full): 4
# of Baths (1/2): 1
Bathroom Features: Double Sinks, Marble, Updated Bath(s), Primary Oversized Tub

Appliances
Double Oven

Dining Room Information
Breakfast Bar, Eat-In Kitchen, Formal Dining Room

Family Room Information
Kitchen/Family Room Combo

Fireplace Information
# of Fireplaces: 3
Fireplace Features: Family Room, Gas Log, Living Room, Primary Bedroom, Wood Burning

Flooring Information
Hardwood, Marble

Interior Features
Interior Features: High Ceiling, Vaulted Ceiling, Open Beam Ceiling, Walk-In Closet

Laundry Information
Laundry Features: Inside

Room Information
Room Type: Loft, Media Room, Office

Kitchen Information
Kitchen Features: Marble Countertop, Island with Sink

Exterior

Building Information
Foundation Details: Concrete Perimeter and Slab
Roof: Composition

Pool Information
Pool Features: In Ground

Stories
Stories: 1

Style
Architectural Style: Country English, English, Luxury

Year Built
Year Built Details: 2

Property Information
Building Area Total (Sq. Ft.): 4,125

Financial

Financial Information
Buyer Financing: Cash

Utilities

Heating & Cooling
Heating: Central Forced Air (Gas), Heating (2+ Zones)

Utility Information
Gas: Public Utilities
Sewer: Public Sewer
Utilities: Public Utilities, Public Water
Water Source: Public

Location

School Information
Elementary School: South Hillsborough
Elementary School District: Hillsborough City Elementary
High School District: San Mateo Union High
Middle/Junior High School: Crocker Middle

Location Information
MLS Area: Hillsborough Heights
Street Name: Chelmsford
Street Number: 540

WalkScore Information
Walk Score: 25

Public facts

Beds: 4
Baths: 4.5
Sq. Ft.: 2,955
Stories: 1.0
Lot Size: 0.35 acres
Style: Single Family Residential
Year Built: 1930
Year Renovated: 1964
County: San Mateo County
APN: 031205060

Home facts updated by county records on Sep 2, 2026

Around this home

Schools

K - 12
Preschool & daycare

South Hillsborough School

Public K-5 • Assigned • 0.5mi

9/10

Crocker Middle School

Public 6-8 • Assigned • 0.9mi

8/10

San Mateo High School

Public 9-12 • Assigned • 1.4mi

9/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

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

Hillsborough, CA • 94010

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.5 hours in June and 5 hours in December, placing it above the U.S. average for solar exposure.

10.5 hrs

5 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$7.40M – $8.95M

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

Need the cash from your home fast? Sell to .

Nearby similar homes

OPEN TODAY, 1:30PM TO 4PM

$5,295,000

3 beds3 baths2,575 sq ft

1580 Barroilhet Ave, Burlingame, CA 94010

Chef's kitchen • Remodeled baths • Designer finishes

$11,000,000

5 beds6 baths4,700 sq ft

433 El Centro Rd, Hillsborough, CA 94010

Custom wet bar • Private office • Spa-inspired bath

OPEN TODAY, 1PM TO 4PM

$3,999,000

5 beds5 baths4,255 sq ft

408 Warren Rd, San Mateo, CA 94402

Private adu • Gated motor court • Brick paved terrace

OPEN TODAY, 1PM TO 4PM

$4,495,000

5 beds3 baths2,895 sq ft

826 Walnut Ave, Burlingame, CA 94010

Gas cooktop • Electric oven • Dishwasher

OPEN TODAY, 2PM TO 4:30PM

$1,198,000

3 beds2 baths1,070 sq ft

221 North Delaware St, San Mateo, CA 94401

Extra-deep lot • Enclosed front porch • Full kitchen

$8,999,000

3 beds3.5 baths3,810 sq ft

2155 Geri Ln, Hillsborough, CA 94010

Largest lots • Quiet cul-de-sac • Mature trees

New listings for sale in 94010

OPEN TODAY, 1:30PM TO 4PM

$5,295,000

3 beds3 baths2,575 sq ft

1580 Barroilhet Ave, Burlingame, CA 94010

Chef's kitchen • Remodeled baths • Designer finishes

OPEN TODAY, 2PM TO 4PM3D WALKTHROUGH

$2,398,000

3 beds3 baths995 sq ft

804 Howard Ave, Burlingame, CA 94010

Completely remodeled • Detached studio adu • Move-in ready

OPEN TODAY, 2PM TO 4PMVIDEO TOUR

$3,998,000

3 beds3 baths2,630 sq ft

952 Tournament Dr, Hillsborough, CA 94010

0.5 acre lot • 3 garage spots • Pool

$3,500,000

— beds— baths4,144 sq ft

Chula Vis, Burlingame, CA 94010

Studio residences • Remodeled kitchens • Tiled showers

$3,500,000

— beds— baths4,144 sq ft

1123 Chula Vista Ave, Burlingame, CA 94010

Remodeled kitchens • Tiled showers • Laminate flooring

OPEN TODAY, 2PM TO 4PM

$5,488,000

5 beds4.5 baths4,255 sq ft

200 Darrell Rd, Hillsborough, CA 94010

Formal living room • Private deck • Updated kitchen

$13,999,000

5 beds5.5 baths5,155 sq ft

2170 Edgecourt Dr, Hillsborough, CA 94010

Quiet cul de sac • Open floor plan • Dedicated office

$4,900,000

— beds— baths7,722 sq ft

1441 Bellevue Ave, Burlingame, CA 94010

Three cottages • 0.31 acre lot • Garage

$4,900,000

4 beds4 baths7,722 sq ft

Bellevue, Hillsborough, CA 94010

Three cottages • 0.31 acre lot • 3 garage spots

Home values near 540 Chelmsford Rd

Data from public records.

Address	Redfin Estimate
500 Chelmsford Road, Hillsborough, CA 6 Beds \| 4 Baths \| 3830 Sq. Ft.	$6,925,532
530 Chelmsford Road, Hillsborough, CA 4 Beds \| 4.5 Baths \| 2080 Sq. Ft.	$5,771,103
535 Chelmsford Road, Hillsborough, CA 5 Beds \| 4 Baths \| 3720 Sq. Ft.	$6,413,718
555 Ravenscourt Road, Hillsborough, CA 5 Beds \| 4.5 Baths \| 3740 Sq. Ft.	$6,480,234
520 W Santa Inez Avenue, Hillsborough, CA 4 Beds \| 5.5 Baths \| 4230 Sq. Ft.	$7,589,780
546 W Santa Inez Avenue, Hillsborough, CA 4 Beds \| 4.5 Baths \| 3640 Sq. Ft.	$7,417,602
546 Ravenscourt Road, Hillsborough, CA 3 Beds \| 3 Baths \| 2990 Sq. Ft.	$5,536,634

Address	Redfin Estimate
510 Chelmsford Road, Hillsborough, CA 4 Beds \| 4.5 Baths \| 3270 Sq. Ft.	$6,350,975
515 Chelmsford Road, Hillsborough, CA 3 Beds \| 3 Baths \| 2160 Sq. Ft.	$4,486,306
545 Chelmsford Road, Hillsborough, CA 4 Beds \| 4 Baths \| 3770 Sq. Ft.	$6,234,558
510 Ravenscourt Road, Hillsborough, CA 5 Beds \| 4.5 Baths \| 3900 Sq. Ft.	$7,813,813
600 W Santa Inez Avenue, Hillsborough, CA 5 Beds \| 5.5 Baths \| 4300 Sq. Ft.	$9,107,739
540 W Santa Inez Avenue, Hillsborough, CA 5 Beds \| 4.5 Baths \| 4000 Sq. Ft.	$8,966,955
536 Ravenscourt Road, Hillsborough, CA 3 Beds \| 3 Baths \| 2300 Sq. Ft.	$4,841,255

Address	Redfin Estimate
585 Chelmsford Road, Hillsborough, CA 4 Beds \| 4.5 Baths \| 4350 Sq. Ft.	$7,806,685
555 Chelmsford Road, Hillsborough, CA 3 Beds \| 3 Baths \| 3050 Sq. Ft.	$4,953,659
565 Chelmsford Road, Hillsborough, CA 5 Beds \| 4 Baths \| 3630 Sq. Ft.	$8,224,360
540 Ravenscourt Road, Hillsborough, CA 5 Beds \| 3.5 Baths \| 3140 Sq. Ft.	$5,631,899
541 Ravenscourt Road, Hillsborough, CA 5 Beds \| 4.5 Baths \| 4460 Sq. Ft.	$7,865,014
525 Ravenscourt Road, Hillsborough, CA 4 Beds \| 3.5 Baths \| 3164 Sq. Ft.	$7,167,068
515 Ravenscourt Road, Hillsborough, CA 4 Beds \| 4 Baths \| - Sq. Ft.	$7,016,078

Property information provided by undefined .

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.

Redfin Brokerage Licenses

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
94030 homes for sale
94401 homes for sale
94402 homes for sale
94403 homes for sale

Houses for rent in Hillsborough	Agents near me	Irvine, CA homes for sale	Hillsborough 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	Sacramento, CA homes for sale
Open Houses near me	Los Angeles, CA homes for sale	Hillsborough Property Records
Condos for sale near me	San Jose, CA homes for sale	CA New Listings

Oakland homes for sale
San Francisco homes for sale
Fremont homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 94010, CA

Sale history for 540 Chelmsford Rd

Tax history for 540 Chelmsford Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 94010

Home values near 540 Chelmsford Rd

More real estate resources