NOT LISTED FOR SALE

540 Roehampton Rd Hillsborough, CA 94010

Estimated Value: $4,864,000 - $5,849,000

5 Beds
4.5 Baths
3,190 Sq Ft
$1,704/Sq Ft Est. Value

Sale Details

Date Sold: March 31, 2017

Last sale price $3,595,000 $1,127 Per Sq Ft

Est. 51% increase in value since last sale

Current estimated payment $33,129 / mo

13 Days on Market

Highlights

  • Ranch Style House
  • Wood Flooring
  • High Ceiling
  • South Hillsborough Elementary School Rated A+
  • Solarium
  • Breakfast Area or Nook

About This Home

As of March 2017

Premier street in prime lower south Hillsborough at the end of a cul-de-sac! Lovely setting! Beautiful neighborhood! Classic traditional appeal! Spacious ranch style home with big extra space and rooms on the lower level! First time on market for almost 40 years. Spacious formal rooms (including dramatic central living room), an eat-in kitchen, plus inviting sunroom that doubles as a family room. A large recreation room and flexible office/playroom on the lower level provide added venues for everyday living. Spacious rear yard with lush foliage and mature trees. With an excellent location and gorgeous surroundings, this home also benefits from minutes away proximity to downtown San Mateo or Burlingame, as well as highly regarded public and private schools.

Last Agent to Sell the Property

Mark Johnson

Coldwell Banker Realty License #00667906 Listed on: 02/02/2017

Coldwell Banker Realty

Last Buyer's Agent

Max Lo

Green Banker Realty License #01192824

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1937

Lot Details

  • 16,509 Sq Ft Lot
  • Front Yard Fenced and Back Yard
  • Lot Sloped Down
  • Sprinklers on Timer
  • Zoning described as R10025

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Home Design

  • Ranch Style House
  • Traditional Architecture
  • Shingle Roof
  • Composition Roof

Interior Spaces

  • 3,190 Sq Ft Home
  • High Ceiling
  • Skylights
  • Wood Burning Fireplace
  • Separate Family Room
  • Formal Dining Room
  • Solarium
  • Alarm System

Kitchen

  • Breakfast Area or Nook
  • Double Oven
  • Gas Oven
  • Range Hood
  • Tile Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Jack-and-Jill Bathroom
  • Bathtub with Shower
  • Walk-in Shower

Laundry

  • Laundry Tub
  • Washer and Dryer Hookup

Utilities

  • Forced Air Heating System
  • Separate Meters
  • Individual Gas Meter
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 031-220-270

Home Details

Home Type

Single Family

Year Built

Built in 1937

Lot Details

0.38 Acres

Parking

2

Listing Details

  • Subclass: Single Family Home
  • Style: Ranch, Traditional
  • Listing Class: Residential
  • Structure Sq Ft: 3190
  • Year Built: 1937
  • Zoning Description: R10025
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: Separate Family Room
  • Fireplace: Wood Burning
  • Dining Room: Breakfast Nook, Formal Dining Room
  • Kitchen: Countertop - Tile, Garbage Disposal, Hood Over Range, Oven - Double, Oven Range - Gas, Refrigerator
  • Living Sq Ft: 3190
  • Security: Security Alarm
  • Laundry: Gas Hookup, Hookup - Washer/Dryer, Tub / Sink
  • Flooring: Carpet, Hardwood, Tile, Vinyl / Linoleum
  • Additional Rooms: Solarium
  • Fireplaces Min: 1
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Bathroom: Pass Through, Shower and Tub, Stall Shower, Tub
  • Fireplace: Yes

Exterior Features

  • Roof: Composition, Shingle
  • Yard/Grounds: Back Yard, Sprinklers - Auto, Sprinklers - Lawn
  • Fencing: Fenced Front, Partial Fencing

Garage/Parking

  • Garage Spaces: 2
  • Garage Parking Features: Attached Garage, Gate / Door Opener

