The original life estate condition for the de Guigne family HAS BEEN REMOVED on this property ~ Rare & unique opportunity to buy one of the largest parcels of land on the San Francisco Peninsula ~ Approx. 47.4 acres midway between Silicon Valley & San Francisco, just 8 miles to SFO airport & private jet center ~ Over 100 year old mansion with Bay views, pool, hiking trails, canyons & reservoir ~ Ballroom, banquet dining, professional kitchen ~ Detached 3-car garage, 8-car carport, and tremendous motor court parking ~ Truly a landmark property with potential to subdivide.
|LAST UPDATED||6/16/2017||YEAR BUILT||1916|
|COMMUNITY||Parrott Drive Area||COUNTY||San Mateo|
|STATUS||Sold||PROPERTY TYPE(S)||Single Family|
|School District||San Mateo Union High|
|Elementary School||South Hillsborough|
|Jr. High School||Crocker Middle|
|High School||Aragon High|
|AREA||Parrott Drive Area|
|BASEMENT||Foundation: Concrete Slab, Other|
|EXTERIOR||Back Yard, Balcony / Patio, Courtyard, Dog Run / Kennel, Drought Tolerant Plants|
|GARAGE||Covered Parking, Detached, Electric Gate, Gate / Door|
|INTERIOR||Hardwood, High Ceiling , Marble, Other, Security Gate, Travertine, Vinyl / Linoleum, Walk-in Closet , Wet Bar; Floors: Carpet|
|LOT DESCRIPTION||Possible Lot Split, Private / Secluded, Stream - Seasonal, Views|
|POOL DESCRIPTION||Cabana / Dressing Room,Pool - In Ground|
|SEWER||Sewer: Sewer - Public|
|UTILITIES||Water: Public,Reservoir,Storage Tank,Other; Sewer:|
|VIEW DESCRIPTION||Bay,Bridge ,Canyon,City,City Lights,Forest / Woods,Hills,Mountains,Panoramic,Par|
|WATER||Water: Public,Reservoir,Storage Tank,Other|
The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of the MLSListings™ MLS system. All real estate listings in the MLSListings MLS system are marked with the MLSListings Internet Data Exchange icon (a stylized house inside a circle), and detailed information about them includes the names of the listing brokers and listing agents.
Based on information from MLSListings MLS as of 1/21/18 5:01 AM PST. 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.
Copyright 2018 MLSListings Inc. All rights reserved.
This IDX solution is (c) Diverse Solutions 2018.