704 Shiloh Ter, Santa Rosa, CA 95403
FOR SALE
3D VIEW
11.42 ACRES

704 Shiloh Ter
Santa Rosa, CA 95403

  • 4 Beds
  • 6 Baths
  • 7,644 sqft (on 11.42 acres)
  • 4 Beds
  • 6 Baths
  • 7,644 sqft (on 11.42 acres)

$6,950,000

Original price: $7,495,000
Est. Mortgage $44,057/mo*

Local Information

map showing home location
© Google
-- mins to
Commute Destination

Description

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.

Home Highlights

Parking
Garage
Outdoor
Pool
A/C
Heating & Cooling
HOA
$334/Monthly
Price/Sqft
$909
Listed
171 days ago

Home Details for 704 Shiloh Ter

Interior Features

Interior Details
Number of Rooms: 6Types of Rooms: Bedroom, Bathroom, Dining Room, Family Room, Kitchen, Living Room
Beds & Baths
Number of Bedrooms: 4Number of Bathrooms: 6Number of Bathrooms (full): 4Number of Bathrooms (half): 2
Dimensions and Layout
Living Area: 7644 Square Feet
Appliances & Utilities
Utilities: Electricity Connected, Internet AvailableLaundry: Inside Room
Heating & Cooling
Heating: Central,Fireplace(s),Radiant FloorHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Central
Fireplace & Spa
Number of Fireplaces: 3Fireplace: Family Room, Gas Log, Living Room, Master BedroomHas a Fireplace
Gas & Electric
Gas: Propane Tank LeasedHas Electric on Property
Levels, Entrance, & Accessibility
Stories: 2
View
Has a ViewView: City, Mountain(s), Valley

Exterior Features

Exterior Home Features
Has a Private Pool
Parking & Garage
Number of Garage Spaces: 4Number of Covered Spaces: 4No CarportHas a GarageNo Attached GarageHas Open ParkingParking Spaces: 20Parking: Enclosed,Garage Door Opener,Guest,Inside Entrance,Paved Driveway,Shared Driveway
Pool
Pool: Pool Cover, Pool Sweep, Pool/Spa Combo, Solar HeatPool
Water & Sewer
Sewer: Septic Tank

Days on Market

Days on Market: 171

Property Information

Year Built
Year Built: 2010
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family Residence
Building
Attached To Another Structure
Property Information
Parcel Number: 079140023000

Price & Status

Price
List Price: $6,950,000Price Per Sqft: $909
Status Change & Dates
Possession Timing: Close Of Escrow, Negotiable

Active Status

MLS Status: Active

Location

Direction & Address
City: Santa Rosa

Agent Information

Listing Agent
Listing ID: 323920854

Building

Building Area
Building Area: 7644 Square Feet

Community

Community Features: Gated

HOA

HOA Fee Includes: Common Areas, Management, RoadHOA Name: Silver Creek Association ManagementHOA Phone: 916-877-7793HOA Fee: $1,003/Quarterly

Lot Information

Lot Area: 11.42 Acres

Documents

Disclaimer: Information has not been verified, is not guaranteed, and is subject to change. Any offer of compensation is made exclusively to Broker Participants of the MLS where the subject listing is filed.<BR> Copyright &copy; 2024 Bay Area Real Estate Information Services, Inc. All rights reserved.<BR>Copyright</A> &copy;2024 <A name="trans">Rapattoni Corporation. All rights reserved.</A><BR>U.S. Patent 6, 910, 045

Listing Info

Special Conditions: Offer As Is

Mobile R/V

Mobile Home Park
Mobile Home Units: Feet

Compensation

Buyer Agency Commission: 2.5Buyer Agency Commission Type: %
Notes
The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed

Miscellaneous

Mls Number: 323920854Listing Url

Additional Information

HOA Amenities: Greenbelt,Trail(s),Other
Last check for updates: about 13 hours ago
Listing courtesy of Marshall Mello DRE #01815138, (707) 396-2686
Sterling California Properties, (707) 523-4300
Michelle J Williams DRE #02063158, (707) 387-7904
Sterling California Properties, (707) 523-4300
Source: BAREIS, MLS#323920854

Price History for 704 Shiloh Ter

DatePriceEventSource
01/25/2024$6,950,000PriceChange
BAREIS #323920854
11/09/2023$7,495,000Listed For SaleBAREIS #323920854
09/04/2015$3,500,000Sold
N/A
06/13/2015$3,750,000PriceChange
Agent Provided
05/23/2015$3,795,000PriceChange
Agent Provided
12/27/2014$3,885,000PriceChange
Agent Provided
11/23/2014$3,775,000PriceChange
Agent Provided
10/31/2014$3,885,000PriceChange
Agent Provided
06/27/2014$3,775,000Listed For SaleAgent Provided
05/17/2014$3,775,000ListingRemovedAgent Provided
12/20/2013$3,775,000Listed For SaleAgent Provided
11/02/2013$3,775,000ListingRemovedAgent Provided
07/12/2013$3,775,000Listed For SaleAgent Provided
07/11/2012$3,450,000Sold
N/A
06/07/2012$3,700,000Listed For SaleAgent Provided
05/02/2012$3,800,000ListingRemovedAgent Provided
05/18/2011$3,800,000Listed For SaleAgent Provided
08/29/2007$1,150,000Sold
N/A
04/16/2003$1,100,000Sold
N/A
05/15/1997$235,000Sold
N/A

