NOT LISTED FOR SALE

Estimated Value: $11,543,000 - $12,955,660

5 Beds
9 Baths
10,400 Sq Ft
$1,178/Sq Ft Est. Value

Sale Details

Date Sold: November 15, 2023

Last sale price $11,750,000 $1,130 Per Sq Ft

Est. 11% decrease in value since last sale

Current estimated payment $69,257 / mo

100 Days on Market

Highlights

  • Tennis Courts
  • Wine Cellar
  • Cabana
  • North Hillsborough School Rated A
  • Media Room
  • Two Primary Bedrooms

About This Home

As of November 2023

Regally set on 2.8 glorious acres on iconic Robin Road, this custom built estate has a total 10,400 Square feet of luxurious living area. This home is like NEW. Seldom used by owners. Industrial quality construction top to bottom. Priced millions below replacement cost. Inside are 5 bedroom suites including a huge primary suite with 2 bathrooms, and 2 walk-in closets. Additional rooms include a baronial scaled foyer, grand living and dining rooms, separate music room, family room, media room, professional kitchen and breakfast room, all opening onto limestone terraces, the manicured grounds and gardens, sunny pool and tennis court, plus the original Redwood Grove from the Carolands estate. Reached through a Porte Cachere, is a 4 car garage and massive motor court.. Built for the owners as the Ultimate dream home, no expense was spared, no detail overlooked in creating this amazing home that, by any definition, is world class. To view this home is an experience one will never forget.

Last Agent to Sell the Property

Edward Stephens

Coldwell Banker Realty License #00462186 Listed on: 07/07/2023

Coldwell Banker Realty

Last Buyer's Agent

Jim Arbeed

Coldwell Banker Realty License #01060476

Coldwell Banker Realty

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 Details

Home Type

  • Single Family

Year Built

  • Built in 2001

Lot Details

  • 2.77 Acre Lot
  • Northeast Facing Home
  • Security Fence
  • Secluded Lot
  • Sprinkler System
  • Zoning described as R1002A

Parking

  • 4 Car Attached Garage
  • Electric Vehicle Home Charger
  • Lighted Parking
  • Garage Door Opener
  • Electric Gate
  • Secured Garage or Parking
  • Guest Parking
  • Off-Street Parking

Home Design

  • French Architecture
  • Foundation Moisture Barrier
  • Wood Frame Construction
  • Slate Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 10,400 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Central Vacuum
  • Entertainment System
  • High Ceiling
  • Skylights
  • Bay Window
  • Formal Entry
  • Wine Cellar
  • Family Room with Fireplace
  • 3 Fireplaces
  • Great Room
  • Living Room with Fireplace
  • Breakfast Room
  • Formal Dining Room
  • Media Room
  • Den
  • Utility Room
  • Garden Views

Kitchen

  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Marble Countertops
  • Trash Compactor
  • Disposal

Flooring

  • Wood
  • Carpet
  • Marble

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Main Floor Bedroom
  • Fireplace in Primary Bedroom
  • Double Master Bedroom
  • Walk-In Closet
  • Bathtub

Laundry

  • Laundry Room
  • Laundry on upper level
  • Washer and Dryer
  • Laundry Tub

Home Security

  • Security Lights
  • Security Gate
  • Monitored
  • Fire Sprinkler System

Pool

  • Cabana
  • Heated In Ground Pool
  • In Ground Spa
  • Fence Around Pool
  • Pool Sweep

Outdoor Features

  • Tennis Courts
  • Balcony
  • Barbecue Area

Utilities

  • Forced Air Heating and Cooling System
  • Cable TV Available

Community Details

  • Controlled Access

Listing and Financial Details

  • Assessor Parcel Number 030-081-020

Home Details

Home Type

Single Family

Year Built

Built in 2001

Lot Details

2.77 Acres

Parking

4

Listing Details

  • Subclass: Single Family Home
  • Style: French
  • Listing Class: Residential
  • Structure Sq Ft: 10400
  • Year Built: 2001
  • Zoning Description: R1002A
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: Separate Family Room
  • Fireplace: Family Room, Living Room, Primary Bedroom
  • Dining Room: Breakfast Room, Formal Dining Room
  • Kitchen: Cooktop - Gas, Countertop - Marble, Dishwasher, Garbage Disposal, Island, Microwave, Pantry, Refrigerator, Trash Compactor
  • Living Sq Ft: 10400
  • Stories: 2
  • Security: Controlled / Secured Access, Fire System - Sprinkler, Secured Garage / Parking, Security Alarm, Security Fence, Security Lights, Video / Audio System
  • Bedrooms: Ground Floor Bedroom, More than One Primary Bedroom, Walk-in Closet
  • Laundry: In Utility Room, Inside, Tub / Sink, Upper Floor, Washer / Dryer
  • Flooring: Carpet, Hardwood, Marble
  • Additional Rooms: Den / Study / Office, Formal Entry, Great Room, Laundry Room, Media / Home Theater, Office Area, Utility Room, Wine Cellar / Storage
  • Fireplaces Min: 3
  • Full Bathrooms: 6
  • Half Bathrooms: 3
  • Total Bedrooms: 5
  • Bathroom: Tub in Primary Bedroom
  • Fireplace: Yes

