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.
Active
Price cut: $35K (8/15)
$1,664,000
2837 Geer Rd, Hughson, CA 95326
4beds
2,282sqft
Single Family Residence
Built in 1907
4.23 Acres Lot
$1,595,600 Zestimate®
$729/sqft
$-- HOA
What's special
Expansive propertyMeticulously landscaped groundsBackyard showcases resort-style amenitiesPaved driveway
- 95 days
- 1,146
- 40
Zillow last checked:
Listing updated:
Listed by:
Francisco Ruvalcaba DRE #02067407 209-493-2400,
J.Peter Realtors
Source: MetroList Services of CA,MLS#: 226069655Originating MLS: MetroList Services, Inc.
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- Partial bathrooms: 1
Dining room
- Features: Other
Kitchen
- Features: Granite Counters
Heating
- Central
Cooling
- Central Air
Appliances
- Laundry: Inside
Features
- Flooring: Luxury Vinyl Plank
- Has fireplace: No
Interior area
- Total structure area: 0
- Total interior livable area: 2,282 sqft
Property
Parking
- Total spaces: 4
- Parking features: Attached, RV Access/Parking, Tandem, Workshop in Garage
- Attached garage spaces: 4
Features
- Has private pool: Yes
- Pool features: In Ground, Pool/Spa Combo
Lot
- Size: 4.23 Acres
- Features: Auto Sprinkler F&R
Details
- Additional structures: Pool House
- Parcel number: 018052029000
- Zoning: Rur Hmst
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Stucco, Wood
- Foundation: Raised
- Roof: Shingle
Condition
- Year built: 1907
Utilities & green energy
- Electric: 220 Volts in Laundry
- Sewer: Septic System
- Water: Well
- Utilities for property: Public
Community & HOA
Location
- Region: Hughson
Financial & listing details
- Price per square foot: $729/sqft
- Tax assessed value: $598,344
- Price range: $1.7M - $1.7M
- Date on market: 6/2/2026
Estimated market value
$1,595,600
$1.52M - $1.68M
$3,600/mo
Price history
| Date | Event | Price |
|---|---|---|
| 8/15/2026 | Price change | $1,664,000-2.1%$729/sqft |
Source: MetroList Services of CA #226069655 Report a problem | ||
| 6/30/2026 | Price change | $1,699,000-2.9%$745/sqft |
Source: MetroList Services of CA #226069655 Report a problem | ||
| 6/2/2026 | Listed for sale | $1,750,000+464.5%$767/sqft |
Source: MetroList Services of CA #226069655 Report a problem | ||
| 2/4/2015 | Sold | $310,000-12.7%$136/sqft |
Source: MetroList Services of CA #14071012 Report a problem | ||
| 1/2/2015 | Pending sale | $355,000$156/sqft |
Source: Berkshire Hathaway HomeService #14071012 Report a problem | ||
| 11/15/2014 | Listed for sale | $355,000$156/sqft |
Source: Prudential California Realty - CA #14071012 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | -- | $598,344 +2% |
| 2025 | $6,723 +6.6% | $586,613 +2% |
| 2024 | $6,309 +2.3% | $575,112 +2% |
| 2023 | $6,164 +1.6% | $563,836 +2% |
| 2022 | $6,070 +17.8% | $552,782 +18.2% |
| 2021 | $5,151 +12.6% | $467,797 +12.3% |
| 2020 | $4,575 +10.5% | $416,716 +11.7% |
| 2019 | $4,141 +9.3% | $372,938 +8.3% |
| 2018 | $3,789 +4.2% | $344,439 +7.3% |
| 2017 | $3,636 +6% | $321,020 +2% |
| 2016 | $3,429 +288.3% | $314,727 +267.5% |
| 2015 | $883 | $85,645 +2% |
| 2014 | $883 | $83,969 +4.5% |
| 2012 | -- | $80,346 |
| 2011 | -- | $80,346 +0.8% |
| 2010 | -- | $79,746 -0.2% |
| 2009 | -- | $79,935 +2% |
| 2008 | -- | $78,369 +2% |
| 2007 | -- | $76,833 +2% |
| 2006 | -- | $75,328 +2% |
| 2005 | -- | $73,852 +2% |
| 2004 | $704 -0.7% | $72,405 +1.9% |
| 2003 | $709 | $71,079 +2% |
| 2002 | -- | $69,685 +2% |
| 2001 | $683 +1.9% | $68,319 +2% |
| 2000 | $670 | $66,980 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 95326
Local buyer's agents are ready to help