Similar Homes You May Like

New Listings near 704 Shiloh Ter

Property Taxes and Assessment

Year2023
Tax$47,286
Assessment$4,118,557
Home facts updated by county records

Comparable Sales for 704 Shiloh Ter

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
0.49
Single-Family Home
$6,900,000
07/24/23
5
7
5,132
0.77
Single-Family Home
$4,800,000
05/22/23
4
5
4,436
1.37
Single-Family Home
$1,315,000
01/02/24
4
3
3,900
2.33
Single-Family Home
$2,600,000
05/15/23
4
5
5,000
1.93
Single-Family Home
$1,950,000
03/14/24
4
5
4,092
2.18
Single-Family Home
$8,250,000
04/19/24
3
4
4,537
1.95
Single-Family Home
$1,750,000
04/02/24
4
4
3,808
1.89
Single-Family Home
$1,910,000
08/28/23
4
4
3,094
2.00
Single-Family Home
$1,650,000
05/01/23
3
2
1,600

What Locals Say about Santa Rosa

  • Ymkje Dioquino
    "We haven’t lived here long enough to know, but we’ve attended several fun events in the area! We especially the Sofa winterblast event:)"
    5
    Flag
  • Rrph9cpb5d
    "We enjoy weekly community prayer for our city at the town square, festivals, farmers markets, wineries and theatrical events. Many churches host weekly activities for highschoolers and junior highers."
    0
    Flag
  • Patti
    "There are endless miles of trails for hiking, biking and running/ walking. Dogs are friendlier then the people."
    0
    Flag
  • Abbie Gubera
    "General awareness and kindness in our neighborhood. We have an island a family on our street has "adopted" to take care of which makes it like we have a private park"
    0
    Flag
  • Peri Lyn Olsson
    "Dog poop is not always picked up and occasionally there are aggressive dogs. …………………………………………………………………"
    1
    Flag
  • Isabelle Garson
    "Work from home. When I commuted it was best to avoid rush hour and leave at 10 instead of 9 and 6 instead of 5."
    0
    Flag
  • Trulia User
    "The neighborhood is great, but the number of young families is diminishing. Cost of housing is too high for most young families. This is not good for sustaining good elementary schools and child-friendly spaces. Hope things turn around quickly or this area will be a 55+ community soon."
    3
    Flag
  • Abbie Gubera
    "all the nearby state parks, open space, amenities, grocery stores (gourmet) and the beauty of it with all the trees and vineyards"
    1
    Flag
  • Trulia User
    "Our area is nice, pretty clean and good schools. We had fires 5 years ago, the likelihood of it happening here again is pretty slim. Excellent grocery store, an a few restaurants and good stores. We have lived here for about 7 years. We have no desire to move. Also it easy access to freeway and shopping centers. And hospital and medical clinics. Farmers markets every Wednesday and Saturday. Excellent area for families and friends. 100 words are hard to come up with."
    0
    Flag
  • Trulia User
    "None it’s quiet nothing goes on around here except the basic living. That’s why I like this area simple Clean and everyone is respectful quiet and friendly "
    0
    Flag
  • Trulia User
    "I’ve lived in this area 6 years. People are friendly and courteous hen you see them. A good portion of the neighbors are good about keeping their places up and seems to be tidy. Several good stores and restaurants locally. "
    1
    Flag
  • Trulia User
    "I have a very short commute, I drive to work earlier than most of the traffic, and I drive my own vehicle "
    0
    Flag
  • Trulia User
    "we are right next to the fairgrounds. we can see fireworks, hear music and be first in line for events."
    4
    Flag
  • Trulia User
    "The Saturday and Wednesday farmers markets are wonderful. Just a few miles to Russian river resort area. The local airport is minutes away. Molesberry’s market, local pub and several restaurants. I love it. "
    0
    Flag
  • Caroline C.
    "I love it. Easily one of the best things about living in Sonoma County, my 4 mile "commute" from Santa Rosa to where I work in Rohnert Park, CA takes about 12 minutes. "
    0
    Flag
  • Caroline C.
    "Welcome to Casa Del Sol! We are a pet-friendly, family-based community where everyone, including dogs, enjoy taking a walk in beautiful Casa Del Sol. Our neighbors who own dogs help to protect it's beauty by leashing their pets and cleaning up after them. I can't think of one thing to not like!"
    0
    Flag
  • Stephen P.
    "The neighborhood is call and overall pretty peaceful which is a delight with it basically being right down town. Living this close to the fire station, evacuations center, and the police station also is great when it comes to power outages. We never get shut off."
    36
    Flag
  • Cindy A
    "Santa Rosa can be a good place for families depending on the area. Smoke and fire season has made it a bit less nice ."
    0
    Flag
  • Devon
    "Lots of paths for walking and neighbors look out for each other so if dog gets out someone always brings them home because they know where dog lives!"
    0
    Flag
  • Bennerbrady
    "Super easy! Traffic is never terrible and streets are super well designed! There is a very minimal area that gets stop and go traffic on the 101 during rush hours and carpool is always empty! "
    0
    Flag
  • Claireodie
    "Nice place to walk dogs as there are creek trails and dog parks. River beaches are few but a small drive. Beach is about 1/2 hour away."
    0
    Flag
  • Scarltonrvms
    "this is a great place to walk dogs, there’s tons of trails around, backyard space for a dog to vibe out in, all around it’s pretty solid. "
    6
    Flag
  • Sierra S.
    "Yes, it’s a great place to raise a family. Perfect weather and close to many amenities such as the ocean, Red forest and wine country. "
    0
    Flag
  • Suzanne J.
    "Remote, private, yet close to town. It’s clean, quiet, safe. I have nothing else to say, thus I’ll try to put the 100 characters here."
    0
    Flag
  • Kat R
    "I’ve lived in this neighborhood for 6 years and feel at home. It is easy to meet people and make friends. Also, close to regional parks ."
    0
    Flag
  • Melissa M.
    "Lived here 4 years. Nice established neighborhood mainly older population nice streets older well kept home. "
    0
    Flag
  • Ryan H.
    "The trails are a nice way to get off the sidewalk and get a quick shot of nature. The dog park is another option. But no matter what, there is a lot of safe and comfortable streets for dog walkers. "
    13
    Flag
  • Michael Y.
    "There a people walking or jogging with there dogs everywhere. It's a safe community with lots of dog lovers."
    6
    Flag
  • Grkalmar
    "I’ve lived here for three years. It’s not perfect, there is still a little bit of crime but it’s not that bad. I think it’s a great area for families."
    8
    Flag
  • Trulia User
    "There is too many homeless around Santa Rosa as of recent. We don't have the funding for everyone here as it is. "
    0
    Flag
  • Tinamgutierrez03
    "Quick access to the freeway every thing within walking distance many stores and restaurants in the area very close to hospital police station fire department "
    3
    Flag
  • Stacetomassini
    "i love the neiborhood it's family friendly pet friendly close friends family all in one beautiful place"
    0
    Flag
  • Dayana M. G.
    "there are many families in the neighborhood and there are many parks and its safe to walk aroundhebwjxhe"
    0
    Flag
  • Charvindavis1976
    "There are stores very close to me. The freeway is around the corner as well. So, when I get off work and need to pick something up for dinner before I go home, it’s very easy to handle. "
    0
    Flag
  • Charvindavis1976
    "I live right next to the freeway. This makes my commute to and from work very easy. There’s gas stations and stores in every direction as well. "
    0
    Flag
  • Allyssa C.
    "My husband and I love living in Santa Rosa, it’s safe for me to run & I want to raise my family here"
    0
    Flag
  • Dcgdpt
    "Near parks, shopping, downtown, friendly and safe, great trick or treating area. Nice walkable streets"
    5
    Flag
  • Jasoncave
    "The commute to SF is easy with Golden Gate Transit. I take the 72X, it has free parking and drops me off in front of work in the City."
    0
    Flag
  • Journeyinternational
    "I stay in Mark West and unincorporated community outside of Santa Rosa. Really nice. It’s near the Russian River and south of Windsor. "
    0
    Flag
  • Actual-size1
    "Not a bad neighborhood. As one of the best school districts in the area. Will people want to move to this area for that reason. It’s far enough away from the big city life but close enough to get shopping done. lots of hiking trails and parks for active people to enjoy. "
    2
    Flag

LGBTQ Local Legal Protections

Marshall Mello, Sterling California Properties
Listing information deemed reliable but not guaranteed. Copyright 2024 Bay Area Real Estate Information Services, Inc. All Right Reserved.
An offer of compensation, if any, is made exclusively to Broker Participants of the MLS where the subject listing is filed and in accordance with such MLS’s regulations or rules.
704 Shiloh Ter, Santa Rosa, CA 95403 is a 4 bedroom, 6 bathroom, 7,644 sqft single-family home built in 2010. This property is currently available for sale and was listed by BAREIS on Nov 9, 2023. The MLS # for this home is MLS# 323920854.