2837 Geer Rd Hughson, CA 95326
Hughson AreaEstimated payment $9,688/month
Highlights
- Pool House
- Granite Countertops
- 4 Car Attached Garage
- RV Access or Parking
- No HOA
- Bathtub with Shower
About This Home
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.
Home Details
Home Type
- Single Family
Year Built
- Built in 1907
Lot Details
- 4.23 Acre Lot
- Sprinklers on Timer
- Property is zoned Rur Hmst
Parking
- 4 Car Attached Garage
- Workshop in Garage
- Tandem Garage
- RV Access or Parking
Home Design
- Raised Foundation
- Shingle Roof
- Stucco
Interior Spaces
- 2,282 Sq Ft Home
- 1-Story Property
- Family Room
- Living Room
- Dining Room
- Luxury Vinyl Plank Tile Flooring
- Granite Countertops
Bedrooms and Bathrooms
- 4 Bedrooms
- Secondary Bathroom Double Sinks
- Bathtub with Shower
Laundry
- Laundry in unit
- 220 Volts In Laundry
Home Security
- Carbon Monoxide Detectors
- Fire and Smoke Detector
Pool
- Pool House
- Pool and Spa
- In Ground Pool
Utilities
- Central Heating and Cooling System
- Well
- Septic System
Community Details
- No Home Owners Association
Listing and Financial Details
- Assessor Parcel Number 018-052-029-000
Map
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $6,723 | $586,613 | $239,764 | $346,849 |
| 2024 | $6,309 | $575,112 | $235,063 | $340,049 |
| 2023 | $6,164 | $563,836 | $230,454 | $333,382 |
| 2022 | $6,070 | $552,782 | $225,936 | $326,846 |
| 2021 | $5,151 | $467,797 | $221,506 | $246,291 |
| 2020 | $4,575 | $416,716 | $219,235 | $197,481 |
| 2019 | $4,141 | $372,938 | $214,937 | $158,001 |
| 2018 | $3,789 | $344,439 | $210,723 | $133,716 |
| 2017 | $3,636 | $321,020 | $206,592 | $114,428 |
| 2016 | $3,429 | $314,727 | $202,542 | $112,185 |
| 2015 | $892 | $85,645 | $32,109 | $53,536 |
| 2014 | $883 | $83,969 | $31,481 | $52,488 |
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 08/15/2026 08/15/26 | Price Changed | $1,664,000 | -2.1% | $729 / Sq Ft | |
| 06/30/2026 06/30/26 | Price Changed | $1,699,000 | -2.9% | $745 / Sq Ft | |
| 06/01/2026 06/01/26 | For Sale | $1,750,000 | +464.5% | $767 / Sq Ft | |
| 02/04/2015 02/04/15 | Sold | $310,000 | -12.7% | $150 / Sq Ft | View Prior Sale |
| 01/01/2015 01/01/15 | Pending | -- | -- | -- | |
| 11/12/2014 11/12/14 | For Sale | $355,000 | -- | $171 / Sq Ft |
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Interfamily Deed Transfer | -- | Title Connect Inc | |
| Grant Deed | $310,000 | First American Title Company |
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $2,750,000 | Construction | |
| Closed | $300,000 | New Conventional | |
| Closed | $50,000 | Credit Line Revolving | |
| Closed | $25,000 | Credit Line Revolving | |
| Closed | $279,000 | New Conventional |
Source: MetroList
MLS Number: 226069655
APN: 018-52-29
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
- 2237 Province Place
- 2000 Thomas Taylor Dr
- 2143 Locust Ct
- 2324 6th St
- 2117-B Vincent Ave
- 2117 Vincent Ave
- 1913 Fox Glen Dr
- 7424 Heathrow Way
- 1589 Lantern Way
- 1501 Tristan Ct
- 7005 Prelude Ln
- 6801 Varni Way
- 1801 Tully Rd
- 1696 Firebrite Ct
- 6320 Sun Haven St
- 1808 Apiary Way
- 6400 E Hatch Rd
- 3015 S Waring Rd
- 875 Geer Rd
- 6143 Honey Haven Ln
- 7401 Yosemite Blvd
- 4389 N Walnut Rd
- 1245 W Springer Dr
- 5349 Yosemite Blvd
- 2860 Blue Oak Ct
- 1360 Shady Ln Unit 700
- 1360 Shady Ln Unit 1360 Shady Ln. 700
- 425 Bluefield Ave
- 3760 Helen Perry Rd
- 3584 Wild Oak Dr
- 2034 Boothe Rd
- 3470 Santos Ct
- 3025 W Christoffersen Pkwy
- 5230 Mccoy Ave
- 3408 Moonview Dr
- 3450 Sarolou Dr
- 3701 Crowell Rd
- 351 E Monte Vista Ave
- 1525 W Monte Vista Ave
- 581 Ledwith Ct
Ask me questions while you tour the home.