NOT LISTED FOR SALE

Estimated Value: $4,746,000 - $5,046,000

4 Beds
4.5 Baths
2,969 Sq Ft
$1,633/Sq Ft Est. Value

Last Sold November 09, 2023

Last sale price $4,825,000 $1,625 Per Sq Ft

Current estimated payment $29,760/month

37 Days on Market

Highlights

  • Under Construction
  • Solar Power System
  • Craftsman Architecture
  • Lincoln Elementary School Rated A
  • Primary Bedroom Suite
  • Mountain View

About This Home

As of November 2023

This brand new construction in the Esaton Addition of Burlingame offers unparalleled luxury and comfort. With 4 bedrooms and 4.5 bathrooms with a loft/sitting space in the second floor, the home boasts a modern design and high-quality materials. The open floor plan and abundant natural light accentuate the sleek, contemporary style. The large kitchen features custom cabinets and top-of-the-line Thermador appliances, and the ample storage throughout the home includes a walk-in closet in the master bedroom and a large pantry in the kitchen, etc... The generously sized bedrooms each have their own ensuite bathrooms and plenty of closet space. Sliding glass doors in the living area seamlessly blend indoor and outdoor living, leading to a spacious patio and backyard perfect for hosting barbecues. But that's not all - this home is also energy-efficient, featuring an 8.0-kilowatt solar panel system that's owned outright. Built to last, this stunning modern home is a must-see!

Last Agent to Sell the Property

Behzad Hadjian

Coldwell Banker Realty License #02135674 Listed on: 10/02/2023

Coldwell Banker Realty

Last Buyer's Agent

Jenn Gilson

Golden Gate Sotheby's International Realty License #01889172

Golden Gate Sotheby's International Realty

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2023 | Under Construction

Lot Details

  • 5,998 Sq Ft Lot
  • Security Fence
  • Gated Home
  • Sprinklers on Timer
  • Back Yard
  • Zoning described as R10006

Parking

  • 2 Car Detached Garage
  • Electric Vehicle Home Charger
  • Garage Door Opener
  • Secured Garage or Parking

Home Design

  • Craftsman Architecture
  • Post and Beam
  • Steel Frame
  • Wood Frame Construction
  • Ceiling Insulation
  • Floor Insulation
  • Shingle Roof
  • Composition Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 2,969 Sq Ft Home
  • 1-Story Property
  • Wired For Sound
  • High Ceiling
  • Double Pane Windows
  • Family Room with Fireplace
  • 2 Fireplaces
  • Living Room with Fireplace
  • Family or Dining Combination
  • Mountain Views
  • Crawl Space
  • Attic

Kitchen

  • Open to Family Room
  • Eat-In Kitchen
  • Built-In Self-Cleaning Oven
  • Electric Oven
  • Electric Cooktop
  • Range Hood
  • Microwave
  • Ice Maker
  • Dishwasher
  • Wine Refrigerator
  • Kitchen Island
  • Quartz Countertops
  • Disposal

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet
  • Bathroom on Main Level
  • Dual Sinks
  • Low Flow Toliet
  • Bathtub with Shower
  • Bathtub Includes Tile Surround
  • Walk-in Shower
  • Low Flow Shower

Laundry

  • Laundry Room
  • Laundry on upper level
  • Laundry Tub

Home Security

  • Security Lights
  • Monitored
  • Fire and Smoke Detector
  • Fire Sprinkler System

Eco-Friendly Details

  • Energy-Efficient HVAC
  • Energy-Efficient Insulation
  • Solar Power System
  • Solar owned by seller

Outdoor Features

  • Balcony
  • Enclosed Patio or Porch

Utilities

  • Zoned Heating and Cooling
  • Vented Exhaust Fan
  • Heat Pump System

Listing and Financial Details

  • Assessor Parcel Number 026-033-160

Home Details

Home Type

Single Family

Year Built

Built in 2023 | Under Construction

Lot Details

5,998 Sq Ft Lot

Parking

2

Listing Details

  • Subclass: Single Family Home
  • Style: Craftsman
  • Estimated Completion Date: 10/14/2023
  • Listing Class: Residential
  • Structure Sq Ft: 2969
  • Construction: New Construction, Under Construction
  • Year Built: 2023
  • Zoning Description: R10006
  • Special Features: NewHome
  • Property Sub Type: Detached

Interior Features

  • Family Room: Kitchen / Family Room Combo
  • Fireplace: Family Room, Living Room
  • Dining Room: Dining Area, Dining Area in Family Room, Eat in Kitchen
  • Kitchen: Cooktop - Electric, Countertop - Quartz, Dishwasher, Exhaust Fan, Garbage Disposal, Hood Over Range, Ice Maker, Island, Microwave, Oven - Built-In, Oven - Electric, Oven - Self Cleaning, Pantry, Refrigerator, Wine Refrigerator
  • Living Sq Ft: 2969
  • Stories: 1
  • Security: Fire Alarm, Fire System - Sprinkler, Secured Garage / Parking, Security Fence, Security Lights, Video / Audio System
  • Bedrooms: Ground Floor Bedroom, Primary Suite / Retreate - 2+, Walk-in Closet
  • Laundry: In Utility Room, Inside, Tub / Sink, Upper Floor
  • Flooring: Hardwood, Tile
  • Additional Rooms: Attic, Laundry Room
  • Fireplaces Min: 2
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Bathroom: Double Sinks, Full on Ground Floor, Half on Ground Floor, Shower and Tub, Shower over Tub - 1, Stall Shower - 2+, Tile, Tubs - 2+
  • Fireplace: Yes

