NOT LISTED FOR SALE

Estimated Value: $6,216,000 - $7,711,933

6 Beds
4.5 Baths
5,895 Sq Ft
$1,217/Sq Ft Est. Value

Last Sold July 16, 2020

Last sale price $5,750,000 $975 Per Sq Ft

Est. 25% increase in value since last sale

Current estimated payment $45,379/month

62 Days on Market

Highlights

  • Wine Cellar
  • Bay View
  • Vaulted Ceiling
  • West Hillsborough Rated A+
  • Recreation Room
  • Soaking Tub in Primary Bathroom

About This Home

As of July 2020

Prisma Development Group and The AOI Group just completed this stunning, modern masterpiece. Meticulous Italian design elements emphasize bright open spaces, light stones, rich walnut accents and sleek satin black metal. Located on a quiet cul de sac, near Crocker Middle School, this exquisite home is the combination of elegance, luxury, and California living. Featuring approximately 5,895 sqft, this luxurious and private Hillsborough estate features 6 bedrooms and 4.5 bathrooms. The exceptionally designed backyard showcases a water feature, built in BBQ with pergola, and an inviting gas fire pit. New retaining walls surround the entire property with fresh landscaping for the utmost privacy.

Last Agent to Sell the Property

Emma Elfving

Compass License #01870848 Listed on: 04/25/2020

Compass

Co-Listed By

Erik Elfving

Compass License #01874451

Last Buyer's Agent

Michele Oravec

Compass License #01999680

Compass

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $75,416

Year Built

  • Built in 2020

Lot Details

  • 0.53 Acre Lot
  • Zoning described as R10025

Parking

  • 3 Car Garage

Property Views

  • Bay
  • Mountain
  • Neighborhood

Home Design

  • Post and Beam
  • Modern Architecture
  • Pillar, Post or Pier Foundation
  • Composition Roof

Interior Spaces

  • 5,895 Sq Ft Home
  • 3-Story Property
  • Beamed Ceilings
  • Vaulted Ceiling
  • Fireplace With Gas Starter
  • Bay Window
  • Wine Cellar
  • Separate Family Room
  • Living Room with Fireplace
  • Combination Dining and Living Room
  • Breakfast Room
  • Den
  • Recreation Room
  • Bonus Room
  • Electric Dryer Hookup

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Double Oven
  • Gas Oven
  • Gas Cooktop
  • Range Hood
  • Microwave
  • Wine Refrigerator
  • Quartz Countertops
  • Disposal

Flooring

  • Wood
  • Stone
  • Tile

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Walk-In Closet
  • Remodeled Bathroom
  • Bathroom on Main Level
  • Stone Countertops In Bathroom
  • Dual Sinks
  • Soaking Tub in Primary Bathroom
  • Bathtub with Shower
  • Oversized Bathtub in Primary Bathroom
  • Bathtub Includes Tile Surround
  • Walk-in Shower

Utilities

  • Forced Air Zoned Heating System
  • Vented Exhaust Fan

Listing and Financial Details

  • Assessor Parcel Number 028-411-090

Home Details

Home Type

Single Family

Est. Annual Taxes

$75,416

Year Built

Built in 2020

Lot Details

0

Parking

3

Listing Details

  • Subclass: Single Family Home
  • Style: Modern / High Tech
  • Property Condition: Built / Remodeled Green
  • Estimated Completion Date: 05/25/2020
  • Listing Class: Residential
  • Structure Sq Ft: 5895
  • Construction: Completed-Never Occupied
  • Year Built: 2020
  • Zoning Description: R10025
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: Separate Family Room
  • Fireplace: Gas Starter, Living Room
  • Dining Room: Breakfast Bar, Breakfast Room, Dining Area, Dining Area in Living Room, Eat in Kitchen
  • Kitchen: Cooktop - Gas, Countertop - Quartz, Exhaust Fan, Garbage Disposal, Hood Over Range, Microwave, Oven - Double, Oven - Gas, Pantry, Refrigerator, Wine Refrigerator
  • Living Sq Ft: 5895
  • Stories: 3
  • Bedrooms: Walk-in Closet
  • Laundry: Electricity Hookup (220V)
  • Flooring: Hardwood, Stone, Tile
  • Additional Rooms: Bonus / Hobby Room, Den / Study / Office, Office Area, Recreation Room, Wine Cellar / Storage
  • Fireplaces Min: 1
  • Maximum Numberof Bedrooms: 6
  • Minimum Numberof Bedrooms: 6
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bedrooms: 6
  • Bathroom: Double Sinks, Half on Ground Floor, Primary - Oversized Tub, Primary - Stall Shower(s), Shower and Tub, Stall Shower - 2+, Stone, Tile, Updated Bath
  • Fireplace: Yes

