NOT LISTED FOR SALE

788 Irwin Ct Burlingame, CA 94010

Estimated Value: $7,150,000 - $16,895,597

5 Beds
6.5 Baths
7,447 Sq Ft
$1,614/Sq Ft Est. Value

Last Sold April 05, 2019

Last sale price $12,500,000 $1,679 Per Sq Ft

Est. 4% decrease in value since last sale

Current estimated payment $75,879/month

58 Days on Market

Highlights

  • Wine Cellar
  • In Ground Pool
  • Vaulted Ceiling
  • North Hillsborough School Rated A
  • Recreation Room
  • Wood Flooring

About This Home

As of April 2019

GORGEOUS GATED TUSCAN VILLA, JUST COMPLETED. LOCATED ON A BEST & NON THRU STREET. SIGNATURE HOME WITH FINE CRAFTSMANSHIP & HIGH CEILING & BRIGHT, LUXURIOUS APPOINTMENTS AND MODERN AMENITIES. ENTIRE AMBIENCE IS ENDLAESS21. PROPERTY FEATURES SMART HOME AUTOMATION, ROOM FOR FUTURE HOME THEATER, WINE CELLAR, SEPARATE EXECUTIVE OFFICE, STATE OF THE ART OUTDOOR BBQ, FIRE PIT PATIO, SWIMMING JET POOL FEATURING 8 FOUNTAIN JETS & POOL COVER. BEDROOM-SIZED MASTER, PLUS 2100+/-SQFT OF STORAGE AND CLOSET FOR HER.STATE OF THE ART ELEVATOR. MASSIVE LAWN WITH AN INCREDIBLE LANDSCAPE WITH STATE OF THE ART BARBEQUE MAKES THE EXTERIOR OF THIS PROPERTY AS IMPRESSIVE AS THE INTERIOR!

Last Agent to Sell the Property

Stanley Lo

Green Banker Realty License #00874415 Listed on: 01/25/2019

Last Buyer's Agent

Stanley Lo

Green Banker Realty License #00874415 Listed on: 01/25/2019

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2019

Lot Details

  • 0.69 Acre Lot
  • Gated Home
  • Level Lot
  • Sprinklers on Timer
  • Back Yard
  • Zoning described as R10000

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Guest Parking

Home Design

  • Tile Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 7,447 Sq Ft Home
  • Wet Bar
  • Vaulted Ceiling
  • 2 Fireplaces
  • Gas Log Fireplace
  • Double Pane Windows
  • Wine Cellar
  • Separate Family Room
  • Formal Dining Room
  • Den
  • Recreation Room
  • Bonus Room
  • Storage Room
  • Laundry in unit
  • Wood Flooring
  • Neighborhood Views
  • Finished Basement

Kitchen

  • Eat-In Kitchen
  • Built-In Double Oven
  • Gas Cooktop
  • Range Hood
  • Warming Drawer
  • Microwave
  • Freezer
  • Dishwasher
  • Wine Refrigerator
  • Kitchen Island
  • Marble Countertops

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • Dual Sinks
  • Bathtub with Shower
  • Walk-in Shower

Home Security

  • Security Gate
  • Intercom
  • Smart Home
  • Alarm System

Outdoor Features

  • In Ground Pool
  • Balcony
  • Outdoor Kitchen
  • Fire Pit
  • Barbecue Area

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Separate Meters
  • Individual Gas Meter
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 028-110-140

Home Details

Home Type

Single Family

Year Built

Built in 2019

Lot Details

0.69 Acres

Parking

3

Listing Details

  • Subclass: Single Family Home
  • Listing Class: Residential
  • Structure Sq Ft: 7447
  • Incorporated: Yes
  • Year Built: 2019
  • Zoning Description: R10000
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: Separate Family Room
  • Fireplace: Gas Log
  • Dining Room: Dining Area, Eat in Kitchen, Formal Dining Room
  • Kitchen: Cooktop - Gas, Countertop - Marble, Dishwasher, Freezer, Hood Over Range, Island with Sink, Microwave, Oven - Built-In, Oven - Double, Pantry, Refrigerator, Warming Drawer, Wine Refrigerator
  • Living Sq Ft: 7447
  • Security: Security Alarm
  • Laundry: Inside
  • Flooring: Hardwood
  • Additional Rooms: Basement - Finished, Bonus / Hobby Room, Den / Study / Office, Recreation Room, Storage, Wine Cellar / Storage
  • Fireplaces Min: 2
  • Full Bathrooms: 6
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Bathroom: Double Sinks, Showers over Tubs - 2+, Stall Shower - 2+, Tub in Primary Bedroom
  • Fireplace: Yes

