Home | Stanislaus County | Hughson | 95326 | 2837 Geer Rd
MLS: ME226069655 | Status: Active | Price: $1,750,000
Beds/Baths: 4 / 3 /1
Property Type: Residential
| Beds | Baths | Sq Ft | Acres Lot | Yr Built |
|---|---|---|---|---|
| 4 | 3 /1 | 2,282 | 4.23 | – |
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
| Field | Value |
|---|---|
| MLS # | ME226069655 |
| MLS Source | MetroList Services, Inc. |
| Days on Site | 1 |
| Feature | Details |
|---|---|
| Kitchen | Countertop - Granite |
| Dining Room | Other |
| Laundry | 220 Volt Outlet, Laundry Area |
| Cooling | Central Forced Air |
| Heating | Central Forced Air |
| Feature | Details |
|---|---|
| Roof | Shingle |
| Foundation | Raised |
| Pool | In Ground, Other, Pool - Yes, Pool/Spa Combo, Spa/Hot Tub |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, RV Access, Tandem Parking, Garage: 4 Car(s) |
| Sewer | Septic Tank |
| Water | Well |
| Zoning | Rur Hmst |
Francisco Ruvalcaba
J.Peter Realtors
License #: 02067407
Phone: (209) 493-2400
| # Buildings | # Leased Units | # Total Units |
|---|---|---|
| 0 | – | – |
School data provided by GreatSchools.org
©2026 MetroList Services, Inc. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MetroList Services, Inc.
Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.
This listing information is up-to-date as of June 02, 2026. For the most current information, please contact Francisco Ruvalcaba, (209) 493-2400.