---
listing_id: ML82061593
status: Active
price: 998000
beds: 2
baths_full: 2
baths_half: 1
sqft_living: 1386
sqft_lot: 
lot_acres: 
year_built: 2022
property_type: Residential
property_subtype: Condominium
address: "290 Waters Park Cir"
city: San Mateo
state: CA
zip: 94403
county: "San Mateo County"
lat: 37.550928
lng: -122.290966
days_on_market: 0
hoa_fee: 389
hoa_frequency: Monthly
garage_spaces: 2
list_agent: "Han Chi Tsai"
list_office: "JS Realty"
list_agent_phone: "(408) 799-5979"
list_agent_license: 01759949
mls_source: MLSL
modified: 2026-09-17
transaction_type: buy
---

Home | San Mateo County | San Mateo | 94403 | 290 Waters Park Cir

290 Waters Park Cir, San Mateo, CA 94403

MLS: ML82061593 | Status: Active | Price: $998,000
Beds/Baths: 2 / 2 /1
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
2 2 /1 1,386 2022

Remarks

Pre-foreclosure, lender approval required. Finance accepted. Meets effortless Bay Area living in this stunning 2-story home. Spanning 1,386 square feet, the open-concept layout is anchored by an upgraded chefs kitchen with an expansive center islandperfect for quick weekday breakfasts or lively weekend hosting. The dedicated dining area easily accommodates larger, formal dinners, while the bright living room opens directly to an oversized private patio for seamless indoor-outdoor entertaining. Upstairs, retreat to a spacious owners suite featuring its own private balcony and a large walk-in closet. The second bedroom also boasts a private walk-in closet, making it ideal for guests, roommates, or a dedicated home office. Complete with premium modern finishes currently being finalized. Easy freeway entrance.

MLS Listing Information

Field Value
MLS # ML82061593
MLS Source MLSListings, Inc.
Days on Site 0

Features

Interior Features

Feature Details
Bedrooms Primary Suite/Retreat - 2+, Walk-in Closet
Bathrooms Double Sinks, Primary - Stall Shower(s), Shower over Tub - 1, Tile
Kitchen Island with Sink
Appliances Dishwasher, Microwave, Oven Range - Electric
Dining Room Dining Area
Family Room No Family Room
Flooring Carpet, Laminate, Tile
Laundry Inside
Cooling Central Forced Air
Heating Central Forced Air

Exterior Features

Feature Details
Roof Shingle
Foundation Slab

Parking, School, and Other Information

Feature Details
Garage/Parking Common Parking Area, Detached, Garage: 2 Car(s)
Elementary District San Mateo-Foster City Elementary
High School District San Mateo Union High
Sewer Public Sewer
E.V. Hookup Electric Vehicle Hookup Level 2 (240 volts)
Water Public
HOA Fee $389
HOA Fee Frequency Monthly
Complex Amenities Barbecue Area, Garden / Greenbelt/ Trails, Playground
Zoning R3

Contact Information

Listing Agent Co-Listing Agent
Han Chi Tsai Kevin Lin
JS Realty JS Realty
License #: 01759949 License #: 02091737
Phone: (408) 799-5979 Phone: (408) 568-6093

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Fiesta Gardens International Elementary School public K-5 0.41 mi 4
College Park Elementary School public K-5 0.48 mi 9
Parkside Montessori public PK,KG,1,2,3,4,5,6,7,8 0.81 mi 9
George Hall Elementary School public K-5 0.94 mi 9
Foster City Elementary School public K-5 1.01 mi 9
Bayside Academy public K-8 1.05 mi 6
Beresford Elementary School public K-5 1.27 mi 4
LEAD Elementary public K-5 1.39 mi 2
San Mateo-Foster City Special Education Preschool public KG 1.41 mi N/A
Sunnybrae Elementary School public K-5 1.42 mi 2
Beach Park Elementary public K-5 1.46 mi 8
Laurel Elementary School public K-5 1.49 mi 3
Meadow Heights Elementary School public K-5 1.60 mi 7
Borel Middle School public 6-8 1.68 mi 8
Abbott Middle School public 6-8 1.72 mi 4
Brewer Island Elementary School public K-5 1.78 mi 9
Hillsdale High School public 9-12 1.85 mi 9
Central Elementary School public K-5 1.87 mi 9
Nesbit Elementary School public K-8 1.99 mi 6
Aragon High School public 9-12 2.10 mi 10

Nearby Homes

Address Price Beds Baths Sq Ft Status
2327 Armada Way $1,100,000 2 2/1 1,223 Active
Cove Ln $988,000 2 2 1,470 Active
3 Cove Ln $848,000 2 2 1,240 Contingent
1028 Foster Square Ln 201 $1,099,000 2 2 1,194 Active

Disclosures

©2026 MLSListings Inc. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MLSListings Inc.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of September 17, 2026. For the most current information, please contact Han Chi Tsai, (408) 799-5979.