540 Chelmsford Rd, Hillsborough, CA 94010

Off Market Sep 2023 for $5.6M

$7,613,626

Est. refi paymentEst. refi $37,567/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,846Est. Price/Sq.Ft.

2 car garageParking

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

Contact: 650-455-3735

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

Redfin checked: 2 minutes ago

•Source:MLSListings #ML81935027

Redfin Estimate

$7,613,626

$2.0M since sold in September 2023$17K since August

Recently sold homes
Estimate history
Homes for sale

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

SOLD MAY 11, 2026
$6,700,000
A
4 beds4.5 baths3,380 sq ft
755 Bromfield Rd, Hillsborough, CA 94010
SOLD MAR 11, 2026
$6,500,000
B
4 beds4.5 baths3,710 sq ft
414 Edgewood Rd, San Mateo, CA 94402
SOLD JUN 9, 2026
$5,420,000
C
4 beds3 baths3,680 sq ft
641 Crescent Ave, San Mateo, CA 94402
SOLD AUG 12, 2026
$5,000,000
D
5 beds3 baths3,205 sq ft
554 Edgewood Rd, San Mateo, CA 94402
SOLD MAY 1, 2026
$7,895,000
E
5 beds3.5 baths4,235 sq ft
335 El Portal Ave, Hillsborough, CA 94010
SOLD JUL 14, 2026
$6,600,000
F
4 beds4.5 baths3,640 sq ft
537 Hurlingham Ave, 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

$2,946,911

Est. take-home

List your home with Redfin and save $38,068

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$10,432/mo

Redfin rental estimate

List your home for rent

Market trends in 94010, CA

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

106.8%

0.4% MoM

Median sale price

$4.0M

$165K MoM

Avg. days on market

14d

2 days MoM

Recently sold homes

121

8 MoM

New listings for sale

NEW 1 DAY AGO
$995,000
2 beds2.5 baths1,400 sq ft
16 Lorton Ave #3, Burlingame, CA 94010
3D WALKTHROUGH
$5,998,000
5 beds5 baths4,850 sq ft
40 Eugenia Way, Hillsborough, CA 94010
$15,695,000
5 beds7 baths5,707 sq ft
1950 Ralston Ave, Hillsborough, CA 94010
$4,087,000
4 beds3.5 baths3,150 sq ft
30 Bluebell Ln, Hillsborough, CA 94010
VIDEO TOUR
$4,995,000
3 beds3 baths2,680 sq ft
739 El Cerrito Ave, Hillsborough, CA 94010
OPEN SEP 22, 10AM TO 1PM
$4,398,000
4 beds2.5 baths3,110 sq ft
1345 Lakeview Dr, Hillsborough, CA 94010
OPEN SEP 27, 2PM TO 4PM
$5,498,000
6 beds4 baths3,230 sq ft
15 Mc Kenzie Ct, Hillsborough, CA 94010
VIDEO TOUR
$999,998
2 beds2 baths1,262 sq ft
530 El Camino Real #308, Burlingame, CA 94010
3D WALKTHROUGH
$1,288,000
2 beds2 baths1,190 sq ft
1838 Ogden Dr #110, Burlingame, CA 94010
$1,148,000
2 beds2 baths1,600 sq ft
110 Park Rd #301, Burlingame, CA 94010
See all

Provided by Redfin

Sale history for 540 Chelmsford Rd

Date

Event

Price

MLSListings #ML81935027

Sep 8, 2023

Sold

$5,650,000

$1,370/sq ft

Aug 31, 2023

Pending

—

Aug 28, 2023

Contingent

—

Aug 18, 2023

Price Changed

$5,798,000

$1,406/sq ft

Jul 26, 2023

Listed

$5,998,000

$1,454/sq ft

MLSListings #ML81218728

Jun 29, 2012

Sold

$2,490,000

$604/sq ft

May 31, 2012

Pending

—

May 21, 2012

Price Changed

$2,595,000

$629/sq ft

May 17, 2012

Listed

$2,625,000

$636/sq ft

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

Parking Information
Garage (Minimum): 2
Garage (Maximum): 2
Parking Description: Attached Garage
Garage Spaces: 2

Interior

Virtual Tour

Bedroom Information
# of Bedrooms (Minimum): 4
# of Bedrooms (Maximum): 4
Bedrooms: Primary Suite/Retreat

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

