NOT LISTED FOR SALE

223 Puffin Ct Foster City, CA 94404

Bay Vista Neighborhood

Estimated Value: $2,301,000 - $2,710,031

4 Beds
4 Baths
2,945 Sq Ft
$846/Sq Ft Est. Value

Last Sold July 26, 2013

Last sale price $1,278,000 $434 Per Sq Ft

Est. 95% increase in value since last sale

Current estimated payment $14,616/month

61 Days on Market

Highlights

  • Bay View
  • Primary Bedroom Suite
  • Marble Flooring
  • Audubon Elementary School Rated A
  • Recreation Room
  • Traditional Architecture

About This Home

As of July 2013

At just under 3000sf, this completely renovated home features many exquisite details and amenities. Crown moldings thru-out, Brazilian cherry wood flooring, a dramatic curved staircase, 4 bedrooms, 4 full baths including a master suite with bridge views and a guest suite with access to the garden. A bright kitchen /family room w/ fireplace and access to outdoor patio and bbq center. A must see!

Last Agent to Sell the Property

Earl Chan

Madison Hunter License #01248630 Listed on: 04/18/2013

Last Buyer's Agent

Ying Zhi Zhang

Ying Zhi Zhang, Broker License #01518945

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $18,124

Year Built

  • Built in 1965

Lot Details

  • 6,316

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Off-Street Parking

Home Design

  • Traditional Architecture
  • Tile Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 2,945 Sq Ft Home
  • 2-Story Property
  • Fireplace With Gas Starter
  • Double Pane Windows
  • Window Treatments
  • Bay Window
  • Family Room with Fireplace
  • Formal Dining Room
  • Recreation Room
  • Bay Views
  • Security System Owned

Kitchen

  • Open to Family Room
  • Breakfast Bar
  • Oven or Range
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Wall to Wall Carpet
  • Marble
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Main Floor Bedroom
  • Primary Bedroom Suite
  • 4 Full Bathrooms
  • Hydromassage or Jetted Bathtub
  • Bathtub with Shower
  • Walk-in Shower

Laundry

  • Dryer
  • Washer

Additional Features

  • Barbecue Area
  • Zoning described as R100
  • Forced Air Heating System

Listing and Financial Details

  • Assessor Parcel Number 094-156-560

Home Details

Home Type

Single Family

Est. Annual Taxes

$18,124

Year Built

Built in 1965

Lot Details

0

Parking

2

Listing Details

  • Subclass: Single Family Home
  • Style: Traditional
  • Sale Price Per Sq Ft: 433.96
  • Level Street Main: Bedroom(s)
  • Listing Class: Residential
  • Structure Sq Ft: 2945
  • Incorporated: Yes
  • Map Book Page: 749
  • Map Side Coordinate: 1
  • Map Top Coordinate: G
  • Thomas Bros Page: 749
  • Thomas Brothers: G1
  • Year Built: 1965
  • Zoning Description: R100
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: Kitchen / Family Room Combo
  • Fireplace: Family Room, Gas Starter, Yes
  • Dining Room: Formal Dining Room, Breakfast Bar
  • Kitchen: Dishwasher, Garbage Disposal, Refrigerator, Oven Range, Hookups - Gas
  • Living Sq Ft: 2945
  • Stories: 2
  • Security: Security Alarm - Owned
  • Bedrooms: Primary Suite / Retreat, Ground Floor Bedroom
  • Laundry: In Laundry Room, Dryer, Washer, Gas Hookup, 220 Volt Outlet
  • Flooring: Tile, Carpet - Wall to Wall, Hardwood, Marble
  • Additional Rooms: Rec/Rumpus Room
  • Maximum Bathrooms: 4
  • Minimum Bathrooms: 4
  • Full Bathrooms: 4
  • Total Bedrooms: 4
  • Bathroom: Showers over Tubs - 2+, Tubs - 2+, Stall Shower, Tub in Primary Bedroom, Tub with Jets

Exterior Features

  • Foundation: Concrete Perimeter
  • Pool Description: Pool - No
  • Roof: Tile
  • View: Bay
  • Yard/Grounds: BBQ Area

Garage/Parking

  • Garage Spaces: 2
  • Garage Parking Features: Attached Garage, Gate / Door Opener, Off-Street Parking

Utilities

  • Heating System: Forced Air

Association/Amenities

  • Amenities Miscellaneous: Window Covering(s), Double Pane Windows(s), Bay Window

