A Hidden Mid-Century Modern Estate Beneath a Canopy of Majestic Oaks! Tucked away from a quiet country road, a shared private driveway winds beneath a magnificent canopy of majestic mature oaks, creating a grand and memorable approach to this private country estate. Set on 15.79 acres - 13 farmable acres of 5th Leaf Independence Almond Trees with Drip Irrigation - Ag well on this 3,700-square-foot beauty, 4 bed/3 bath is embraced by stately oak & olive trees, lush borders of ivy, mature landscaping and an assortment of citrus trees. The setting feels established, peaceful and wonderfully secluded. Inside, the home's architectural character immediately takes center stage. Dramatic ceiling treatments, striking architectural lines and expansive floor-to-ceiling windows fill the family room, kitchen & dining area, and living room with natural light while capturing beautiful views of the surrounding landscape. Outdoor access from the main gathering spaces further enhances the home's effortless indoor-outdoor connection. A unique exterior atrium allows even more filtered natural light into adjoining rooms, while two fireplaces add warmth and inviting focal points to the living spaces. The spacious kitchen blends character and functionality with quartz/granite countertops, abundant cabinetry & workspace just to name a few. A grand mudroom with it's own sink generous storage, double barn door pantry is perfectly suited to life on acreage. Two HVAC systems provide added comfort for all. Each bedroom has its own sliding glass door opening directly outside a distinctive design element that provides natural light, fresh air and a personal connection to the peaceful grounds. Downstairs, 770 sf basement adds another collection of useful spaces, including an exercise room, dedicated wine cellar, hobby/craft room, and tremendous additional storage, with room for extra freezers and the home's mechanical equipment. Just outside, a charming hobby vineyard planted with Zinfandel grapes pairs perfectly with the winemaking room. Two car garage with carport is a few steps from the home A extra 24x36 detached workshop finished garage has sink/toilet, AC, workbench separate electric panel, septic & garage doors...why not create an in-law suite or ADU? The 40x90 metal shop w/ 3 12x12 roll up doors, separate electric panel, 220V, electric galore! Store all your favorite, cars, boats, RV's, equipment for you. Whomever buys this home buys an amazing lifestyle
Single-familyProperty Type
1968Year Built
15.79 acresLot Size
$432Price/Sq.Ft.
2 garage spacesParking
Listed by Debbi Agresti•DRE #01358241• PMZ Real Estate
This is a new listing, so no sales records exist yet. As the MLS and public records start to fill up, we'll list the details here.
Year
Property tax
Land + Additions
Assessment*
2026
$8,734 (−0.4%)
$242,808 + $524,666
$767,474
2025
$8,768 (+6.7%)
$242,808 + $524,666
$767,474
2024
$8,218 (+1.4%)
$242,650 + $514,379
$757,029
2023
$8,103 (−2.3%)
$250,994 + $491,034
$742,028
2022
$8,292
$253,626 + $481,406
$735,032
Public record
Public record
Zoning
Permits
Beds
4
Baths
3
Stories
—
Lot width
—
Lot depth
—
Lot size
15.79 Acres
Year renovated
—
Finished Sq. Ft.
3,215
Unfinished Sq. Ft.
—
Total Sq. Ft.
3,215
Year built
1968
Style
Single Family Residential
County
Stanislaus County
APN
018003008000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 15, 2026.
A-2-40
General Agriculture District
It is the intent of these district regulations to support and enhance agriculture as the predominant land use in the unincorporated areas of the county. These district regulations are also intended to protect open space lands pursuant to Government Code Section 65910. The procedures contained in this chapter are specifically established to ensure that all land uses are compatible with agriculture and open space, including natural resources management, outdoor recreation and enjoyment of scenic beauty.
Permitted uses
Include but are not limited to:
Agriculture
Day care facility
Housing-Single unit
Feb 27, 2020 • Final
Residential reroof
Tear off and replace the roof on a single-family home.
Roofing
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.
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
5/10 Fire Factor
6% chance of being in a wildfire in next 30 years
6/10 Heat Factor
6 days above 102° expected this year, 12 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
10/10 Air Factor
34 unhealthy days expected this year, 37 days in 30 years
Provided by First Street
Historical weather
Hughson, CA • 95326
Average low and high temperatures (°F)
59
39
64
44
72
48
74
49
83
55
91
59
93
62
94
63
88
63
79
56
64
47
55
44
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
99/ 100
Exceptional sunlight
Sunscore
This home receives average direct sun exposure in Hughson. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
11.2 hrs
7.2 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 820 Charles St
$1,534,885
$65K under list price of $1.60M
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $547K to $630K.