---
listing_id: ML82027678
status: Active
price: 2498000
beds: 4
baths_full: 2
baths_half: 1
sqft_living: 2380
sqft_lot: 7795
lot_acres: 
year_built: 1965
property_type: Residential
property_subtype: Single Family Residence
address: "142 Shooting Star Isle"
city: Foster City
state: CA
zip: 94404
county: "San Mateo County"
lat: 37.558618
lng: -122.257151
days_on_market: 0
hoa_fee: 
hoa_frequency: 
garage_spaces: 1
list_agent: "Jingya Ji"
list_office: "Coldwell Banker Realty"
list_agent_phone: "(650) 492-0701"
list_agent_license: 02050112
mls_source: MLSL
modified: 2026-04-01
transaction_type: buy
---

Home | San Mateo County | Foster City | 94404 | 142 Shooting Star Isle

142 Shooting Star Isle, Foster City, CA 94404

MLS: ML82027678 | Status: Active | Price: $2,498,000
Beds/Baths: 4 / 2 /1
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
4 2 /1 2,380 7,795 1965

Upcoming Open Houses

Date Time Hosted By
Saturday, April 4 1:30 pm - 4:30 pm Jesus
Sunday, April 5 1:30 pm - 4:30 pm Jesus

Remarks

This stunning waterfront home in desirable Foster City offers a spacious single-level floor plan filled with natural light and expansive windows framing serene lagoon views. French doors connect the living space to a beautifully updated backyard and patio, creating seamless indoor-outdoor living. The open-concept living, family, and dining areas flow into a remodeled chef's kitchen featuring high-end appliances, freshly painted cabinetry, and an oversized quartz island. The interior has been freshly painted and enhanced with new light fixtures for a modern touch. All bathrooms have been remodeled with stylish finishes. Hardwood flooring runs through all four bedrooms, including a generous primary suite with water views, walk-in closet, and direct access to the refreshed deck. Exterior upgrades include a newly painted front door and deck. The backyard features a modern paver patio, mature landscaping, and a unique cactus garden, offering a peaceful waterfront retreat. Ideally located near parks, top-rated schools, and scenic trails, this home captures the essence of Foster City living.

MLS Listing Information

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

Features

Interior Features

Feature Details
Appliances Cooktop - Gas, Dishwasher, Garbage Disposal, Oven - Built-In
Dining Room Formal Dining Room
Family Room Separate Family Room
Fireplace Gas Burning
Cooling None
Heating Central Forced Air - Gas

Exterior Features

Feature Details
Roof Composition
Foundation Concrete Perimeter and Slab

Parking, School, and Other Information

Feature Details
Garage/Parking Attached Garage, Carport, Garage: 1 Car(s)
Elementary District San Mateo-Foster City Elementary
High School District San Mateo Union High
Water Public
Zoning R10006

Contact Information

Listing Agent Co-Listing Agent
Jingya Ji Miranda Caley
Coldwell Banker Realty Coldwell Banker Realty
License #: 02050112 License #: 01949968
Phone: (650) 492-0701 Phone: (650) 308-6161

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Brewer Island Elementary School public K-5 0.32 mi 8
Bowditch Middle School public 6-8 0.46 mi 8
Audubon Elementary School public K-5 0.61 mi 7
Beach Park Elementary public K-5 0.71 mi 7
San Mateo-Foster City Special Education Preschool public UG 1.04 mi N/A
Redwood Shores Elementary School public K-5 1.23 mi 8
Foster City Elementary School public K-5 1.24 mi 8
Sandpiper Elementary School public K-8 1.86 mi 8
Bayside Academy public K-8 2.14 mi 6
Parkside Montessori public PK,KG,1,2,3,4,5,6,7,8 2.16 mi 9
San Mateo County Special Education School public K-12 2.28 mi N/A
San Mateo County Rop School public 11-12 2.28 mi N/A
Fiesta Gardens International Elementary School public K-5 2.35 mi 3
College Park Elementary School public K-5 2.37 mi 8
George Hall Elementary School public K-5 2.38 mi 8
Nesbit Elementary School public K-8 2.51 mi 6
LEAD Elementary public K-5 2.52 mi 2
Central Elementary School public K-5 2.77 mi 9
Sunnybrae Elementary School public K-5 3.07 mi 1
Beresford Elementary School public K-5 3.16 mi 4

Nearby Homes

Address Price Beds Baths Sq Ft Status
1959 Playa St $2,099,000 3 2 2,050 PendingDoNotShow
367 Montserrat Dr $2,688,000 4 2/1 2,150 Active
224 Loon Ct $2,488,888 4 2 1,871 Active
703 Lacewing Ln $2,688,888 4 2/1 2,590 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 April 01, 2026. For the most current information, please contact Jingya Ji, (650) 492-0701.