Cheyenne Celestine
Refine Search

310 Mainsail Court, Foster City, CA 94404

$1,998,000
SAVE TOUR THIS HOME
  • 310 Mainsail Court, Foster City, CA 94404 Main Photo

36 Total Photos [Click to View All]

Pending
BEDS4 BATHS2 full SQUARE FEET1,900 MLS#ML82053754
STATUSPending PROPERTY TYPEResidential - Single Family SCHOOLOther
TOUR THIS HOME

Listing Courtesy of: Compass
Agency Phone: (650) 375-1111
Associate Name: Bob Lahl
IDX logo


Listing Shown by: Farrell Smyth, Inc.
Associate Name: Cheyenne Celestine


Call / TEXT TO ME / Print / Share / Email

Property Description

Located in Foster City, this 4-bedroom, 2-bath home offers approximately 1,900 square feet of living space. The property a warm fireplace, including a wood-burning option, providing cozy warmth and ambiance. Heating is supplied by a central forced air gas system combined with a heat pump. There is no cooling system installed. The residence includes a two-car garage for parking and storage. This home is part of the San Mateo-Foster City Elementary school district.

310 Mainsail Court | MLS# ML82053754

This single family home located at 310 Mainsail Court, Foster City, CA 94404 is currently listed for sale with an asking price of $1,998,000. This property was built in 1967 and has 4 bedrooms and 2 full baths with 1900 sq. ft. Mainsail Court is located within the Other school district. Search Foster City real estate on ccelestine.farrellsmyth.com today.

Property Features

Property Type: Residential - Single Family
Cooling: None
Garage: 2 car attached
Heating: HeatPump
Lot Size: 0.14 Acres
Roof Type: Fiberglass
Stories: 1.0
Year Built: 1967

Feature Descriptions

Days on Site: 12
Parcel#: 094372090
Utilities: NaturalGasAvailable
Water: Public

Local Schools

School District: Other

Listed By / Shown By

Listed By

Agency Name: Compass
Agent Name: Bob Lahl
Agency Phone: (650) 375-1111

agent picture

Shown By

Agent Name: Cheyenne Celestine
Agent Phone: (805) 543-2636 ext. 16
Agency Title: Farrell Smyth, Inc.

IDX logo

Estimate Your Payment

Estimated Payment

$ 5,029.43 per month $4,446.68 Principal & Interest $0.00 Property Tax (data not provided by mls) $582.75 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)
Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 07/22/2026. The listing information on this page last changed on 07/22/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Wed 07/22/2026 12:00:05 AM EST) or CRMLS (last updated Tue 07/21/2026 11:50:28 PM EST). Real estate listings held by brokerage firms other than Farrell Smyth, Inc. may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility
Federal Housing Equal Opportunity Realtor
This site is hosted, designed and copyright © 1994 - 2026 by Delta Media Group, Inc. -- Patent Pending --
  

Login to My Homefinder

Forgot Password

Register

Pixel