NOT LISTED FOR SALE

539 Beresford Ave Redwood City, CA 94061

Estimated Value: $4,516,000 - $5,033,000

5 Beds
5.5 Baths
3,933 Sq Ft
$1,210/Sq Ft Est. Value

Last Sold May 08, 2024

Last sale price $4,800,000 $1,220 Per Sq Ft

Est. 1% decrease in value since last sale

Current estimated payment $29,591/month

3 Days on Market

Highlights

  • Vaulted Ceiling
  • Wood Flooring
  • 2 Fireplaces
  • Woodside High School Rated A
  • Marble Countertops
  • Wine Refrigerator

About This Home

As of May 2024

Located in the center of an exceptional street on the edge of Atherton, this stately Cape Cod Colonial-style home is a welcoming retreat for all who enter. The bright, light-filled entry with a central staircase and soaring ceilings is where it all begins. French oak flooring and high-end finishes are throughout this thoughtfully designed home. The chef's kitchen and magnificent family room are indeed the heart of this home, offering an abundance of space for everyday living and entertaining. The open great room design with a dining area seamlessly connects to the outdoors through double French doors. The generous family room offers a cozy fireplace, custom window coverings, and views of the expansive, beautifully landscaped rear yard, featuring a sizeable custom-designed patio, market lights, and a firepit area. The luxurious primary suite boasts vaulted ceilings, a spectacular light fixture, stunning finishes, and an impressive custom-designed walk-in closet. The bathroom features a marble shower with dual shower heads, a marble vanity with double sinks, and a large soaking tub. A second primary suite on the ground floor is ideal for guests or extended family. The other four bedrooms have private bathrooms, providing comfortable retreats for everyone. 4-car tandem garage.

Last Agent to Sell the Property

Leslie Woods

Christie's International Real Estate Sereno License #01855901 Listed on: 03/28/2024

Christie's International Real Estate Sereno

Last Buyer's Agent

Diane Kneis

Compass License #01419720

Compass

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $46,339

Year Built

  • Built in 2014

Lot Details

  • 0.27 Acre Lot
  • Zoning described as R10006

Parking

  • 4 Car Detached Garage
  • Tandem Parking

Home Design

  • Shingle Roof
  • Composition Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 3,933 Sq Ft Home
  • 2-Story Property
  • Vaulted Ceiling
  • Skylights
  • 2 Fireplaces
  • Gas Fireplace
  • Formal Dining Room

Kitchen

  • Open to Family Room
  • Double Oven
  • Electric Oven
  • Microwave
  • Ice Maker
  • Dishwasher
  • Wine Refrigerator
  • Kitchen Island
  • Marble Countertops
  • Quartz Countertops

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet

Laundry

  • Laundry in Utility Room
  • Washer and Dryer

Utilities

  • Forced Air Heating and Cooling System
  • Wood Insert Heater

Listing and Financial Details

  • Assessor Parcel Number 069-333-410

Home Details

Home Type

Single Family

Est. Annual Taxes

$46,339

Year Built

Built in 2014

Lot Details

0

Parking

4

Listing Details

  • Subclass: Single Family Home
  • Age: 10
  • Listing Class: Residential
  • Structure Sq Ft: 3933
  • Year Built: 2014
  • Zoning Description: R10006
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: Kitchen / Family Room Combo
  • Fireplace: Gas Burning, Insert
  • Dining Room: Formal Dining Room
  • Kitchen: Countertop - Marble, Countertop - Quartz, Dishwasher, Ice Maker, Island with Sink, Microwave, Oven - Double, Oven - Electric, Oven Range - Built-In, Gas, Refrigerator, Wine Refrigerator
  • Living Sq Ft: 3933
  • Stories: 2
  • Laundry: In Utility Room, Washer / Dryer
  • Flooring: Carpet, Hardwood, Tile
  • Fireplaces Min: 2
  • Maximum Numberof Bedrooms: 5
  • Minimum Numberof Bedrooms: 5
  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Fireplace: Yes

Exterior Features

  • Foundation: Concrete Perimeter and Slab
  • Roof: Composition, Shingle

Garage/Parking

  • Garage Spaces: 4
  • Garage Max: 4
  • Garage Min: 4
  • Garage Parking Features: Detached Garage, Tandem Parking

Utilities

  • Cooling System: Central AC
  • Heating System: Central Forced Air - Gas
  • Sewer/Septic System: Sewer - Public

Association/Amenities

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

