---
listing_id: ML81925737
status: Closed
price: 2210000
beds: 3
baths_full: 2
baths_half: 0
sqft_living: 1790
sqft_lot: 7056
lot_acres: 
year_built: 1966
property_type: Residential
property_subtype: Single Family Residence
address: "974 Flying Fish St"
city: Foster City
state: CA
zip: 94404
county: "San Mateo County"
lat: 37.564053
lng: -122.256485
days_on_market: 1095
hoa_fee: 
hoa_frequency: 
garage_spaces: 2
list_agent: "Alex H. Wang"
list_office: "Rainmaker Real Estate"
list_agent_phone: "(650) 800-8840"
list_agent_license: 01351503
mls_source: MLSL
modified: 2026-02-01
transaction_type: recentlySold
---

Home | San Mateo County | Foster City | 94404 | 974 Flying Fish St

974 Flying Fish St, Foster City, CA 94404

MLS: ML81925737 | Status: Sold | Price: $2,210,000
Beds/Baths: 3 / 2
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
3 2 1,790 7,056 1966

Remarks

Experience waterfront living at its finest in this peaceful Foster City home. Recently renovated, this stunning oasis boasts fresh paint, gleaming hardwood floors, sparkling granite countertops, and environmentally-friendly solar panels. The natural light and breathtaking views will leave you mesmerized. Entertain guests in the spacious living room, waterfront deck, or cozy family room. Unwind in style in the outdoor hot tub or take your watercraft out from your own backyard. Enjoy a peaceful walk or bike ride on the nearby Bay Trail, just half a mile away. Commuting is a breeze with quick access to highways 92 and 101, and a bike ride away from Visa and Gilead. This home is located in one of Foster City's most desirable neighborhoods, offering a peaceful and serene island lifestyle. Whether you're looking to throw the ultimate bash or create unforgettable memories, this property has everything you need. Come indulge in paradise and experience waterfront living at its finest.

MLS Listing Information

Field Value
MLS # ML81925737
MLS Source MLSListings, Inc.

Features

Interior Features

Feature Details
Bedrooms Primary Suite/Retreat, Primary Bedroom on Ground Floor, More than One Bedroom on Ground Floor
Bathrooms Dual Flush Toilet, Showers over Tubs - 2+, Tile, Full on Ground Floor
Kitchen Exhaust Fan
Appliances Cooktop - Electric, Dishwasher, Exhaust Fan, Garbage Disposal, Oven - Built-In, Oven - Double, Refrigerator
Dining Room Breakfast Bar, Dining Area in Living Room
Family Room Kitchen/Family Room Combo
Fireplace Gas Burning, Living Room
Flooring Hardwood, Tile
Laundry Hookup - Gas Dryer, In Garage
Cooling Central Forced Air
Heating Central Forced Air - Gas

Exterior Features

Feature Details
Roof Composition
Foundation Concrete Perimeter
Pool Spa/Hot Tub

Parking, School, and Other Information

Feature Details
Garage/Parking Attached Garage, Boat Dock, Off-Street Parking, On Street, Garage: 2 Car(s)
Elementary District San Mateo-Foster City Elementary
High School District San Mateo Union High
Sewer Public Sewer
Water Public
Zoning R10006

Contact Information

Alex H. Wang
Rainmaker Real Estate
License #: 01351503
Phone: (650) 800-8840

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Audubon Elementary School public K-5 0.25 mi 7
Brewer Island Elementary School public K-5 0.32 mi 9
Bowditch Middle School public 6-8 0.51 mi 9
San Mateo-Foster City Special Education Preschool public UG 0.95 mi N/A
Beach Park Elementary public K-5 1.06 mi 8
Foster City Elementary School public K-5 1.54 mi 9
Redwood Shores Elementary School public K-5 1.55 mi 9
Bayside Academy public K-8 2.12 mi 6
Sandpiper Elementary School public K-8 2.15 mi 9
Parkside Montessori public PK,KG,1,2,3,4,5,6,7,8 2.20 mi 9
LEAD Elementary public K-5 2.47 mi 2
College Park Elementary School public K-5 2.51 mi 9
Fiesta Gardens International Elementary School public K-5 2.52 mi 4
George Hall Elementary School public K-5 2.65 mi 9
San Mateo County Special Education School public K-12 2.66 mi N/A
San Mateo County Rop School public 11-12 2.66 mi N/A
Nesbit Elementary School public K-8 2.87 mi 6
Sunnybrae Elementary School public K-5 3.10 mi 2
Central Elementary School public K-5 3.12 mi 9
Beresford Elementary School public K-5 3.36 mi 4

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 February 01, 2026. For the most current information, please contact Alex H. Wang, (650) 800-8840.