NOT LISTED FOR SALE

Estimated Value: $6,086,000 - $8,506,000

5 Beds
5.5 Baths
5,740 Sq Ft
$1,283/Sq Ft Est. Value

Last Sold August 25, 2023

Last sale price $6,680,000 $1,164 Per Sq Ft

Est. 10% increase in value since last sale

Current estimated payment $45,795/month

29 Days on Market

Highlights

  • Pool and Spa
  • Breakfast Room
  • Forced Air Heating and Cooling System
  • West Hillsborough Rated A+
  • Open to Family Room

About This Home

As of August 2023

Huge Reduction!! Luxury living awaits at this European manor on what is deemed to be the best block in the sought-after Carolands neighborhood. From exquisite millwork to fine hardwood & antiqued limestone floors, every inch exudes uncompromising quality and timeless appeal. The design is spacious yet presents a warm and inviting ambiance and is ideal for multi-generational families and guests with its secondary suite on the main level + sumptuous upper-level primary suite. Tremendous kitchen & family room, executive office, lower-level recreation room + fitness center & bath or possible sixth bedroom. On more than one-half acre, the expansive level grounds showcase a pool & spa, barbecue terrace, lots of room for play, and potential for an ADU. Beautiful views at every turn and absolute privacy. Access to acclaimed West Elementary & Crocker Middle schools.

Last Agent to Sell the Property

Max Lo

Green Banker Realty License #01192824 Listed on: 07/06/2023

Last Buyer's Agent

Edward Quiroz

1st American Realty License #01405119

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $80,590

Year Built

  • Built in 2001

Lot Details

  • 0.56 Acre Lot
  • Zoning described as R10025

Parking

  • 3 Car Garage

Home Design

  • Flat Roof Shape
  • Slate Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 5,740 Sq Ft Home
  • 2-Story Property
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Breakfast Room
  • Formal Dining Room

Kitchen

  • Open to Family Room
  • Eat-In Kitchen

Bedrooms and Bathrooms

  • 5 Bedrooms

Pool

  • Pool and Spa
  • In Ground Pool
  • Pool Cover

Utilities

  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Assessor Parcel Number 030-032-200

Home Details

Home Type

Single Family

Est. Annual Taxes

$80,590

Year Built

Built in 2001

Lot Details

0

Parking

3

Listing Details

  • Subclass: Single Family Home
  • Age: 22
  • Listing Class: Residential
  • Structure Sq Ft: 5740
  • Year Built: 2001
  • Zoning Description: R10025
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: Kitchen / Family Room Combo
  • Fireplace: Family Room, Living Room
  • Dining Room: Breakfast Room, Eat in Kitchen, Formal Dining Room
  • Living Sq Ft: 5740
  • Stories: 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
  • Pool Description: Pool - Cover, Pool - In Ground, Pool / Spa Combo
  • Roof: Flat / Low Pitch, Slate
  • Pool: Yes

Garage/Parking

  • Garage Spaces: 3
  • Garage Max: 3
  • Garage Min: 3
  • Garage Parking Features: Attached Garage

Utilities

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

Schools

  • School District: San Mateo Union High
  • Elementary School: West Hillsborough
  • Middle School: Crocker Middle
  • High School: Burlingame High
  • High School: 615
  • Elementary School: 679
  • Middle School: 625

Lot Info

  • Parcel Number: 030-032-200
  • Lot Acres: 0.5629
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 24518.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 24518.00

Multi Family

  • Utilities: Public Utilities

MLS Schools

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

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 6, 2023
Closed on
Aug 18, 2023
Sold by
Beressi Family Trust
Bought by
Mackman Family Revocable Trust and Mackman
Seller's Agent
Max Lo
Green Banker Realty
Buyer's Agent
Max Lo
Green Banker Realty
List Price
$7,500,000
Sold Price
$6,680,000
Premium/Discount to List
-$820,000
-10.93%
Total Days on Market
29
Views
34
Current Estimated Value
$7,363,782

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$683,782
Avg. Annual Appreciation
5.53%

Purchase Details

Closed on
May 27, 2020
Sold by
Beressi Haim
Bought by
Beressi Haim and Beressi Melissa

Purchase Details

Closed on
Oct 21, 2014
Sold by
Beressi Haim Aaron and Almalech Leonard H
Bought by
Beressi Haim

Home Financials for this Owner

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

Purchase Details

Closed on
Mar 14, 2006
Sold by
Beressi Haim
Bought by
Beressi Haim and Beressi Melissa

Home Financials for this Owner

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

Purchase Details

Closed on
Jan 26, 2006
Sold by
Beressi Melissa Jeanne
Bought by
Beressi Haim

Home Financials for this Owner

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

Purchase Details

Closed on
Jan 20, 2006
Sold by
Carlborg W Eric and Carlborg Michelle D
Bought by
Beressi Salvator

Home Financials for this Owner

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

Purchase Details

Closed on
Mar 4, 2002
Sold by
Pullman Glengarry Llc
Bought by
Carlborg W Eric and Carlborg Michelle D

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$4,000,000
Interest Rate
6.25%

Purchase Details

