2837 Geer Rd Hughson, CA 95326
Estimated payment $9,994/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 |
|---|---|---|---|---|---|
| 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 | $300,000 | New Conventional | |
| 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.
- 13571 Wimer
- 2468 6th St
- 7419 Pine St
- 2324 6th St
- 1917 Thomas Taylor Dr
- 2117-B Vincent Ave
- 2117 Vincent Ave
- 1909 Thomas Taylor Dr
- 1795 Mulberry Way
- 7638 Path Dr
- 1606 Symphony Ln
- 1708 Feathers Ct
- 1501 Tristan Ct
- 1704 Carpathian Way
- 6509 Catkin Ct
- 1817 San Gabriel Dr
- 1696 Firebrite Ct
- 6500 Narcisco Way
- 1957 Apiary Way
- 1601 Redhaven Place
- 6308 Sun Hvn St
- 6142 Honey Hvn Ln
- 4483 Fosberg Rd
- 4389 N Walnut Rd
- 1163 E Springer Dr
- 4232 Windrose Dr
- 1360 Shady Ln
- 1360 Shady Ln Unit 300
- 1360 Shady Ln Unit 318
- 3052 Red Oak Ct
- 545 Bluefield Ave
- 3668 Waynesboro Dr
- 3661 La Mancha Place
- 3611 Apple Blossom Ln
- 2034 Boothe Rd
- 3492 Gerald Ct
- 3470 Santos Ct
- 3025 W Christoffersen Pkwy
- 2464 Oak Crest Dr
- 4705 Yosemite Blvd Unit B
Ask me questions while you tour the home.