NOT LISTED FOR SALE

248 Puffin Ct Foster City, CA 94404

Bay Vista Neighborhood

Estimated Value: $2,104,000 - $2,718,000

4 Beds
2.5 Baths
2,160 Sq Ft
$1,127/Sq Ft Est. Value

Last Sold September 07, 2023

Last sale price $2,350,000 $1,088 Per Sq Ft

Est. 4% increase in value since last sale

Current estimated payment $15,100/month

151 Days on Market

Highlights

  • Bay View
  • Contemporary Architecture
  • Wine Refrigerator
  • Audubon Elementary School Rated A
  • Stone Countertops
  • 4-minute walk to Killdeer Park

About This Home

As of September 2023

Excellent opportunity to remodel this home to your style and liking. Diamond in the rough with lots of potential. Home has good bones and good floor plan. All inspections and reports/ disclosures available. Must tour with an appointment in advance. Open House Sat 3/19 and Sun 3/20 from 1 - 4pm Hurry!

Last Agent to Sell the Property

Stanley Lo

Green Banker Realty License #00874415 Listed on: 02/20/2023

Last Buyer's Agent

Chami Kang

Compass License #02033439

Compass

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $27,519

Year Built

  • Built in 1965

Lot Details

  • 6,177 Sq Ft Lot
  • Fenced
  • Paved or Partially Paved Lot
  • Level Lot
  • Corners Of The Lot Have Been Marked
  • Sprinklers on Timer
  • Grass Covered Lot
  • Back Yard
  • Zoning described as R10006

Parking

  • 2 Car Attached Garage
  • Electric Vehicle Home Charger

Property Views

  • Bay
  • Bridge

Home Design

  • Contemporary Architecture
  • Pillar, Post or Pier Foundation
  • Composition Roof
  • Concrete Perimeter Foundation
  • Stucco

Interior Spaces

  • 2,160 Sq Ft Home
  • 2-Story Property
  • Formal Entry
  • Living Room with Fireplace
  • Formal Dining Room
  • Crawl Space

Kitchen

  • Open to Family Room
  • Gas Oven
  • Range Hood
  • Freezer
  • Dishwasher
  • Wine Refrigerator
  • Kitchen Island
  • Stone Countertops
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Remodeled Bathroom

Laundry

  • Laundry in Garage
  • Gas Dryer Hookup

Additional Features

  • Balcony
  • Forced Air Heating System

Listing and Financial Details

  • Assessor Parcel Number 094-156-660

Home Details

Home Type

Single Family

Est. Annual Taxes

$27,519

Year Built

Built in 1965

Lot Details

0

Parking

2

Listing Details

  • Subclass: Single Family Home
  • Style: Contemporary
  • Property Condition: Built / Remodeled Green
  • Listing Class: Residential
  • Structure Sq Ft: 2160
  • Year Built: 1965
  • Zoning Description: R10006
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: Kitchen / Family Room Combo
  • Fireplace: Living Room
  • Dining Room: Dining Area in Living Room, Formal Dining Room
  • Kitchen: Countertop - Stone, Dishwasher, Freezer, Garbage Disposal, Hood Over Range, Island, Oven Range - Gas, Refrigerator, Wine Refrigerator
  • Living Sq Ft: 2160
  • Stories: 2
  • Laundry: Gas Hookup, In Garage
  • Additional Rooms: Formal Entry
  • Fireplaces Min: 1
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Bathroom: Updated Bath
  • Fireplace: Yes

Exterior Features

  • Foundation: Concrete Perimeter, Crawl Space, Pillars / Posts / Piers
  • Roof: Composition
  • View: Bay, Bridge
  • Yard/Grounds: Back Yard, Balcony / Patio, Low Maintenance, Sprinklers - Auto, Sprinklers - Lawn
  • Fencing: Fenced
  • Construction Type: Stucco

Garage/Parking

  • Garage Spaces: 2
  • Garage Parking Features: Attached Garage
  • Electric Vehicle Hookup Type: Electric Vehicle Hookup Level 1 (120 volts)

Utilities

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