Lot Info

  • Parcel Number: 094-156-560
  • Lot Location: Cul-de-Sac
  • List Price per Sq Ft: 444.14
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 6175.00
  • Lot Size Area Maximum Units: Square Feet
  • Lot Size Area Max Search: 6175.00
  • Lot Size Area Min Search: 6175.00
  • Maximum Lot Size: 6175.00
  • Map Book: Thomas Bros

Green Features

  • Energy Features: Double Pane Windows

Multi Family

  • Maximum Building Height: 2
  • Minimum Building Height: 2

MLS Schools

  • High School District Text: San Mateo Union High
  • Elementary School Text: Audubon Elementary

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Oct 6, 2020
Sold by
Yu Jimmy
Bought by
Yu Living Trust and Yu
Current Estimated Value
$2,491,508

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$485,000
Outstanding Balance
$344,803
Interest Rate
2.4%
Mortgage Type
New Conventional
Estimated Equity
$2,146,705

Purchase Details

Closed on
Sep 15, 2017
Sold by
Yu Jimmy and Tian Jiamin
Bought by
Yu Jimmy and Yu Jiamin T

Home Financials for this Owner

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

Purchase Details

Closed on
Sep 14, 2017
Sold by
Yu Jimmy and Yu Jiamin T
Bought by
Yu Jimmy and Yu Jiamin Tian

Home Financials for this Owner

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

Purchase Details

Closed on
Sep 2, 2014
Sold by
Yu Jimmy and Yu Jiamin Tian
Bought by
The Yu Living Trust and Yu Jiamin T

Purchase Details

Listed on
Apr 18, 2013
Closed on
Jul 24, 2013
Sold by
Chew Jack and Chew Debbie
Bought by
Yu Jimmy and Yu Jiamin Tian
Seller's Agent
Earl Chan
Madison Hunter
Buyer's Agent
Ying Zhi Zhang
Ying Zhi Zhang, Broker
List Price
$1,168,000
Sold Price
$1,278,000
Premium/Discount to List
$110,000
9.42%

Home Financials for this Owner

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

Purchase Details

Closed on
Nov 23, 2004
Sold by
Chew Jack and Chew Debbie
Bought by
Chew Jack and Chew Debbie

Home Financials for this Owner

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

Purchase Details

Closed on
Jul 9, 2004
Sold by
Chew Jack and Chew Debbie
Bought by
Chew Jack and Chew Debbie

Purchase Details

Closed on
Jun 19, 2002
Sold by
Libunao Joseph A and Libunao Aurora V
Bought by
Chew Jack and Chew Debbie

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$612,000
Interest Rate
6.86%
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
Yu Living Trust -- First American Title
Yu Jimmy -- First American Title
Yu Jimmy -- First American Title
Yu Jimmy -- First American Title Co
Yu Jimmy -- First American Title Company
The Yu Living Trust -- None Available
Yu Jimmy $1,278,000 Fidelity National Title Co
Chew Jack -- Alliance Title Company
Chew Jack -- --
Chew Jack $765,000 North American Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Yu Jimmy $485,000
Closed Yu Jimmy $485,000
Previous Owner Yu Jimmy $635,000
Previous Owner Chew Jack $850,000
Previous Owner Chew Jack $612,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
07/26/2013 07/26/13 Sold $1,278,000 -2.3% $434 / Sq Ft
06/18/2013 06/18/13 Pending -- -- --
05/06/2013 05/06/13 Price Changed $1,308,000 +12.0% $444 / Sq Ft
04/18/2013 04/18/13 For Sale $1,168,000 -- $397 / 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 $18,124 $1,566,644 $783,322 $783,322
2023 $18,124 $1,505,810 $752,905 $752,905
2022 $17,518 $1,476,286 $738,143 $738,143
2021 $17,294 $1,447,340 $723,670 $723,670
2020 $16,818 $1,432,500 $716,250 $716,250
2019 $15,932 $1,404,412 $702,206 $702,206
2018 $15,356 $1,376,876 $688,438 $688,438
2017 $15,184 $1,349,880 $674,940 $674,940
2016 $15,079 $1,323,412 $661,706 $661,706
2015 $14,730 $1,303,534 $651,767 $651,767
2014 $14,355 $1,278,000 $639,000 $639,000
Source: Public Records

Agents Affiliated with this Home

  • E

    Seller's Agent in 2013

    Earl Chan

    Madison Hunter

  • Y

    Buyer's Agent in 2013

    Ying Zhi Zhang

    Ying Zhi Zhang, Broker

See All Agents

Map

Source: MLSListings

MLS Number: ML81312748

MLSListings

APN: 094-156-560

California San Mateo County Foster City 94404 Bay Vista

223 Puffin Ct, Foster City, CA

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 © 2025 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