Exterior Features

  • Foundation: Concrete Perimeter, Foundation Moisture Barrier
  • Pool Description: Cabana / Dressing Room, Pool - Fenced, Pool - Heated, Pool - In Ground, Pool - Sweep, Spa - In Ground, Spa - Jetted
  • Roof: Slate
  • View: Garden / Greenbelt
  • Yard/Grounds: Balcony / Patio, BBQ Area, Fenced, Sprinklers - Lawn, Tennis Court
  • Pool: Yes
  • Property Faces: Northeast
  • Construction Type: Wood Frame

Garage/Parking

  • Garage Spaces: 4
  • Garage Parking Features: Attached Garage, Drive Through, Electric Car Hookup, Electric Gate, Gate / Door Opener, Guest / Visitor Parking, Lighted Parking Area, Off-Street Parking
  • Electric Vehicle Hookup Type: Electric Vehicle Hookup Level 2 (240 volts)

Utilities

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

Association/Amenities

  • Amenities Miscellaneous: Bay Window, Built-in Vacuum, High Ceiling, Security Gate, Skylight, Video / Audio System, Walk-in Closet, Wet Bar

Lot Info

  • Lot Description: Private / Secluded, Views
  • Parcel Number: 030-081-020
  • Lot Acres: 2.7707
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 120690.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 120690.00

Multi Family

  • Utilities: Public Utilities

MLS Schools

  • High School District Text: San Mateo Union High

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 7, 2023
Closed on
Nov 9, 2023
Sold by
Robert Schonfeld Living Trust
Bought by
Seller's Agent
Edward Stephens
Coldwell Banker Realty
Buyer's Agent
Jim Arbeed
Coldwell Banker Realty
List Price
$14,850,000
Sold Price
$11,750,000
Premium/Discount to List
-$3,100,000
-20.88%
Views
347
Current Estimated Value
$10,478,437

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$1,271,563
Avg. Annual Appreciation
1.49%

Purchase Details

Closed on
Mar 27, 2019
Sold by
Schonfeld Robert
Bought by
Schonfeld Robert

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$13,500,000
Interest Rate
4.3%
Mortgage Type
Reverse Mortgage Home Equity Conversion Mortgage

Purchase Details

Closed on
Jul 11, 1997
Sold by
Ching William and Ching Rosemarie Garcia
Bought by
Schonfeld Robert
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Hillsborough, CA

See All Agents

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
$11,750,000 Lawyers Title Company
Schonfeld Robert -- Members Title Co Of Ca Inc
Schonfeld Robert $2,284,000 Fidelity National Title Co
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
Previous Owner $13,500,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
11/15/2023 11/15/23 Sold $11,750,000 -7.8% $1,130 / Sq Ft
10/16/2023 10/16/23 Pending -- -- --
10/10/2023 10/10/23 Price Changed $12,750,000 -14.1% $1,226 / Sq Ft
07/07/2023 07/07/23 For Sale $14,850,000 -- $1,428 / 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 $137,303 $11,985,000 $9,843,000 $2,142,000
2023 $137,303 $5,448,987 $2,609,112 $2,839,875
2022 $64,238 $5,342,145 $2,557,953 $2,784,192
2021 $62,953 $5,237,398 $2,507,798 $2,729,600
2020 $61,881 $5,183,696 $2,482,084 $2,701,612
2019 $60,496 $5,082,056 $2,433,416 $2,648,640
2018 $58,740 $4,982,408 $2,385,702 $2,596,706
2017 $57,843 $4,884,715 $2,338,924 $2,545,791
2016 $56,402 $4,788,937 $2,293,063 $2,495,874
2015 $55,655 $4,717,004 $2,258,620 $2,458,384
2014 $54,263 $4,624,605 $2,214,377 $2,410,228
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81934280

MLSListings

APN: 030-081-020

Your Personal Tour Guide

Ask me questions while you tour the home.