See all 83 photos

$1,750,000

Est. payment - /mo

Save

4 Beds

4 Baths

2,282 SqFt

New

2837 Geer RD Hughson, CA 95326

Save

REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.

In-PersonVirtual Tour

Cindy Mello

cindymello@gmail.com +1(209) 346-4580

UPDATED:

Key Details

Property Type Single Family Home

Sub Type Single Family Residence

Listing Status Active

Purchase Type For Sale

Square Footage 2,282 sqft

Price per Sqft $766

MLS Listing ID 226069655

Bedrooms 4

Full Baths 3

HOA Y/N No

Year Built 1907

Lot Size 49299.441 Acres

Acres 4.23

Property Sub-Type Single Family Residence

Source MLS Metrolist

Property Description

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.

Location

State CA

County Stanislaus

Area 20205

Direction From Hatch Rd go South on Geer past Whitmore and property will be on the westside of the street.

Rooms

Guest Accommodations No

Living Room Other

Dining Room Other

Kitchen Granite Counter

Interior

Heating Central

Cooling Central

Flooring Luxury Vinyl Plank

Laundry Inside Area

Exterior

Parking Features Attached, RV Access, Tandem Garage, Workshop in Garage

Garage Spaces 4.0

Pool Built-In, Pool House, Pool/Spa Combo

Utilities Available Public

Roof Type Shingle

Private Pool Yes

Building

Lot Description Auto Sprinkler F&R

Story 1

Foundation Raised

Sewer Septic System

Water Well

Schools

Elementary Schools Hughson Union

Middle Schools Hughson Union

High Schools Hughson Union

School District Stanislaus

Others

Senior Community No

Tax ID 018-052-029-000

Special Listing Condition None

Listed by J.Peter Realtors

NEARBY SCHOOL & BUSINESS

GET MORE INFORMATION

Cindy Mello

Broker Associate | CA DRE# 01309212

+1(209) 346-4580 | cindymello@gmail.com

QUICK SEARCH