Privately located on the 7th fairway at Del Rio country club. 6157 sq ft. Remarkable single story home designed by Joseph Esherick. Spacious open plan, floor to ceiling windows with sensational views. 2 master suites, 4 fireplaces, gourmet kitchen with seperate 4 burner gas ranges. Also a seperate office, wet bar, fenced pool and spa, a fabulous patio and certainly designed for fun, yet luxurious living. Quality constructed with the finest materials. A very rare opportunity.
Single-familyProperty Type
1978Year Built
0.5 acresLot Size
$494Est. Price/Sq.Ft.
3 car garageParking
Listed by Phil Schmidt•DRE #00496064• PMZ Real Estate
Bought with Non-MLS Member• Non-MLS Office
Source:MetroList #80058205
Redfin Estimate
$3,039,523
$2.0M since sold in October 2022$165K since September
Recently sold homes
Estimate history
Homes for sale
This home's estimate is 105.1% higher than the average sale price ($1.48M) of 6 comparable homes.
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Permits
Dec 16, 2015 • Final
Residential reroof
Install a new white cool roof PVC membrane overlay over an existing built-up roofing system.
Roofing
Jul 27, 2012 • Final
Residential and commercial building
Remodel and convert an existing dwelling to include a master suite with a bathroom and a gallery.
Remodel
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Interior
Bathroom Information
# of Full Baths: 5
Heating & Cooling
Air Conditioning Type: Central
Heating Type: Central
Fireplace Information
# of Fireplaces: 3
Has Fireplace
Exterior
Exterior Information
Construction Type: Wood
Building Construction Quality: Excellent
Building Type: Residential
Pool Information
Pool Type: Gunite and Spa
Has Pool
Property Information
Subdivision Name: HILLCREST ESTATES 01
Living Sq. Ft: 6,157
Gross Sq. Ft: 6,157
# of Stories: 1
Legal Description: HILLCREST ESTS #1 LOT 7,8 BLOCK C
Parking & Garage Information
# of Parking Spaces: 3
Parking Type: Garage/Carport
Garage/Parking Sq. Ft: 682
Lot Information
# of Buildings: 1
Land Sq. Ft: 21,600
Legal Lot Number: 7
Legal Block Number: C
Acres: 0.4959
Front Footage: 135
County Use Description: SGL FAM W/EXTRALAND
Financial
Assessor Information
Assessment Year: 2026
Public facts
Beds: 4
Baths: 5.0
Sq. Ft.: 6,157
Stories: 1.0
Lot Size: 0.5 acres
Style: Single Family Residential
Year Built: 1978
Year Renovated: —
County: Stanislaus County
APN: 004079019000
Home facts updated by county records on Jul 13, 2026
Around this home
Schools
Stanislaus Elementary School
Public K-6 • Assigned • 2.3mi
6/10
Prescott Junior High School
Public 7-8 • Assigned • 4.2mi
4/10
Joseph A. Gregori High School
Public 9-12 • Assigned • 3.0mi
7/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
5/10 Fire Factor
4% chance of being in a wildfire in next 30 years
6/10 Heat Factor
7 days above 102° expected this year, 15 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
10/10 Air Factor
28 unhealthy days expected this year, 32 days in 30 years
Provided by First Street
Historical weather
Modesto, CA • 95356
Average low and high temperatures (°F)
59
39
64
44
72
48
74
49
83
54
89
58
92
61
94
62
88
62
79
55
64
47
55
44
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 13 hours in
June and 4.6 hours in December, placing it above the
U.S. average for solar exposure.
13 hrs
4.6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$2.89M – $3.50M
Reach more buyers when you sell with Redfin. Save up to $30,395 in fees.3 minutes to get started.