740 Shiloh Terrace

$4,250,000 4,310 SQ FT
$986 SQ/FT

740 Shiloh Terrace

@ Shiloh Ridge - Santa Rosa-Northeast, Santa Rosa

Map direct
  • 4 Bed
  • 4 Bath
  • 3 Park
  • 4,310 sqft
  • Santa Rosa
  • Payment calculator
DOM
2
SFR
  • Favorite
  • Hide
Message Anuschka Schneider

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.

Days on Market
2 days
Current Status
Active
Original Price
$4,250,000
List Price
$4,250,000
On Market Date
May 1, 2026
Property Type
Single Family Residence
Area
Santa Rosa-Northeast
Zip Code
95403
MLS ID
326036953
APN
079-140-029-000
Year Built
1993
Stories in Building
Unavailable
Possession
Close Of Escrow
Data Source
BAREIS
Origin MLS System
Bed
4
Bath
4
Double Sinks, Quartz, Tub
Parking
3
Attached, Covered, Guest Parking Available
SQ FT
4,310
SQ FT Source
Assessor Auto-Fill
Lot SQ FT
351,529.0
Lot Acres
8.07 Acres
Pool Info
Built-In, Gas Heat, Pool Cover, Pool/Spa Combo
Kitchen
Quartz Counter
Cooling
Central
Exterior Details
Balcony
Flooring
Wood
Foundation
Concrete Perimeter
Fire Place
Family Room, Gas Log
Heating
Central
Laundry
Hookups Only, Inside Room
Upper Level
Bedroom(s), Full Bath(s)
Main Level
Dining Room, Full Bath(s), Garage, Kitchen, Living Room, Primary Bedroom, Street Entrance
Views
Golf Course, Mountains, Panoramic
Possession
Close Of Escrow
Basement
Unfinished
Architectural Style
Mediterranean
* Fee
$3,240
Name
Shiloh Homeowner Association
Phone
(707) 285-0600
*Fee includes
Management and Road

MLS and other Information regarding properties for sale as shown in Theo have been obtained from various sources such as sellers, public records, agents and other third parties. This information may relate to the condition of the property, permitted or unpermitted uses, zoning, square footage, lot size/acreage or other matters affecting value or desirability. Unless otherwise indicated in writing, neither brokers, agents nor Theo have verified, or will verify, such information. If any such information is important to buyer in determining whether to buy, the price to pay or intended use of the property, buyer is urged to conduct their own investigation with qualified professionals, satisfy themselves with respect to that information, and to rely solely on the results of that investigation.

School data provided by GreatSchools. School service boundaries are intended to be used as reference only. To verify enrollment eligibility for a property, contact the school directly.

Listings © 2026 Bay Area Real Estate Information Services Inc

Copyright © 2026 Theo Inc. All Rights Reserved