x
Showing 1 of 0
X
Save

704 Shiloh Terrace
Santa Rosa CA 95403 US

$6,950,000

Active Listing ID 323920854
bed icon
4 bed
bath icon
6.00 Bath (4 Full Bath , 2 Half Bath)
lot icon
Lot: 11.42 Acres
home icon
Single Family Residence

$6,950,000

Active Listing ID 323920854
Save

704 Shiloh Terrace Stunning 11.42+/-ac estate in the Shiloh Estate hills, adjacent to the renowned Mayacama Golf Club. This rare offering lives like a sngl level home & is the pinnacle of tranquility in the Sonoma Wine Country. The home is filled w/natural light, has vaulted ceilings, multiple fireplaces, it features wood framed windows, walnut hardwood flooring, solid wood doors, radiant heated tile bath floors, stone countertops, has old world touches w/modern finishes, 1700 bottle wine cellar, an attached ADU w/interior access & private exterior access, built in speakers & intercom, fiber optic internet, remote controlled drapes in the family rm & primary bedrm, lrg 4 car garage, barbeque deck & ample stone covered patios to soak in the sun & year-round sunset views. This estate also boasts of expansive city views overlooking Santa Rosa, lush rolling hills & valleys below complementing its masterful design, infinity pool w/solar cover, fireplace surrounded by mature & lush landscaping w/newer lighting, ample parking including room for possible development, the main portion of the property is fully fenced, there is a security gate, passive solar for the pool, solar for the home, a generator, has fire safe landscaping and a fire resistant sealer has been applied on exterior wood treatments.

Collapse all

Property Features

  • Facts
  • Lot Size: 11.42 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 4
  • 1/2 Bathrooms: 2
  • Heating Fuels: Central Furnace, Fireplace, Radiant, Radiant Floor
  • Additional Features
  • Fireplace

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 6950000
  • unparsedaddress: 704 Shiloh Terrace
  • postalcity: Santa Rosa
  • stateorprovince: CA
  • country: US
  • postalcode: 95403
  • bathroomsfull: 4
  • bathroomshalf: 2
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 11.42
  • lotsizeunits: Acres
  • lotsizearea: 11.42
  • livingarea: 7644
  • livingareaunits: Square Feet
  • latitude: 38.544542
  • longitude: -122.744867
  • listagentfullname: Marshall Mello
  • listagentemail: MarshallMello@SterlingCAProperties.com
  • listagentkey: 3yd-BAREISCA-B339002
  • listagentmlsid: B339002
  • listagentpreferredphone: 7075234300
  • listagentofficephone: 7075234300
  • listofficekey: 3yd-BAREISCA-7B1014
  • listagentstatelicense: 01815138
  • listofficemlsid: 7B1014
  • disclaimer: Copyright © 2024 Bay Area Real Estate Information Services, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: BAREISCA
  • yearbuilt: 2010
  • listagenturl: https://sterlingcaproperties.com/marshall-mello/
  • countyorparish: Sonoma
  • parcelnumber: 079-140-023-000
  • heating: Central Furnace, Fireplace, Radiant, Radiant Floor
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 2
  • parkingtotal: 20
  • parkingfeatures: Garage, Guest
  • view: City, Mountain, Valley
  • waterfrontyn: False
  • architecturalstyle: Other
  • rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bathroom 5, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -122.744867, 38.544542
  • customfields: {"AlternatePrices":[], "Expenses":[], "Taxes":[], "ListPriceCurrencyType":"USD", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/704-Shiloh-Ter_Santa-Rosa_CA_95403_M22344-01458?f=listhub&s=BAREISCA&m=323920854&c=rexren", "LeadRoutingEmail":"MarshallMello@SterlingCAProperties.com", "BrokerName":"Sterling California Properties", "ListingTitle":"Single Family Residence - Santa Rosa, CA", "ListOfficeBrokerMlsId":"242875", "ListOfficeEmail":"MarshallMello@SterlingCaProperties.com", "ListOfficeAddress1":"4855 Old Redwood Hwy", "ListOfficeAddress2":null, "ListOfficeCity":"Santa Rosa", "ListOfficePostalCode":"95403", "ListOfficeStateOrProvince":"CA", "ListOfficeCountry":"US", "BuilderPhone":null, "BuilderFax":null, "BuilderEmail":null, "UnparsedAddress":null, "UnitNumber":null, "City":null, "StateOrProvince":null, "PostalCode":null, "Country":null, "ListBrokerageName":"Sterling California Properties", "ListBrokeragePhone":"(707) 396-2686", "ListBrokerageEmail":"marshallmello@sterlingcaproperties.com", "ListBrokerageWebsiteUrl":"https://www.sterlingcaproperties.com", "ListBrokerageLogoUrl":null, "ListBrokerageUnparsedAddress":"4855 Old Redwood Hwy", "ListBrokerageUnitNumber":null, "ListBrokerageCity":"Santa Rosa", "ListBrokerageStateOrProvince":"CA", "ListBrokeragePostalCode":"95403", "ListBrokerageCountry":"US", "RoomCount":0, "GeocodeOptions":null, "MLSModificationTimestamp":"2024-04-12T12:50:29Z", "Neighborhoods":[{"Name":"Santa Rosa-Northeast", "Description":null}]}
Listing Changed: 4/12/2024 9:32:20 PM GMT
Source Updated Date: 4/28/2024 6:53:11 AM GMT

Courtesy of: Marshall Mello, Sterling California Properties, MarshallMello@SterlingCAProperties.com

Copyright © 2024 Bay Area Real Estate Information Services, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

}