174 Crestview Dr
Orinda, CA 94563
- 6 beds
- 8 baths
- 5,700 sqft
- ~1 acre lot
- $855 per sqft
- 2004 build
- – on site
More homes
Resort Living with Views! Perched atop a breathtaking 1.34-acre lot, this gated Mediterranean estate offers unparalleled privacy and panoramic vistas. Its timeless architecture showcases a classic tile roof, grand entry, and custom wood flooring. Arched windows frame picturesque views, while the versatile floor plan accommodates guest quarters, home offices, and seamlessly blends sophisticated entertaining with effortless daily living. The original owner has lovingly curated this enchanting residence for two decades. The relaxing spa and mesmerizing infinity pool create a tranquil oasis, seemingly merging with the horizon. A magnificent 1,000+/- square foot pool house, two guest suites, expansive tile patios, verdant lawns, bocce court, and vineyard complete this extraordinary retreat, elevating it to a truly rare and exceptional property.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Mar 11, 2025
•
MLS# 41082002 —
The Building
-
Year Built:2004
-
New Construction:No
-
Builder Name:Scott Cameron
-
Builder Model:Mediterranean Estate
-
Architectural Style:Mediterranean
-
Roof:Tile
-
Patio And Porch Features:Deck, Patio
-
Patio:1
Interior
-
Levels:Two
-
Kitchen Features:Stone Counters, Kitchen Island, Butler's Pantry
-
Eating Area:Breakfast Nook, In Kitchen
-
Flooring:Tile, Carpet, Wood
-
Room Type:Family Room
-
Fireplace:Yes
-
Fireplace:Gas, Living Room
-
Laundry:1
Room Dimensions
-
Living Area:5700.00
Location
-
Directions:Moraga Way>Valley View > Crestview Cross Street: Hilldale.
-
Latitude:37.85790046
-
Longitude:-122.16949050
The Property
-
Property Type:Residential
-
Subtype:Single Family Residence
-
Lot Features:Secluded, Back Yard, Garden, Yard, Sprinklers Timer
-
Lot Size Area:58800.0000
-
Lot Size Acres:1.3499
-
Lot Size SqFt:58800.00
-
Lot Size Source:Taped
-
Sprinklers:Yes
-
Other Structures:Guest House
Listing Agent
- Contact info:
- No listing contact info available
Beds
-
Total Bedrooms:6
Baths
-
Total Baths:8
-
Full & Three Quarter Baths:7
-
Full Baths:7
-
Half Baths:1
The Listing
-
Parcel Number:2721200034
Heating & Cooling
-
Heating:1
-
Heating:Forced Air
-
Cooling:Yes
-
Cooling:Central Air
Utilities
-
Sewer:Public Sewer
Appliances
-
Included:Yes
The Community
-
Subdivision:DEL REY
-
Subdivision:DEL REY
-
Association:No
-
Pool:In Ground
-
Private Pool:No
Parking
-
Parking:Yes
-
Parking:Garage, Off Street, Guest, Garage Door Opener
-
Parking Spaces:2.00
-
Attached Garage:Yes
-
Garage Spaces:2.00
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
| Date | Event | Source | Price | % Change |
|---|---|---|---|---|
|
1/27/25
Jan 27, 2025
|
BRIDGE | $4,750,000 | ||
|
1/9/25
Jan 9, 2025
|
Listed / Active | CRMLS_CA | $4,750,000 | |
|
10/24/24
Oct 24, 2024
|
Listed / Active | CRMLS_CA |
