---
listing_id: BA326036953
status: Active
price: 4250000
beds: 4
baths_full: 4
baths_half: 0
sqft_living: 4310
sqft_lot: 351529
lot_acres: 8.07
year_built: 1993
property_type: Residential
property_subtype: Single Family Residence
address: "740 Shiloh Ter"
city: Santa Rosa
state: CA
zip: 95403
county: "Sonoma County"
lat: 38.543092
lng: -122.7405728
days_on_market: 14
hoa_fee: 3240
hoa_frequency: Annually
garage_spaces: 6
list_agent: "Grace Lucero"
list_office: "Vanguard Properties"
list_agent_phone: "–"
list_agent_license: 01233007
mls_source: REBAREIS
modified: 2026-05-12
transaction_type: buy
---

Home | Sonoma County | Santa Rosa | 95403 | 740 Shiloh Ter

740 Shiloh Ter, Santa Rosa, CA 95403

MLS: BA326036953 | Status: Active | Price: $4,250,000
Beds/Baths: 4 / 4
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Acres Lot Yr Built
4 4 4,310 8.07 1993

Remarks

Perched above the valley on eight private acres within the gated Shiloh Ridge community, this remodeled Mediterranean villa is defined by the extraordinary views that greet you at every turn. Rolling hills, vineyards, and open sky stretch out in every direction, visible from the main living areas, the rooftop balcony, and the grounds below. The 4,310 sq ft residence was extensively renovated throughout, with arched doorways, French oak floors, stone finishes, and cathedral ceilings that speak to the character of the architecture. The main floor hosts the primary suite with a private walk-out patio to a hot tub overlooking the valley, a study and library, gourmet kitchen, family room, formal dining room, breakfast room, and solarium. Three guest suites upstairs each have ensuite baths and open directly to the rooftop balcony with views that are nothing short of remarkable. The spacious great room extends onto terraced decks ideal for entertaining. Outside, a European-style courtyard, gunite lap pool, jacuzzi grotto, multiple verandas, greenhouse, heritage oaks, and orchards complete the grounds. Fiber optic service and a new generator are in place. Adjacent to Mayacama Golf Club, minutes to Healdsburg and Santa Rosa Airport, and approximately an hour from San Francisco.

MLS Listing Information

Field Value
MLS # BA326036953
MLS Source Bay Area Real Estate Information Services, Inc.
Days on Site 14

Features

Interior Features

Feature Details
Bathrooms Primary - Tub, Updated Bath(s)
Kitchen Updated
Appliances Dishwasher, Garbage Disposal, Hood Over Range, Microwave, Oven Range - Built-In, Oven Range - Electric, Refrigerator
Fireplace Family Room, Gas Log
Flooring Wood
Laundry 220 Volt Outlet, Hookups Only, In Laundry Room
Cooling Central Forced Air
Heating Central Forced Air

Exterior Features

Feature Details
Roof Barrel / Truss
Foundation Concrete Perimeter
Pool Cover, Heated - Gas, In Ground, Pool - Yes, Pool/Spa Combo, Spa/Hot Tub
Style Luxury, Mediterranean

Parking, School, and Other Information

Feature Details
Garage/Parking Attached Garage, Covered Parking, Guest / Visitor Parking, Garage: 6 Car(s)
Sewer Septic Tank
Water Public
HOA Fee $3240
HOA Fee Frequency Annually
Complex Amenities Other

Contact Information

Grace Lucero
Vanguard Properties
License #: 01233007
Phone: –

Property Units

# Buildings # Leased Units # Total Units
0

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Mattie Washburn Elementary School public KG,1,2 2.72 mi N/A
Mark West Elementary School public K-6 2.98 mi 5
Windsor Middle School public 6-8 3.70 mi 6
Sonoma County Special Education School public K-12 3.77 mi N/A
Sonoma County Alternative Education Programs School public K-12 3.77 mi 2
Sonoma County Rop School public 10-12 3.77 mi N/A
Brooks Elementary School public 3,4,5 4.00 mi 3
Windsor High School public 9-12 4.20 mi 8
Big Picture Learning Windsor public 6-12 4.27 mi N/A
Windsor Oaks Academy public 9-12 4.27 mi 3
Jack London Elementary School public K-6 4.52 mi 5

Nearby Homes

Address Price Beds Baths Sq Ft Status
777 Shiloh Cyn $4,250,000 5 5/2 7,000 Active

Disclosures

©2026 Bay Area Real Estate Information Services, Inc. All rights reserved. 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. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from Bay Area Real Estate Information Services, Inc.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of May 12, 2026. For the most current information, please contact Grace Lucero.