Lot Info

  • Lot Description: Corners Marked, Grade - Level, Paved
  • Parcel Number: 094-156-660
  • Lot Acres: 0.1418
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 6175.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 6175.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
Feb 20, 2023
Closed on
Sep 5, 2023
Sold by
Ali Khatimun N and Ali Abdul
Bought by
Seo Juyung and Jeon Sangme
Seller's Agent
Stanley Lo
Green Banker Realty
Buyer's Agent
Chami Kang
Compass
List Price
$2,599,000
Sold Price
$2,350,000
Premium/Discount to List
-$249,000
-9.58%
Views
92
Current Estimated Value
$2,434,812

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$84,812
Avg. Annual Appreciation
1.64%
Original Mortgage
$1,150,000
Outstanding Balance
$1,123,618
Interest Rate
7%
Mortgage Type
New Conventional
Estimated Equity
$1,311,194

Purchase Details

Listed on
Mar 14, 2022
Closed on
Apr 21, 2022
Sold by
Prasad Family Trust
Bought by
Ali Khatimun N and Fahim Abdul
Seller's Agent
Raj Singh
Elite Real Estate Bay Area
Buyer's Agent
Vanah Sharma
Elite Real Estate Bay Area
List Price
$1,849,000
Sold Price
$2,110,000
Premium/Discount to List
$261,000
14.12%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8.24%
Original Mortgage
$1,371,500
Interest Rate
4.38%
Mortgage Type
Construction

Purchase Details

Closed on
Feb 13, 1999
Sold by
Rajendra Prasad
Bought by
Prasad Rajendra and Prasad Gaytri
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
Seo Juyung $2,350,000 Chicago Title Company
Ali Khatimun N $2,110,000 Chicago Title
Prasad Rajendra -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Seo Juyung $1,150,000
Previous Owner Ali Khatimun N $1,371,500
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
02/04/2025 02/04/25 Off Market $2,110,000 -- --
09/07/2023 09/07/23 Sold $2,350,000 -2.0% $1,088 / Sq Ft
07/21/2023 07/21/23 Pending -- -- --
06/06/2023 06/06/23 Price Changed $2,399,000 -7.7% $1,111 / Sq Ft
02/20/2023 02/20/23 For Sale $2,599,000 +23.2% $1,203 / Sq Ft
04/28/2022 04/28/22 Sold $2,110,000 +14.1% $977 / Sq Ft View Prior Sale
03/23/2022 03/23/22 Pending -- -- --
03/14/2022 03/14/22 For Sale $1,849,000 -- $856 / 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 $27,519 $2,397,000 $1,407,600 $989,400
2023 $27,519 $1,885,000 $1,306,000 $579,000
2022 $3,398 $259,039 $43,520 $215,519
2021 $3,343 $253,961 $42,667 $211,294
2020 $3,254 $251,358 $42,230 $209,128
2019 $3,092 $246,430 $41,402 $205,028
2018 $2,741 $241,599 $40,591 $201,008
2017 $2,708 $236,863 $39,796 $197,067
2016 $2,849 $232,219 $39,016 $193,203
2015 $2,780 $228,731 $38,430 $190,301
2014 $2,708 $224,252 $37,678 $186,574
Source: Public Records

Agents Affiliated with this Home

  • Stanley Lo

    Seller's Agent in 2023

    Stanley Lo

    Green Banker Realty

    (650) 222-1045

    2 in this area

    394 Total Sales

    Stanley Lo
    Section Image

  • C

    Buyer's Agent in 2023

    Chami Kang

    Compass

    (408) 448-4488

    1 in this area

    28 Total Sales

    Chami Kang
    Section Image
  • Raj Singh

    Seller's Agent in 2022

    Raj Singh

    Elite Real Estate Bay Area

    (510) 755-0980

    1 in this area

    23 Total Sales

    Raj Singh
    Section Image

  • V

    Buyer's Agent in 2022

    Vanah Sharma

    Elite Real Estate Bay Area

    Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81925774

MLSListings

APN: 094-156-660

California San Mateo County Foster City 94404 Bay Vista

248 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