Exterior Features

  • Foundation: Concrete Perimeter
  • Pool Description: Pool - In Ground
  • Roof: Tile
  • View: Neighborhood
  • Yard/Grounds: Back Yard, Balcony / Patio, BBQ Area, Fenced, Fire Pit, Outdoor Kitchen, Sprinklers - Auto
  • Pool: Yes
  • Fencing: Fenced, Gate

Garage/Parking

  • Garage Spaces: 3
  • Garage Parking Features: Attached Garage, Gate / Door Opener, Guest / Visitor Parking

Utilities

  • Cooling System: Central AC
  • Heating System: Central Forced Air - Gas, Heating - 2+ Zones
  • Sewer/Septic System: Sewer - Public, Sewer Connected

Association/Amenities

  • Amenities Miscellaneous: High Ceiling, Security Gate, Vaulted Ceiling, Walk-in Closet, Wet Bar

Lot Info

  • Lot Description: Grade - Level
  • Parcel Number: 028-110-140
  • Lot Acres: 0.6887
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 30000.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 30000.00

Green Features

  • Energy Features: Double Pane Windows, Smart Home System

Multi Family

  • Utilities: Individual Electric Meters, Individual Gas Meters

MLS Schools

  • High School District Text: San Mateo Union High

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 25, 2019
Closed on
Apr 2, 2019
Sold by
Green Banker Llc
Bought by
Wu Jia
Seller's Agent
Stanley Lo
Green Banker Realty
Buyer's Agent
Stanley Lo
Green Banker Realty
List Price
$13,980,000
Sold Price
$12,500,000
Premium/Discount to List
-$1,480,000
-10.59%
Current Estimated Value
$12,022,799

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$477,201
Avg. Annual Appreciation
-0.56%

Purchase Details

Closed on
Oct 15, 2013
Sold by
Tobin Michael Henry Deyou
Bought by
Green Banker Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,900,000
Interest Rate
4.25%
Mortgage Type
New Conventional
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
Wu Jia $12,500,000 Chicago Title Insurance Co
Green Banker Llc $3,840,000 Chicago Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Green Banker Llc $1,900,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
04/05/2019 04/05/19 Sold $12,500,000 -10.6% $1,679 / Sq Ft
03/25/2019 03/25/19 Pending -- -- --
01/25/2019 01/25/19 For Sale $13,980,000 -- $1,877 / 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 $161,359 $14,567,984 $7,585,527 $6,982,457
2023 $161,359 $13,402,524 $7,290,973 $6,111,551
2022 $149,866 $13,139,730 $7,148,013 $5,991,717
2021 $147,046 $12,882,089 $7,007,856 $5,874,233
2020 $144,650 $12,750,000 $6,936,000 $5,814,000
2019 $101,386 $8,819,843 $4,219,843 $4,600,000
2018 $60,777 $5,484,101 $4,137,101 $1,347,000
2017 $45,291 $4,055,982 $4,055,982 $0
2016 $44,305 $3,976,453 $3,976,453 $0
2015 $43,875 $3,916,723 $3,916,723 $0
2014 $42,841 $3,840,000 $3,840,000 $0
Source: Public Records

Agents Affiliated with this Home

  • Stanley Lo

    Seller's Agent in 2019

    Stanley Lo

    Green Banker Realty

    (650) 222-1045

    52 in this area

    384 Total Sales

    Stanley Lo
    Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81736531

MLSListings

APN: 028-110-140

California San Mateo County Burlingame 94010

788 Irwin Ct, Burlingame, CA

Not Listed for Sale

Detached

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

MLSListings Property Information © 2026 MLSListings Inc. All rights reserved. Listing information is deemed reliable but not guaranteed. Certain information contained herein is derived from information which is the licensed property of, and copyrighted by, MLSListings Inc. The viewer acknowledges ownership and validity of its copyright. Information provided is for personal, non-commercial use by a viewer with a bona fide interest in the purchase or sale of real estate of the type being offered via this website or other electronic means. The viewer is prohibited from copying, redistributing or retransmitting any of the data or information provided by MLSListing, Inc.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.