Refine Search
Sort by
820 Charles Street, Hughson
$1,600,000
4 Beds ⋅ 3 Baths ⋅ 3,700 SqFt. ⋅ 226104493 MLS
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

820 Charles Street, Hughson

Listing courtesy of PMZ Real Estate.

4331 E Service Road, Ceres
$1,250,000
4 Beds ⋅ 3 Baths ⋅ 2,646 SqFt. ⋅ 226118178 MLS
Now listed as a single family ranchette! This is a wonderful opportunity to enjoy country living at its finest, featuring a beautifully maintained custom ranch style home, including 4 bedrooms and 3 bathrooms with a sparkling in-ground pool and fenced-in back yard. The property also includes a mature almond orchard within the Turlock Irrigation District (TID), with additional support from the Fox Wagner Improvement District as a second source of irrigation water. Ideally located just a mile from the city of Ceres, offering convenient access to local amenities and HWY 99. A rear opportunity to enjoy the privacy and character of country living while remaining close to town. Seller motivated.

4331 E Service Road, Ceres

Listing courtesy of PMZ Commercial Real Estate.

metrolist logo

All measurements and all calculations of area (i.e., Sq Ft and Acreage) are approximate. Broker has represented to MetroList that Broker has a valid listing signed by seller authorizing placement in the MLS. Above information is provided by Seller and/or other sources and has not been verified by Broker. Copyright 2026 MetroList Services, Inc. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of MetroList® MLS. All information has been provided by seller/other sources and has not been verified by broker. All interested persons should independently verify the accuracy of all information. Last updated .

Terms of Use

How much is your home worth?

Get instant property value now!