Welcome to this exceptional luxury estate, offering endless possibilities for entertaining, business use, and upscale living on 4.23 beautifully maintained acres. The thoughtfully updated 4-bedroom, 2.5-bath residence is accessed through two impressive custom gated entrances that open to meticulously landscaped grounds and a paved driveway. The expansive property provides abundant parking and storage space for RVs, work vehicles, heavy equipment, recreational toys, and more. Designed for entertaining on a grand scale, the backyard showcases resort-style amenities, including a custom-built pool and spa surrounded by lush landscaping. A detached pool house features a full bathroom and bar area, creating the perfect setting for gatherings, celebrations, and outdoor entertaining. The oversized 4-car tandem garage offers exceptional versatility and can accommodate a variety of uses.. The property's extensive outdoor spaces have successfully hosted luxury weddings, private celebrations, and upscale events, while also serving as a functional base for a contractor-owned business. Beyond its impressive appearance, the estate has benefited from significant infrastructure upgrades. In 2017, a durable 50-year roof was installed, providing long-term peace of mind. Water resources are plentiful, with the original 80-foot well complemented by a newer 250-foot well installed just two years ago. The property is also equipped with two separate septic systemsone serving the main residence and another dedicated to the pool house. Additionally, irrigation rights through Turlock Irrigation District add further value and flexibility. There is also a water system that comes with the property. Whether you're seeking a private estate, an entertainer's paradise, a multi-purpose business property, or a unique event venue opportunity, this remarkable property offers a rare combination of luxury, functionality, and future potential.
Single-familyProperty Type
1907Year Built
4.23 acresLot Size
$729Price/Sq.Ft.
4 car garageParking
Listed by Francisco Ruvalcaba•DRE #02067407• J.Peter Realtors
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
Oct 6, 2025 • Final
Residential and commercial building
Construct an attached garage with an enclosed breezeway and storage area. Install two patio covers and a detached cabana.
Addition
ADU
Aug 21, 2025 • Final
Residential reroof
Remove and replace the roof on a residential building. The work includes tearing off the existing roof, installing new sheeting, and applying composition shingles.
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
3/10 Fire Factor
0.31% chance of being in a wildfire in next 30 years
7/10 Heat Factor
7 days above 102° expected this year, 17 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
10/10 Air Factor
38 unhealthy days expected this year, 40 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
91
60
94
64
90
62
79
56
64
47
55
44
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
92/ 100
Exceptional sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
9.9 hrs
6.2 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 2837 Geer Rd
$1,548,965
$115K under list price of $1.66M
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $585K to $855K.