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
$1,750,000
2837 Geer Rd, Hughson, CA 95326
4beds
2,282sqft
Single Family Residence
Built in 1907
4.23 Acres Lot
$870,500 Zestimate®
$767/sqft
$-- HOA
What's special
Expansive propertyMeticulously landscaped groundsBackyard showcases resort-style amenitiesPaved driveway
- 4 days |
- 1,034 |
- 49 |
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.
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 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 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 description: 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
- Sewer: Septic System
- Water: Well
- Utilities for property: Public
Community & HOA
Location
- Region: Hughson
Financial & listing details
- Price per square foot: $767/sqft
- Tax assessed value: $586,613
- Annual tax amount: $6,723
- Price range: $1.8M - $1.8M
- Date on market: 6/2/2026
Estimated market value
$870,500
$775,000 - $984,000
$3,236/mo
Price history
| Date | Event | Price |
|---|---|---|
| 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 |
|---|---|---|
| 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$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 95326
Nearby schools
GreatSchools rating
- 5/10Fox Road Elementary SchoolGrades: 4-5Distance: 0.8 mi
- 7/10Emilie J. Ross Middle SchoolGrades: 6-8Distance: 0.9 mi
- 6/10Hughson High SchoolGrades: 9-12Distance: 0.7 mi
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
Local buyer's agents are ready to help
- California
- Stanislaus County
- Hughson
- 95326
- 2837 Geer Rd





