200 Turnstone Court

Foster City, CA 94404

$3,000,000
Last Sold Price
5
Beds
4
Baths
3,980 Sq. Ft.
$754 / Sq. Ft.
3,980
Sq. Ft.
$754
per Sq. Ft.

Description

Introducing a truly unique gem in the heart of Foster City! This exceptional property stands out as one of the largest homes in the neighborhood. Boasting a vast lot, the potential for customization is endless. With a little love and attention, this cosmetic fixer-upper can be transformed into your dream home. Its prime location offers the best of both worlds: peaceful suburban living and convenient urban access. Best of all, you'll be within walking distance to top-rated schools and just a short...Introducing a truly unique gem in the heart of Foster City! This exceptional property stands out as one of the largest homes in the neighborhood. Boasting a vast lot, the potential for customization is endless. With a little love and attention, this cosmetic fixer-upper can be transformed into your dream home. Its prime location offers the best of both worlds: peaceful suburban living and convenient urban access. Best of all, you'll be within walking distance to top-rated schools and just a short drive away from commute routes! Enjoy a bright and airy atmosphere in this spacious 5-bed, 4-bath house that also features ample space for living and entertaining. The generously sized backyard provides a blank canvas for all your outdoor living needs. Whether you're looking to create a relaxing oasis or an entertainment hotspot, the possibilities are endless. Don't miss out on this once-in-a-lifetime opportunity to own a home in one of Foster City's most sought-after locations!

Listing Agents

  1. Daniel Rougeau

    Daniel Rougeau

    Listing Agent

    Compass

    DRE #02134738

  2. Jennifer Oldham

    Jennifer Oldham

    Alternative Listing Agent

    Compass

    DRE #01325650

    jennifer@compass.com

    P: 408.835.4119

Property Details for 200 Turnstone Court

MLS City Name
FOSTER CITY
Building Type
Detached
Garage Spaces
2
Parking Spaces
4
Cross Street
Gull Avenue

Location

Listing Courtesy of Compass, Daniel Rougeau, DRE #02134738; Compass, Jennifer Oldham, DRE #01325650

Sold By Compass, Daniel Rougeau, DRE #02134738; Compass, Jennifer Oldham, DRE #01325650

Add your commute
LISTING UPDATED: 02/29/2024 03:39 PM

Property Details for 200 Turnstone Court

StatusSold
MLS #ML81927252
Days on Compass133
Taxes-
HOA Fees-
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeSingle-Family Homes / Detached
Year Built1966
Lot Size0.19 AC / 8,110 SF
CountySan Mateo County

Location

Listing Courtesy of Compass, Daniel Rougeau, DRE #02134738; Compass, Jennifer Oldham, DRE #01325650

Sold By Compass, Daniel Rougeau, DRE #02134738; Compass, Jennifer Oldham, DRE #01325650

Add your commute

Building Information for 200 Turnstone Court

Stories2Year Built1966Building Size-Lot Size0.19 AC / 8,110 SF

Payment Calculator

$18,094 per month

30 year fixed, 7.25% Interest

Principal and Interest

$16,372

Property Taxes

$1,722

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Property Information for 200 Turnstone Court

Features
External Links
Room Information
  • Additional Rooms: Bonus / Hobby Room, Den / Study / Office
  • Bathroom: Double Sinks, Stall Shower, Tile, Tub
  • Bedrooms: Primary Suite / Retreat, Walk-in Closet
  • Dining Room: Breakfast Nook, Dining Area
  • Family Room: Separate Family Room
  • Kitchen: Cooktop - Gas, Dishwasher, Exhaust Fan, Hood Over Range, Island, Oven - Built-In, Refrigerator, Wine Refrigerator
  • Number of Full Bathrooms: 4
Features
  • Amenities: High Ceiling, Open Beam Ceiling, Skylight, Vaulted Ceiling, Walk-in Closet
  • Energy Features: Double Pane Windows, Skylight, Thermostat Controller
  • Fireplace: Yes
  • Fireplaces: Family Room
  • Fireplaces Min: 1
  • Flooring: Tile, Wood
  • Laundry: Dryer, Inside, Washer
  • Living SqFt: 3980
  • Pool: No
Utilities
  • Cooling: Central AC
  • Heating: Central Forced Air
  • Sewer Septic: Sewer - Public
  • Utilities: Public Utilities, Solar Panels - Owned
  • Water: Public
Garage
  • Garage and Parking: Attached Garage, Gate / Door Opener, Parking Area
  • Garage Max: 2
  • Garage Min: 2
Property Details
Homeowners Association
  • HOA Exists: 0
  • HOA Fee: $0
Property Details
  • Exterior: Dual Pane Windows
  • Area Text: FC- Nbrhood#2 - Bay Vista
  • Roof: Tar and Gravel
  • Stories: Two Story
  • Subclass: Single Family Home
  • Year Built Source: Assessor
  • Street Number: 200
  • Street Name: Turnstone
  • Street Suffix: Court
  • Area ID: 397
Lot / Property Details
Building Information
  • Number Of Stories: 2
  • Structure SqFt: 3980
  • Structure SqFt Source: Assessor
  • Age: 57
Development Information
  • Zoning Detail: R10006
Location Information
  • Parcel Number: 094-212-690
  • County Name: San Mateo
  • City Name: FOSTER CITY
  • City Postal ID: 20
  • Postal Code: 94404
  • Elementary School District: 938
  • High School District Text: San Mateo Union High
Lot Information
  • Fencing: Fenced, Wood
  • Foundation: Concrete Slab
  • Horse Property: No
  • Lot Acres: .19
  • Lot Size Area Maximum Units: Square Feet
  • Lot Size Area Minimum Units: Square Feet
  • Lot Size Source: Assessor
  • Yard Grounds: Back Yard, Balcony / Patio, Fenced

Property History for 200 Turnstone Court

DateEvent & SourcePriceAppreciation
DateEvent & SourcePrice

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 200 Turnstone Court

Taxable ValueLand$829,324Additions$922,369Total$1,751,693
Tax Record2023$20,659 ($1,722 / month)
Home Facts
Beds5Total Finished SqFt3,980 SqFtAbove Grade Finished SqFt3,980 SqFtStories2Lot Size8,110 SqFtStyleSingle Family ResidenceYear Built1966ZoningR10006CountySAN MATEOAPN094-212-690

Schools near 200 Turnstone Court

This home is within San Mateo Union High School District.
Rating
School
Type
Grades
Distance
Public - K to 5
Public - 6 to 8
Public - 9 to 12
Public - K to 5
Rating
School
Distance
Audubon Elementary School
PublicK to 5

Bowditch Middle School
Public6 to 8

San Mateo High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Sorry, we can't find any similar homes at this time. Please check back later.

Similar Sold Homes

Sorry, we can't find any similar sold homes at this time. Please check back later.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Compass, Daniel Rougeau, DRE #02134738; Compass, Jennifer Oldham, DRE #01325650

Based on information from one of the following Multiple Listing Services: San Francisco Association of Realtors, the MLSListings MLS, the BAREIS MLS, the EBRD MLS, Shasta Association of REALTORS® Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by San Francisco Association of Realtors, the MLSListings MLS, the BAREIS MLS, the EBRD MLS, Shasta Association of REALTORS® is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.