Prevu by reAlpha
BuySellBlogBrowse Listings

224 Loon CourtFoster City, CA 94404

For Sale

$2,640,000

Smart Buyer Rebate $26,400

Beautifully remodeled Eichler home nestled in the desirable part of Foster City. This 4-bedroom, 2 bathrooms residence, with a separate office has been tastefully remodeled to combine timeless Eichler design with high-end modern upgrades. Spanning 1,871 square feet, the spacious and functional layout offers comfortable living spaces. The large family room, filled with natural light from skylights, seamlessly flows into the living room with a centerpiece wood-burning fireplace, creating an inviting and bright atmosphere. At the heart of the home is the chefs kitchen, featuring a 48" dual fuel range with two ovens, quartz countertops, a built-in refrigerator, and ample space for culinary creations. Energy-efficient features, with designer appliances, enhance sustainability without compromising style. Ample storage is provided through walk-in closets and built-ins throughout. The private backyard w/low-maintenance landscaping, while the two side yards offer endless possibilities for gardening, putting green or a dog run. The home offers a 1 car garage and a carport layout. Situated on a Cul-de-Sac with access to Turnstone Park and just a few blocks from Bay Trail. This is a rare opportunity to own a beautifully reimagined Eichler, perfect for modern living in a superb location.

Listed by Vladimir Rivkin

·

License #01193311

·

Rothschild & RUK Real Estate, Inc.

·

650-504-1231

Last updated December 15, 2025

·

Source: MLSListings #ML82023442

Listing Facts

  • TypeSingle-family
  • NeighborhoodBay Vista
  • Bedrooms4
  • Days on Prevu76
  • Size1,871 sqft
  • Price per sqft$1,411

Amenities

  • Private Outdoor Space
  • Pets Allowed
  • Parking

Location

Mortgage Calculator

Listing History

11/11/2025
Status changed to Active
$2,640,000
11/05/2025
Status changed to In Contract
$2,640,000
11/05/2025
Price Increased
$2,640,000
10/31/2025
Status changed to Active
$2,450,000
10/29/2025
Status changed to Removed from Feed
$2,450,000
10/28/2025
Status changed to Active
$2,450,000
10/23/2025
Status changed to Removed from Feed
$2,450,000
10/01/2025
Listed by Rothschild & RUK Real Estate, Inc.
$2,450,000

Property Details for 224 Loon Court

Exterior

Construction

  • Roof: Shingle
  • Stories: 1
  • Year Built: 1966
  • Year Built Details: 2
  • Architectural Style: Eichler

Features

  • Fencing: Fenced Back, Wood
  • Patio And Porch Features: Back Yard, Dog Run/Kennel

Measurements

  • Building Area Total: 1,871
  • Lot Features: Grade - Mostly Level
  • Lot Size Acres: 0.13
  • Lot Size Area: 5,761
  • Lot Size Source: Assessor
  • Lot Size Square Feet: 5,761
  • Lot Size Units: Square Feet

Financial

Taxes

  • Parcel Number: 094-212-810

Interior

Features

  • Appliances: Exhaust Fan, Garbage Disposal, Oven - Double, Oven - Electric, Oven Range - Built-In, Refrigerator
  • Fireplace Features: Wood Burning
  • Fireplaces Total: 1
  • Flooring: Tile, Vinyl/Linoleum
  • Interior Features: High Ceiling, Walk-in Closet

Measurements

  • Living Area: 1,871

Rooms

  • Bathrooms Full: 2
  • Bedrooms Total: 4

Parking

Parking

  • Attached Garage: Yes
  • Carport Spaces: 1
  • Carport: Yes
  • Garage Spaces: 1
  • Garage: Yes
  • Parking Features: Attached Garage, Carport, On Street, Parking Area
  • Parking Total: 2

Schools

Elementary School

  • Elementary School: Audubon Elementary_1
  • Elementary School District: San Mateo-Foster City Elementary

High School

  • High School: San Mateo High
  • High School District: San Mateo Union High

Middle or Junior School

  • Middle Or Junior School: Bowditch Middle

Utilities

Equipment

  • Heating: Radiant Floors
  • Laundry Features: In Garage
  • Sewer: Public Sewer
  • Utilities: Public Utilities

Frequently Asked Questions

How many bedrooms does this single-family home have?

There are 4 bedrooms in this single-family home at 224 Loon Court.

What schools are nearby to 224 Loon Court?

Nearby schools include the Audubon Elementary_1, Bowditch Middle, and San Mateo High.

Does this single-family home have parking?

Yes, there is 1 parking space available for 224 Loon Court.

How does 224 Loon Court compare to other single-family homes in Bay Vista?

This single-family home is listed 13% above the average price for single-family homes in Bay Vista and has been on the market for 74 more days than the typical home in this area.

What is the square footage on this single-family home?

According to the MLS, this listing is 1,871 sqft.

224 Loon Court is a 4-bedroom single-family home for sale in Foster City CA 94404. On Prevu for 76 days at $2,640,000. This includes a recent price increase of $190,000. This home features 1,871 square feet of living space, located in Foster City. The median listing price for single-family homes in this area is $2,780,000. Nearby schools include Audubon Elementary_1, Bowditch Middle, and San Mateo High. Additional amenities include private outdoor space, pets allowed, and parking. Explore more single-family home listings in Foster City.

Based on information from MLSListings™️ and/or other sources. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by Prevu or the MLS. Information is provided exclusively for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing.

Full MLS Disclaimers

Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.