Exterior Features

  • Foundation: Concrete Perimeter, Crawl Space, Post and Beam
  • Roof: Composition, Shingle
  • View: Mountains
  • Yard/Grounds: Back Yard, Balcony / Patio, Fenced, Porch - Enclosed, Sprinklers - Auto, Sprinklers - Lawn
  • Fencing: Fenced, Gate, Mixed Height / Type
  • Construction Type: Concrete, Steel Frame, Wood Frame

Garage/Parking

  • Garage Spaces: 2
  • Garage Parking Features: Detached Garage, Electric Car Hookup, Gate / Door Opener
  • Electric Vehicle Hookup Type: Electric Vehicle Hookup Level 2 (240 volts)

Utilities

  • Cooling System: Central AC, Multi-Zone
  • Heating System: Fireplace, Heat Pump
  • Sewer/Septic System: Drainage - Other, Sewer - Public, Sewer Connected

Association/Amenities

  • Amenities Miscellaneous: High Ceiling, Walk-in Closet

Schools

  • High School: 615

Lot Info

  • Lot Description: Regular
  • Parcel Number: 026-033-160
  • Lot Acres: 0.1377
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 6000.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 6000.00

Green Features

  • Energy Features: Ceiling Insulation, Double Pane Windows, Energy Star HVAC, Insulation - Floor, Low Flow Shower, Low Flow Toilet, Solar Power, Walls Insulated

Multi Family

  • Utilities: Solar Panels - Owned

MLS Schools

  • High School District Text: San Mateo Union High
  • High School Text: Burlingame High
  • Middle School Text: Burlingame Intermediate

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 2, 2023
Closed on
Oct 25, 2023
Sold by
Hadjian Behzad and Hadjian Johnny Shokouh
Bought by
Lin Family Trust and Lin
Seller's Agent
Behzad Hadjian
Coldwell Banker Realty
Buyer's Agent
Jenn Gilson
Golden Gate Sotheby's International Realty
List Price
$4,825,000
Sold Price
$4,825,000
Current Estimated Value
$4,849,025

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$24,025
Avg. Annual Appreciation
0.21%
Original Mortgage
$3,281,000
Outstanding Balance
$3,180,381
Interest Rate
5.63%
Mortgage Type
New Conventional
Estimated Equity
$1,668,644

Purchase Details

Listed on
Mar 3, 2021
Closed on
Mar 15, 2021
Sold by
Manfredi Marital Trust and Manfredi Diane
Bought by
Hadjian Behzad and Hadjian Johnny Shokouh
Seller's Agent
Raziel A. Ungar
Compass
Buyer's Agent
Hossein Djalali
Coldwell Banker Realty
List Price
$1,900,000
Sold Price
$2,240,000
Premium/Discount to List
$340,000
17.89%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
33.58%

Purchase Details

Listed on
Mar 3, 2021
Closed on
Mar 12, 2021
Sold by
Sheila Rezayan
Bought by
Hadjian Behzad
Seller's Agent
Raziel A. Ungar
Compass
Buyer's Agent
Hossein Djalali
Coldwell Banker Realty
List Price
$1,900,000
Sold Price
$2,240,000
Premium/Discount to List
$340,000
17.89%

Purchase Details

Closed on
Jun 15, 2017
Sold by
Manfredi Vivian A and Manfredi Marital Trust
Bought by
Manfredi Vivian A and Manfredi Diane

Purchase Details

Closed on
Feb 20, 2016
Sold by
Manfredi Vivian A
Bought by
Manfredi Vivian A

Purchase Details

Closed on
Aug 9, 2006
Sold by
Manfredi Reno
Bought by
Manredi Reno and Manfredi Vivian A

Purchase Details

Closed on
May 9, 2006
Sold by
Manfredi Reno and Mafredi Vivian A
Bought by
Mafredi Reno and Manfredi Vivian A
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
Lin Family Trust $4,825,000 Lawyers Title Company
Hadjian Behzad $2,240,000 Lawyers Title
Hadjian Behzad -- Lawyers Title
Shokouh S Johnny -- Lawyers Title
Manfredi Vivian A -- None Available
Manfredi Vivian A -- None Available
Manredi Reno -- None Available
Manfredi Reno -- None Available
Mafredi Reno -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Lin Family Trust $3,281,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
11/09/2023 11/09/23 Sold $4,825,000 0.0% $1,625 / Sq Ft
11/09/2023 11/09/23 Pending -- -- --
10/02/2023 10/02/23 For Sale $4,825,000 +115.4% $1,625 / Sq Ft
03/17/2021 03/17/21 Sold $2,240,000 +17.9% $2,000 / Sq Ft View Prior Sale
03/10/2021 03/10/21 Pending -- -- --
03/03/2021 03/03/21 For Sale $1,900,000 -- $1,696 / 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 $54,361 $4,921,500 $2,550,000 $2,371,500
2023 $54,361 $2,196,376 $2,018,376 $178,000
2022 $26,062 $2,284,800 $1,978,800 $306,000
2021 $1,585 $97,562 $38,481 $59,081
2020 $1,555 $96,563 $38,087 $58,476
2019 $1,530 $94,671 $37,341 $57,330
2018 $1,506 $92,815 $36,609 $56,206
2017 $1,494 $90,996 $35,892 $55,104
2016 $1,440 $89,213 $35,189 $54,024
2015 $1,433 $87,874 $34,661 $53,213
2014 $1,414 $86,154 $33,983 $52,171
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: MLSListings

MLS Number: ML81943726

MLSListings

APN: 026-033-160

Your Personal Tour Guide

Ask me questions while you tour the home.