NOT LISTED FOR SALE

540 Chelmsford Rd Hillsborough, CA 94010

Hillsborough Area

Estimated Value: $6,261,000 - $6,893,379

4 Beds
4.5 Baths
4,125 Sq Ft
$1,597/Sq Ft Est. Value

Sale Details

Date Sold: September 8, 2023

Last sale price $5,650,000 $1,370 Per Sq Ft

Est. 17% increase in value since last sale

Current estimated payment $41,923 / mo

32 Days on Market

Highlights

  • Wine Cellar
  • Media Room
  • Primary Bedroom Suite
  • South Hillsborough Elementary School Rated A+
  • In Ground Pool
  • English Cottage Architecture

About This Home

As of September 2023

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!

Last Agent to Sell the Property

Geoffrey Nelson

Coldwell Banker Realty License #01313666 Listed on: 07/26/2023

Coldwell Banker Realty

Last Buyer's Agent

Geoffrey Nelson

Coldwell Banker Realty License #01313666 Listed on: 07/26/2023

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1930

Lot Details

  • 15,211 Sq Ft Lot
  • Sprinkler System
  • Zoning described as R10025

Parking

  • 2 Car Attached Garage

Home Design

  • English Cottage Architecture
  • English Architecture
  • Composition Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 4,125 Sq Ft Home
  • 1-Story Property
  • Beamed Ceilings
  • Vaulted Ceiling
  • Wood Burning Fireplace
  • Gas Log Fireplace
  • Mud Room
  • Wine Cellar
  • Family Room with Fireplace
  • 3 Fireplaces
  • Living Room with Fireplace
  • Formal Dining Room
  • Media Room
  • Den
  • Loft
  • Laundry in unit

Kitchen

  • Open to Family Room
  • Eat-In Kitchen
  • Breakfast Bar
  • Double Oven
  • Kitchen Island
  • Marble Countertops

Flooring

  • Wood
  • Marble

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Fireplace in Primary Bedroom
  • Primary Bedroom Suite
  • Walk-In Closet
  • Remodeled Bathroom
  • Marble Bathroom Countertops
  • Dual Sinks
  • Soaking Tub in Primary Bathroom
  • Oversized Bathtub in Primary Bathroom

Additional Features

  • In Ground Pool
  • Forced Air Zoned Heating System

Listing and Financial Details

  • Assessor Parcel Number 031-205-060

Home Details

Home Type

Single Family

Year Built

Built in 1930

Lot Details

0.35 Acres

Parking

2

Listing Details

  • Subclass: Single Family Home
  • Style: Country English, English, Luxury
  • Listing Class: Residential
  • Structure Sq Ft: 4125
  • Year Built: 1930
  • Zoning Description: R10025
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: Kitchen / Family Room Combo
  • Fireplace: Family Room, Gas Log, Living Room, Primary Bedroom, Wood Burning
  • Dining Room: Breakfast Bar, Eat in Kitchen, Formal Dining Room
  • Kitchen: Countertop - Marble, Island with Sink, Oven - Double
  • Living Sq Ft: 4125
  • Stories: 1
  • Bedrooms: Primary Suite / Retreat
  • Laundry: Inside
  • Flooring: Hardwood, Marble
  • Additional Rooms: Den / Study / Office, Loft, Media / Home Theater, Mud Room, Wine Cellar / Storage
  • Fireplaces Min: 3
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Bathroom: Double Sinks, Marble, Primary - Oversized Tub, Updated Bath
  • Fireplace: Yes

Exterior Features

  • Foundation: Concrete Perimeter and Slab
  • Pool Description: Pool - In Ground
  • Roof: Composition
  • Yard/Grounds: Sprinklers - Lawn
  • Pool: Yes

Garage/Parking

  • Garage Spaces: 2
  • Garage Parking Features: Attached Garage

Utilities

  • Heating System: Central Forced Air - Gas, Heating - 2+ Zones
  • Sewer/Septic System: Sewer - Public

Association/Amenities

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

Lot Info

  • Parcel Number: 031-205-060
  • Lot Acres: 0.3492
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 15210.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 15210.00

Multi Family

  • Utilities: Public Utilities