Exterior Features

  • Foundation: Post and Beam, Post and Pier
  • Roof: Composition
  • View: Bay, Mountains, Neighborhood

Garage/Parking

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

Utilities

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

Association/Amenities

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

Schools

  • School District: San Mateo Union High

Lot Info

  • Lot Description: Views
  • Parcel Number: 028-411-090
  • Lot Acres: 0.5280
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 23000.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 23000.00

Multi Family

  • Utilities: Public Utilities

MLS Schools

  • High School District Text: San Mateo Union High

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 25, 2020
Closed on
Jul 13, 2020
Sold by
Blue Wave Home Solutions Llc
Bought by
Martins Ryan S and Shah Smital Shantilal
Seller's Agent
Emma Elfving
Compass
Buyer's Agent
Michele Oravec
Compass
List Price
$6,495,000
Sold Price
$5,750,000
Premium/Discount to List
-$745,000
-11.47%
Current Estimated Value
$7,174,983

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$1,424,983
Avg. Annual Appreciation
5.43%
Original Mortgage
$4,312,500
Outstanding Balance
$3,841,046
Interest Rate
3.1%
Mortgage Type
New Conventional
Estimated Equity
$3,689,860

Purchase Details

Closed on
May 29, 2019
Sold by
Blue Wave Home Solutions Llc
Bought by
Blue Wave Home Solutions Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$144,250
Interest Rate
4.1%
Mortgage Type
Commercial

Purchase Details

Closed on
May 17, 2018
Sold by
Hunt Dainiel and The Hunt Living Trudsty
Bought by
Blue Wave Home Solution Ll

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$3,337,500
Interest Rate
4.4%
Mortgage Type
New Conventional

Purchase Details

Closed on
May 20, 2011
Sold by
Hunt Daniel
Bought by
Hunt Daniel

Home Financials for this Owner

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

Purchase Details

Closed on
Jun 7, 2009
Sold by
Hunt Daniel
Bought by
Hunt Daniel

Purchase Details

Closed on
Feb 9, 2005
Sold by
Molakides Theodore and Molakides Ted
Bought by
Hunt Dan

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,495,000
Interest Rate
5.75%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Feb 4, 2005
Sold by
Hunt Tamara
Bought by
Hunt Dan

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,495,000
Interest Rate
5.75%
Mortgage Type
Purchase Money Mortgage
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
Martins Ryan S $5,750,000 Old Republic Title Company
Blue Wave Home Solutions Llc -- Granite Escrow & Setmnt Svcs
Blue Wave Home Solution Ll $4,050,000 First American Title O
Hunt Daniel -- Advantage Title Inc
Hunt Daniel -- Advantage Title Inc
Hunt Daniel -- None Available
Hunt Dan $2,300,000 Alliance Title Company
Hunt Dan -- Alliance Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Martins Ryan S $4,312,500
Previous Owner Blue Wave Home Solutions Llc $800,000
Previous Owner Blue Wave Home Solutions Llc $144,250
Previous Owner Blue Wave Home Solution Ll $3,337,500
Previous Owner Hunt Daniel $2,500,000
Previous Owner Hunt Daniel $383,000
Previous Owner Hunt Daniel $1,550,000
Previous Owner Hunt Daniel $250,000
Previous Owner Hunt Daniel $250,000
Previous Owner Hunt Daniel $1,572,000
Previous Owner Hunt Daniel $1,584,000
Previous Owner Hunt Dan $1,500,000
Previous Owner Hunt Dan $100,000
Previous Owner Hunt Dan $1,495,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/16/2020 07/16/20 Sold $5,750,000 -11.5% $975 / Sq Ft
06/27/2020 06/27/20 Pending -- -- --
06/24/2020 06/24/20 For Sale $6,495,000 0.0% $1,102 / Sq Ft
06/17/2020 06/17/20 Pending -- -- --
04/25/2020 04/25/20 For Sale $6,495,000 -- $1,102 / 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 $75,416 $6,341,776 $2,814,322 $3,527,454
2023 $75,416 $6,095,520 $2,705,040 $3,390,480
2022 $71,193 $5,976,000 $2,652,000 $3,324,000
2021 $68,584 $5,750,000 $2,600,000 $3,150,000
2020 $50,225 $4,120,536 $2,874,625 $1,245,911
2019 $50,076 $4,131,000 $2,818,260 $1,312,740
2018 $35,519 $2,844,053 $1,837,598 $1,006,455
2017 $34,887 $2,788,289 $1,801,567 $986,722
2016 $33,949 $2,733,619 $1,766,243 $967,376
2015 $33,414 $2,692,559 $1,739,713 $952,846
2014 $32,276 $2,615,306 $1,705,635 $909,671
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81790323

MLSListings

APN: 028-411-090