2837 Geer RoadHughson, CA 95326




Mortgage Calculator
Monthly Payment (Est.)
$7,752Welcome 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.
| a month ago | Listing updated with changes from the MLS® | |
| a month ago | Status changed to Active | |
| a month ago | Price changed to $1,699,000 | |
| 2 months ago | Listing first seen on site |
All measurements and all calculations of the area are approximate. Information provided by Seller/Other sources, not verified by Broker. All interested persons should independently verify the accuracy of information. Provided properties may or may not be listed by the office/agent presenting the information. Data maintained by MetroList® may not reflect all real estate activity in the market. All real estate content on this site is subject to the Federal Fair Housing Act of 1968, as amended, which makes it illegal to advertise any preference, limitation or discrimination because of race, color, religion, sex, handicap, family status or national origin or an intention to make any such preference, limitation or discrimination. Terms of Use
Last checked 2026-08-04 09:16 PM PDT