Closed on
Sep 27, 2000
Sold by
Derry Daniel J and Derry Joan Marie
Bought by
Derry Family Partnership Lp

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$2,345,000
Interest Rate
7.98%
Mortgage Type
Construction

Purchase Details

Closed on
Mar 7, 2000
Sold by
Shao Chi Hwa and Shao Margaret M
Bought by
Burlingame Hills Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$515,000
Interest Rate
8.21%

Purchase Details

Closed on
Mar 2, 2000
Sold by
Mays Lance A
Bought by
Shao Chi Hwa and Shao Margaret M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$515,000
Interest Rate
8.21%

Purchase Details

Closed on
Oct 8, 1997
Sold by
Mays Angela
Bought by
Mays Lance A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$663,750
Interest Rate
8.25%

Purchase Details

Closed on
Oct 31, 1994
Sold by
Mays Angela M
Bought by
Mays Lance A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$100,000
Interest Rate
8.78%

Purchase Details

Closed on
Apr 13, 1994
Sold by
American Svgs Bank
Bought by
Mays Lance A

Home Financials for this Owner

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

Similar Homes in Hillsborough, CA

  • 748 Jacaranda Cir, Hillsborough, CA 94010

    $7,288,000

    • 5 Beds
    • 5 Baths
    • 4,545 Sq Ft
    • 748 Jacaranda Cir
    • Hillsborough, CA

    DESIGN FOR LIVING: THE PERFECT MEETING OF SUN, CELEBRATION, AND SAVOIR FAIRE! Remodeled designer quality unfolds across multiple destinations, with minimal boundary between indoor and outdoor living. 5 bedrooms, 3 full baths, 2 half baths, plus large Office (or gym), and enormous recreation room of 21 x 26 feet. Majority of the home flows on one level, including four bedrooms all together

    Geoffrey Nelson Coldwell Banker Realty

    Section Image
  • 510 Darrell Rd, Hillsborough, CA 94010

    $7,488,000

    • 5 Beds
    • 5.5 Baths
    • 5,120 Sq Ft
    • 510 Darrell Rd
    • Hillsborough, CA

    Located in Hillsboroughs coveted Carolands neighborhood, this exceptional 5BD/5.5BA home has been meticulously renovated and expanded to exemplify modern luxury living. Situated on a generous half-acre lot, the property offers a private retreat with a swimming pool and spillover spa. Enjoy seamless indoor-outdoor living with an open floor plan, soaring ceilings, skylights, and La Cantina doors.

    Michael Danao eXp Realty of California Inc

    Section Image
  • 110 New Place Rd, Hillsborough, CA 94010

    $8,500,000

    • 5 Beds
    • 5.5 Baths
    • 4,510 Sq Ft
    • 110 New Place Rd
    • Hillsborough, CA

    In the Burlingame Country Club area, this stunning renovation combines chic sophistication with Spanish flair. Featuring 5 bedrooms and 5.5 baths across two levels, the home has espresso-hued hardwood and Saltillo tile floors complemented by updated lighting, 3 fireplaces with modern style. The floor plan features upstairs living areas and the primary suite opening to the resort-inspired rear

    Alicia Sanguinetti Compass

    Section Image
  • 2496 Butternut Dr, Hillsborough, CA 94010

    $6,880,000

    • 5 Beds
    • 6.5 Baths
    • 5,822 Sq Ft
    • 2496 Butternut Dr
    • Hillsborough, CA

    NEW LISTING AND RECENTLY REFRESHED!!! ONE OF HILLSBOROUGH'S FINEST PROPERTIES!!! Breathtaking views of the San Francisco bay & beyond. HUGE MOSTLY LEVEL LOT WITH OVER .5 ACRES. Exquisite Mediterranean designs with a red-tiled roof and circular paver driveway. A grand foyer welcomes you in with soaring ceilings. Throughout, you'll find hardwood flooring, carpeting, and recessed lighting. To the

    Stanley Lo Green Banker Realty

    Section Image
  • 1162 Barroilhet Dr, Hillsborough, CA 94010

    $6,295,000

    • 4 Beds
    • 6 Baths
    • 4,430 Sq Ft
    • 1162 Barroilhet Dr
    • Hillsborough, CA

    Situated on a commanding half-acre lot, this inviting home offers over 4,400 sq. ft. of casual elegance in a picturesque setting. A dramatic foyer leads to the elegant living room with a grand fireplace, wall of windows, and access to a huge rear deck. The gracious dining room features oversized windows that frame amazing views of the outdoors. Nearby, the large family room with a fireplace,

    Jim Arbeed Coldwell Banker Realty

    Section Image
  • 2320 Skyfarm Dr, Hillsborough, CA 94010

    $6,500,000

    • 6 Beds
    • 6.5 Baths
    • 6,054 Sq Ft
    • 2320 Skyfarm Dr
    • Hillsborough, CA

    APPROVED PLANS FOR A BRAND NEW MODERN HOME! ALL PERMITS COMPLETED, READY TO BUILD YOUR DREAM HOME!!! HUGE LOT WITH .621 ACRES OF USABLE LAND, SEATED IN THE PERFECT LOCATION / NEIGHBORHOOD. Plans include a 1 bed/1bath ADU with a full kitchen, dining, & living room, as well as a swimming pool. Close to top-rated schools, countless amenities, modern conveniences, Downtown Burlingame, and easy

    Stanley Lo Green Banker Realty

    Section Image
  • 1035 Macadamia Dr, Hillsborough, CA 94010

    $5,990,000

    • 4 Beds
    • 6.5 Baths
    • 6,925 Sq Ft
    • 1035 Macadamia Dr
    • Hillsborough, CA

    PRICE REDUCED, THE BEST DEAL JUST GOT BETTER!!! Nestled in the Hillsborough foothills, this exquisite estate embodies prestige & sophistication in one of Californias most coveted enclaves. Set on a generous lot, it offers exceptional privacy w/ only one neighbor & lush greenery for lots of privacy. Mediterranean-inspired design shines w/ arched doorways, sculpted balusters, & a grand foyer.

    Stanley Lo Green Banker Realty

    Section Image
  • 1140 Bromfield Rd, Hillsborough, CA 94010

    $7,480,000

    • 5 Beds
    • 5.5 Baths
    • 6,130 Sq Ft
    • 1140 Bromfield Rd
    • Hillsborough, CA

    BEST CHOICE IN ALL OF LOWER HILLSBOROUGH - PRICE REDUCED $1 MILLION!!! Welcome to 1140 Bromfield, a stunning 5-bedroom estate set on 1.11 lush acres in the prestigious Lower Hillsborough neighborhood. This meticulously crafted home blends timeless elegance with modern convenience, offering an unparalleled living experience. Inside, discover 5 full bathrooms, 2 half bathrooms, and a gourmet

    Stanley Lo Green Banker Realty

    Section Image
  • 1095 Macadamia Dr, Hillsborough, CA 94010

    $8,500,000

    • 5 Beds
    • 5.5 Baths
    • 5,215 Sq Ft
    • 1095 Macadamia Dr
    • Hillsborough, CA

    Set on a beautifully landscaped lot, this home offers the perfect balance of luxury, space, & modern convenience. This thoughtfully renovated residence combines timeless elegance with smart-home functionality & high-end designer finishes. The main level welcomes you with a dramatic double-height foyer, formal living and dining rooms, & an expansive open-concept kitchen outfitted with top-tier

    Jenn Gilson Golden Gate Sotheby's International Realty

    Section Image

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
Mackman Family Revocable Trust $6,680,000 Lawyers Title Company
Beressi Haim -- None Available
Beressi Haim -- None Available
Beressi Haim -- None Available
Beressi Haim -- Financial Title Company
Beressi Haim -- First American Title Co
Beressi Salvator $4,775,000 First American Title Co
Carlborg W Eric $4,300,000 Bridgespan Title Company
Derry Family Partnership Lp -- --
Pullman Glengarry Llc -- Fidelity National Title Co
Burlingame Hills Llc -- Fidelity National Title Co
Shao Chi Hwa $1,060,000 Fidelity National Title Co
Mays Lance A -- Fidelity National Title Co
Mays Lance A -- First American Title Guarant
Mays Lance A $515,000 Chicago Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Beressi Family Trust $750,000
Previous Owner Beressi Haim $1,000,000
Previous Owner Beressi Haim $511,000
Previous Owner Beressi Haim $515,000
Previous Owner Beressi Haim $750,000
Previous Owner Beressi Salvator $250,000
Previous Owner Beressi Haim $600,000
Previous Owner Beressi Salvator $1,500,000
Previous Owner Carlborg W Eric $4,000,000
Previous Owner Pullman Glengarry Llc $2,345,000
Previous Owner Shao Chi Hwa $515,000
Previous Owner Mays Lance A $600,000
Previous Owner Mays Lance A $148,250
Previous Owner Mays Lance A $663,750
Previous Owner Mays Lance A $100,000
Previous Owner Mays Lance A $462,982
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/25/2023 08/25/23 Sold $6,680,000 -4.5% $1,164 / Sq Ft
08/04/2023 08/04/23 Pending -- -- --
08/01/2023 08/01/23 Price Changed $6,995,000 -6.7% $1,219 / Sq Ft
07/06/2023 07/06/23 For Sale $7,500,000 -- $1,307 / 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
2023 $80,590 $5,659,000 $3,852,000 $1,807,000
2022 $70,280 $5,900,000 $4,015,540 $1,884,460
2021 $69,058 $5,800,000 $3,947,480 $1,852,520
2020 $60,875 $5,100,000 $3,264,000 $1,836,000
2019 $68,807 $5,849,696 $3,981,471 $1,868,225
2018 $66,819 $5,734,997 $3,903,403 $1,831,594
2017 $65,828 $5,622,547 $3,826,866 $1,795,681
2016 $64,211 $5,512,302 $3,751,830 $1,760,472
2015 $63,389 $5,429,504 $3,695,475 $1,734,029
2014 $47,342 $4,000,000 $2,722,500 $1,277,500
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81933859

MLSListings

APN: 030-032-200