Room Information
Den/Study/Office, Loft, Media/Home Theatre, Mud Room, Wine Cellar/Storage
Family Room Description: Kitchen/Family Room Combo
Dining Room Description: Breakfast Bar, Eat in Kitchen, Formal Dining Room
Kitchen Description: Countertop (Marble), Island with Sink, Oven (Double)

Interior Features
Laundry: Inside
Flooring: Hardwood, Marble

Fireplace Information
Has Fireplace
Fireplace Description: In Family Room, Gas Log, In Living Room, In Primary Bedroom, Wood-Burning
Fireplaces (Minimum): 3

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

Exterior

Exterior Features
Roof: Composition
Yard/Grounds: Sprinkler(s) (Lawn)

Building Information
Style: Country English, English, Luxury
Subclass: Single Family Home
Building Type: Detached
Concrete Perimeter and Slab

Pool Information
Has Pool
Pool Description: In-Ground

Property Features
Amenities: High Ceiling, Open Beam Ceiling, Vaulted Ceiling, Walk-In Closet
Living Sq. Ft.: 4,125

Property Information
Property Primary ID: 352264

Lot Information
Lot Acres: 0.3492
Lot Size Area Minimum Units: Sq. Ft.
Lot Size Area Maximum Units: Sq. Ft.
Lot Size Source: Assessor
Zoning: R10025

Utilities

Utility Information
Sewer Septic: Sewer (Public)
Utilities: Public Utilities

Water Information
Water: Public

Location

Multi-Unit Information
# of Stories: 1

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

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

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.23M – $8.76M

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

Need the cash from your home fast? Sell to .

Nearby similar homes

$15,695,000

5 beds7 baths5,707 sq ft

1950 Ralston Ave, Hillsborough, CA 94010

$11,000,000

5 beds6 baths4,700 sq ft

433 El Centro Rd, Hillsborough, CA 94010

3D WALKTHROUGH

$4,500,000

6 beds3 baths3,192 sq ft

818 Crossway Rd, Burlingame, CA 94010

$1,800,000

2 beds1 bath850 sq ft

Undisclosed address, Burlingame, CA 94010

$7,280,000

5 beds5 baths5,180 sq ft

901 Hillsborough Blvd, Hillsborough, CA 94010

$8,999,000

3 beds3.5 baths3,810 sq ft

2155 Geri Ln, Hillsborough, CA 94010

New listings for sale in 94010

NEW 1 DAY AGO

$995,000

2 beds2.5 baths1,400 sq ft

16 Lorton Ave #3, Burlingame, CA 94010

3D WALKTHROUGH

$5,998,000

5 beds5 baths4,850 sq ft

40 Eugenia Way, Hillsborough, CA 94010

$15,695,000

5 beds7 baths5,707 sq ft

1950 Ralston Ave, Hillsborough, CA 94010

$4,087,000

4 beds3.5 baths3,150 sq ft

30 Bluebell Ln, Hillsborough, CA 94010

VIDEO TOUR

$4,995,000

3 beds3 baths2,680 sq ft

739 El Cerrito Ave, Hillsborough, CA 94010

OPEN SEP 22, 10AM TO 1PM3D & VIDEO TOUR

$4,398,000

4 beds2.5 baths3,110 sq ft

1345 Lakeview Dr, Hillsborough, CA 94010

OPEN SEP 27, 2PM TO 4PM

$5,498,000

6 beds4 baths3,230 sq ft

15 Mc Kenzie Ct, Hillsborough, CA 94010

VIDEO TOUR

$999,998

2 beds2 baths1,262 sq ft

530 El Camino Real #308, Burlingame, CA 94010

3D WALKTHROUGH

$1,288,000

2 beds2 baths1,190 sq ft

1838 Ogden Dr #110, Burlingame, CA 94010

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,777,487
530 Chelmsford Road, Hillsborough, CA 4 Beds \| 4.5 Baths \| 2080 Sq. Ft.	$5,746,983

Address	Redfin Estimate
510 Chelmsford Road, Hillsborough, CA 4 Beds \| 4.5 Baths \| 3270 Sq. Ft.	$6,228,420
515 Chelmsford Road, Hillsborough, CA 3 Beds \| 3 Baths \| 2160 Sq. Ft.	$4,500,155

Address	Redfin Estimate
585 Chelmsford Road, Hillsborough, CA 4 Beds \| 4.5 Baths \| 4350 Sq. Ft.	$7,411,350
555 Chelmsford Road, Hillsborough, CA 3 Beds \| 3 Baths \| 3050 Sq. Ft.	$4,942,158

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.

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