Schools

  • School District: Sequoia Union High
  • Elementary School: Henry Ford Elementary
  • Middle School: John F. Kennedy Middle
  • High School: Woodside High
  • High School: 684
  • Elementary School: 639
  • Middle School: 646

Lot Info

  • Parcel Number: 069-333-410
  • Lot Acres: 0.2686
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 11700.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 11700.00

Multi Family

  • Utilities: Public Utilities

MLS Schools

  • High School District Text: Sequoia Union High
  • Elementary School Text: Henry Ford Elementary
  • High School Text: Woodside High
  • Middle School Text: John F. Kennedy Middle

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 28, 2024
Closed on
Apr 26, 2024
Sold by
Frick Steven L and Frick Lisa K
Bought by
David And Deanna Revocable Trust and Harris
Seller's Agent
Leslie Woods
Christie's International Real Estate Sereno
Buyer's Agent
Diane Kneis
Compass
List Price
$4,795,000
Sold Price
$4,800,000
Premium/Discount to List
$5,000
0.1%
Views
13
Current Estimated Value
$4,758,787

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$41,213
Avg. Annual Appreciation
-0.64%
Original Mortgage
$3,360,000
Outstanding Balance
$3,315,198
Interest Rate
6.79%
Mortgage Type
New Conventional
Estimated Equity
$1,443,590

Purchase Details

Closed on
Feb 8, 2017
Sold by
Bercow Mark S and Bercow Dawn
Bought by
Frick Steven L and Frick Lisa K

Home Financials for this Owner

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

Purchase Details

Closed on
Oct 14, 2014
Sold by
Whitehall Properties Llc
Bought by
Teh Bercow Family Trust and Bercow Dawn

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$284,100
Interest Rate
3.25%
Mortgage Type
Stand Alone Second

Purchase Details

Closed on
Nov 6, 2013
Sold by
Gonzalez Romero Emma
Bought by
Romero Albert

Purchase Details

Closed on
Nov 1, 2013
Sold by
Romero Albert
Bought by
Whitehall Properties Llc

Purchase Details

Closed on
Dec 14, 2011
Sold by
Howland Elizabeth
Bought by
Romero Albert

Purchase Details

Closed on
Mar 12, 1996
Sold by
Howland Elizabeth
Bought by
Howland Elizabeth

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$33,000
Interest Rate
6.5%
Source: Public Records

Range of Values:

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
David And Deanna Revocable Trust $4,800,000 Lawyers Title Company
Frick Steven L $3,600,000 Chicago Title Company
Teh Bercow Family Trust $2,841,000 First American Title Company
Romero Albert -- First American Title Company
Whitehall Properties Llc $1,126,000 First American Title Company
Romero Albert -- None Available
Howland Elizabeth -- First American Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open David And Deanna Revocable Trust $3,360,000
Previous Owner Frick Steven L $1,440,936
Previous Owner Frick Steven L $700,000
Previous Owner Frick Steven L $1,590,000
Previous Owner Teh Bercow Family Trust $284,100
Previous Owner Teh Bercow Family Trust $1,562,550
Previous Owner Howland Elizabeth $980,000
Previous Owner Howland Elizabeth $435,478
Previous Owner Howland Elizabeth $92,000
Previous Owner Howland Elizabeth $101,250
Previous Owner Howland Elizabeth $77,000
Previous Owner Howland Elizabeth $50,000
Previous Owner Howland Elizabeth $33,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/08/2024 05/08/24 Sold $4,800,000 +0.1% $1,220 / Sq Ft
04/01/2024 04/01/24 Pending -- -- --
03/28/2024 03/28/24 For Sale $4,795,000 -- $1,219 / Sq Ft
Source: MLSListings

Tax History Compared to Growth

Source: Public Records

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 $46,339 $4,896,000 $1,938,000 $2,958,000
2023 $46,339 $4,015,866 $2,007,933 $2,007,933
2022 $43,462 $3,937,124 $1,968,562 $1,968,562
2021 $43,017 $3,859,926 $1,929,963 $1,929,963
2020 $42,419 $3,820,348 $1,910,174 $1,910,174
2019 $42,235 $3,745,440 $1,872,720 $1,872,720
2018 $41,072 $3,672,000 $1,836,000 $1,836,000
2017 $33,199 $2,942,010 $1,471,005 $1,471,005
2016 $32,662 $2,884,324 $1,442,162 $1,442,162
2015 $31,428 $2,841,000 $1,420,500 $1,420,500
2014 $12,870 $1,126,000 $800,000 $326,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81959215

MLSListings

APN: 069-333-410