Home | San Mateo County | Foster City | 94404 | 1006 Stern Ln
MLS: ML82045185 | Status: Active | Price: $1,099,000
Beds/Baths: 2 / 2 /1
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 2 | 2 /1 | 1,580 | – | 1989 |
| Date | Time | Hosted By |
|---|---|---|
| Saturday, May 2 | 1:30 pm - 4:00 pm | Andy Gan |
| Sunday, May 3 | 1:30 pm - 4:00 pm | Andy Gan |
Stunning sunny and bright modern end unit home with water view! Serene cul-de-sac court location. Airy spacious living room with soaring ceiling and fireplace leads to rear deck with greenbelt view. Spectacular lagoon view from open kitchen and dining room. Dining room and both bedrooms with own balcony accessed through sliding doors. Spacious primary bathroom with double sink vanity and hallway bathroom with window. Dual pane windows throughout. Attached garage. Sought-after community surrounded by water with resort-like amenities: pool, playground, private community white beach on lagoon, boat accessibility. HOA pays building earthquake and fire insurance. Walk to Ranch 99&Edgewater Plaza, Bay Trail, Sea Cloud Park, top schools. Major employers nearby: Gilead, Visa, Sony, EA, Oracle. Quick access to Hwy 92&101.
| Field | Value |
|---|---|
| MLS # | ML82045185 |
| MLS Source | MLSListings, Inc. |
| Days on Site | 2 |
| Feature | Details |
|---|---|
| Bathrooms | Double Sinks, Primary - Stall Shower(s), Shower and Tub |
| Kitchen | Countertop - Tile |
| Appliances | Dishwasher, Garbage Disposal, Microwave, Oven Range - Gas, Washer/Dryer |
| Dining Room | Breakfast Bar, Formal Dining Room |
| Family Room | No Family Room |
| Fireplace | Living Room |
| Flooring | Carpet |
| Cooling | None |
| Heating | Central Forced Air - Gas |
| Feature | Details |
|---|---|
| Roof | Composition |
| Foundation | Slab |
| Pool | Community Facility, In Ground |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Guest / Visitor Parking, Garage: 2 Car(s) |
| Elementary District | San Mateo-Foster City Elementary |
| High School District | San Mateo Union High |
| Sewer | Public Sewer |
| Water | Public |
| HOA Fee | $750 |
| HOA Fee Frequency | Monthly |
| Complex Amenities | Beach Rights, Club House, Community Pool |
| Zoning | RT00PD |
Andy Gan
Intero Real Estate Services
License #: 01868784
Phone: (650) 922-3168
School data provided by GreatSchools.org
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 123 Positano Cir 406 | $1,275,000 | 2 | 2 | 1,125 | Active |
| 412 Fathom Dr | $1,270,000 | 2 | 2 | 1,040 | Active |
| 31 E Court Ln | $1,138,800 | 2 | 2/1 | 1,530 | Active |
| 815 Rigel Ln | $1,248,000 | 2 | 1/1 | 1,320 | Active |
©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 May 01, 2026. For the most current information, please contact Andy Gan, (650) 922-3168.