Utilities

  • Heating System: Central Forced Air - Gas
  • Sewer/Septic System: Sewer Connected

Association/Amenities

  • Amenities Miscellaneous: High Ceiling, Skylight

Lot Info

  • Lot Description: Grade - Sloped Down, Grade - Varies
  • Parcel Number: 031-220-270
  • Lot Acres: 0.3790
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 16500.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 16500.00
  • Soil: Unknown

Multi Family

  • Utilities: Individual Electric Meters, Individual Gas Meters

MLS Schools

  • High School District Text: San Mateo Union High

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jan 31, 2022
Sold by
Sherman Hsieh
Bought by
Yang Ting
Current Estimated Value
$5,437,215

Purchase Details

Closed on
Dec 12, 2017
Sold by
Hsieh Sherman and Yang Ting
Bought by
Hsieh Sherman and Yang Ting

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,700,000
Interest Rate
3.94%
Mortgage Type
New Conventional

Purchase Details

Listed on
Feb 2, 2017
Closed on
Mar 30, 2017
Sold by
Hsieh Sherman and Yang Ting
Bought by
Hsieh Sherman and Yang Ting
Seller's Agent
Mark Johnson
Coldwell Banker Realty
Buyer's Agent
Max Lo
Green Banker Realty
List Price
$3,595,000
Sold Price
$3,595,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.68%
Original Mortgage
$2,500,000
Interest Rate
3.25%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Listed on
Feb 2, 2017
Closed on
Mar 10, 2017
Sold by
Andrews Marcia R
Bought by
Hsieh Sherman and Yang Ting
Seller's Agent
Mark Johnson
Coldwell Banker Realty
Buyer's Agent
Max Lo
Green Banker Realty
List Price
$3,595,000
Sold Price
$3,595,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$2,500,000
Interest Rate
3.25%
Mortgage Type
Adjustable Rate Mortgage/ARM
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

Date Buyer Sale Price Title Company
Yang Ting -- None Listed On Document
Hsieh Sherman -- Accommodation
Hsieh Sherman -- Wfg National Title Ins Co
Hsieh Sherman -- None Available
Hsieh Sherman $3,595,000 Chicago Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Hsieh Sherman $1,700,000
Previous Owner Hsieh Sherman $2,500,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
03/31/2017 03/31/17 Sold $3,595,000 0.0% $1,127 / Sq Ft
02/16/2017 02/16/17 Pending -- -- --
02/02/2017 02/02/17 For Sale $3,595,000 -- $1,127 / Sq Ft
Source: MLSListings

Tax History

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 $51,624 $4,172,301 $3,713,873 $458,428
2023 $51,624 $4,010,287 $3,569,659 $440,628
2022 $48,722 $3,931,655 $3,499,666 $431,989
2021 $47,715 $3,854,565 $3,431,046 $423,519
2020 $46,883 $3,815,042 $3,395,865 $419,177
2019 $45,803 $3,740,238 $3,329,280 $410,958
2018 $44,453 $3,666,900 $3,264,000 $402,900
2017 $9,592 $483,716 $91,549 $392,167
2016 $8,557 $474,232 $89,754 $384,478
2015 $8,275 $467,109 $88,406 $378,703
2014 $8,002 $457,960 $86,675 $371,285
Source: Public Records

Agents Affiliated with this Home

  • M

    Seller's Agent in 2017

    Mark Johnson

    Coldwell Banker Realty

    Section Image
  • Max Lo

    Buyer's Agent in 2017

    Max Lo

    Green Banker Realty

    (650) 307-8816

    21 in this area

    77 Total Sales

    Max Lo
    Section Image

  • E

    Buyer's Agent in 2017

    Edward Quiroz

    1st American Realty

    Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81637632

MLSListings

APN: 031-220-270

California San Mateo County Hillsborough 94010

540 Roehampton 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.