MLS Schools

  • High School District Text: San Mateo Union High
  • Elementary School Text: South Hillsborough
  • Middle School Text: Crocker Middle

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 26, 2023
Closed on
Sep 5, 2023
Sold by
Bought by
Seller's Agent
Geoffrey Nelson
Coldwell Banker Realty
Buyer's Agent
Geoffrey Nelson
Coldwell Banker Realty
List Price
$5,998,000
Sold Price
$5,650,000
Premium/Discount to List
-$348,000
-5.8%
Views
42
Current Estimated Value
$6,586,595

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$936,595
Avg. Annual Appreciation
5.43%

Purchase Details

Closed on
Jun 16, 2017
Sold by
Bought by

Purchase Details

Closed on
Apr 10, 2014
Sold by
Bought by

Home Financials for this Owner

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

Purchase Details

Listed on
May 17, 2012
Closed on
Jun 15, 2012
Sold by
Bought by
Seller's Agent
Anne Riley
Compass
Buyer's Agent
John Cella
Golden Gate Sotheby's International Realty
List Price
$2,625,000
Sold Price
$2,490,000
Premium/Discount to List
-$135,000
-5.14%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.14%
Original Mortgage
$1,700,000
Interest Rate
0.034%
Mortgage Type
New Conventional
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$5,650,000 Wfg National Title
-- None Available
-- First American Title Company
$2,490,000 First American Title Company
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $3,517,150
Previous Owner $2,000,000
Previous Owner $250,000
Previous Owner $250,000
Previous Owner $1,700,000
Previous Owner $100,000
Previous Owner $100,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
09/08/2023 09/08/23 Sold $5,650,000 -2.6% $1,370 / Sq Ft
08/27/2023 08/27/23 Pending -- -- --
08/18/2023 08/18/23 Price Changed $5,798,000 -3.3% $1,406 / Sq Ft
07/26/2023 07/26/23 For Sale $5,998,000 +140.9% $1,454 / Sq Ft
06/29/2012 06/29/12 Sold $2,490,000 -4.0% $862 / Sq Ft View Prior Sale
05/31/2012 05/31/12 Pending -- -- --
05/21/2012 05/21/12 Price Changed $2,595,000 -1.1% $898 / Sq Ft
05/17/2012 05/17/12 For Sale $2,625,000 -- $908 / Sq Ft
Source: MLSListings

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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 $69,068 $5,763,000 $3,876,000 $1,887,000
2023 $69,068 $3,345,747 $2,414,562 $931,185
2022 $41,480 $3,280,145 $2,367,218 $912,927
2021 $40,601 $3,215,830 $2,320,802 $895,028
2020 $39,880 $3,182,857 $2,297,006 $885,851
2019 $38,941 $3,120,449 $2,251,967 $868,482
2018 $37,779 $3,059,265 $2,207,811 $851,454
2017 $37,119 $2,999,280 $2,164,521 $834,759
2016 $36,131 $2,940,472 $2,122,080 $818,392
2015 $32,346 $2,602,305 $2,090,205 $512,100
2014 $31,500 $2,551,330 $2,049,261 $502,069
Source: Public Records

Agents Affiliated with this Home

  • Geoffrey Nelson

    Seller's Agent in 2023

    Geoffrey Nelson

    Coldwell Banker Realty

    (650) 455-3735

    70 Total Sales

    Geoffrey Nelson
    Section Image

  • A

    Seller's Agent in 2012

    Anne Riley

    Compass

  • J

    Buyer's Agent in 2012

    John Cella

    Golden Gate Sotheby's International Realty

    Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81935027

MLSListings

APN: 031-205-060

California San Mateo County Hillsborough 94010

540 Chelmsford Rd, Hillsborough, CA

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

MLSListings Property Information © 2026 MLSListings Inc. All rights reserved. Listing information is deemed reliable but not guaranteed. Certain information contained herein is derived from information which is the licensed property of, and copyrighted by, MLSListings Inc. The viewer acknowledges ownership and validity of its copyright. Information provided is for personal, non-commercial use by a viewer with a bona fide interest in the purchase or sale of real estate of the type being offered via this website or other electronic means. The viewer is prohibited from copying, redistributing or retransmitting any of the data or information provided by MLSListing, Inc.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.