Skip main navigation
Active
  • $1,750,000

    2837 Geer Rd, Hughson, CA 95326

    4beds
    2,282sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in 1907
    4.23 Acres Lot
    $870,500 Zestimate®
    $767/sqft
    $-- HOA

    What's special

    Expansive propertyMeticulously landscaped groundsBackyard showcases resort-style amenitiesPaved driveway
    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.
    4 days
    |
    1,034
    |
    49
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Francisco Ruvalcaba DRE #02067407 209-493-2400,

    J.Peter Realtors

    Source: MetroList Services of CA,MLS#: 226069655Originating MLS: MetroList Services, Inc.

    Tour with a local agent

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 4
      • Full bathrooms: 3
      • Partial bathrooms: 1
      Dining room
      • Features: Other
      Kitchen
      • Features: Granite Counters
      Heating
      • Central
      Cooling
      • Central Air
      Appliances
      • Laundry: Inside
      Features
      • Flooring: Luxury Vinyl Plank
      • Has fireplace: No
      Interior area
      • Total interior livable area: 2,282 sqft

      Property

      Parking
      • Total spaces: 4
      • Parking features: Attached, RV Access/Parking, Tandem, Workshop in Garage
      • Attached garage spaces: 4
      Features
      • Has private pool: Yes
      • Pool features: In Ground, Pool/Spa Combo
      Lot
      • Size: 4.23 Acres
      • Features: Auto Sprinkler F&R
      Details
      • Additional structures: Pool House
      • Parcel number: 018052029000
      • Zoning description: Rur Hmst
      • Special conditions: Standard

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family Residence
      Materials
      • Stucco, Wood
      • Foundation: Raised
      • Roof: Shingle
      Condition
      • Year built: 1907

      Utilities & green energy

      • Sewer: Septic System
      • Water: Well
      • Utilities for property: Public

      Community & HOA

      Location
      • Region: Hughson

      Financial & listing details

      • Price per square foot: $767/sqft
      • Tax assessed value: $586,613
      • Annual tax amount: $6,723
      • Price range: $1.8M - $1.8M
      • Date on market: 6/2/2026
      Get pre-qualifiedBe ready to make an offer.
      Connect with an agentGet info on this home, tour, and more.
      Calculate monthly paymentSee if you can afford this home.

        Estimated market value

        $870,500

        $775,000 - $984,000

        $3,236/mo

        Price history

        DateEventPrice
        6/2/2026Listed for sale$1,750,000+464.5%$767/sqft
        Source: MetroList Services of CA #226069655 Report a problem
        2/4/2015Sold$310,000-12.7%$136/sqft
        Source: MetroList Services of CA #14071012 Report a problem
        1/2/2015Pending sale$355,000$156/sqft
        Source: Berkshire Hathaway HomeService #14071012 Report a problem
        11/15/2014Listed for sale$355,000$156/sqft
        Source: Prudential California Realty - CA #14071012 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$6,723 +6.6%$586,613 +2%
        2024$6,309 +2.3%$575,112 +2%
        2023$6,164 +1.6%$563,836 +2%
        2022$6,070 +17.8%$552,782 +18.2%
        2021$5,151 +12.6%$467,797 +12.3%
        2020$4,575 +10.5%$416,716 +11.7%
        2019$4,141 +9.3%$372,938 +8.3%
        2018$3,789 +4.2%$344,439 +7.3%
        2017$3,636 +6%$321,020 +2%
        2016$3,429 +288.3%$314,727 +267.5%
        2015$883 $85,645 +2%
        2014$883 $83,969 +4.5%
        2012-- $80,346
        2011-- $80,346 +0.8%
        2010-- $79,746 -0.2%
        2009-- $79,935 +2%
        2008-- $78,369 +2%
        2007-- $76,833 +2%
        2006-- $75,328 +2%
        2005-- $73,852 +2%
        2004$704 -0.7%$72,405 +1.9%
        2003$709 $71,079 +2%
        2002-- $69,685 +2%
        2001$683 +1.9%$68,319 +2%
        2000$670 $66,980

        Find assessor info on the county website

        Monthly payment

        Est. payment

          Payment breakdown

          Explore the cost of this home by adjusting the details. Changes won't be saved.
          All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
          HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
          Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
          See how much you could borrow to make a competitive offer.

          Climate risks

          Neighborhood: 95326

          Getting around

          21 / 100
          Car-Dependent
          26 / 100
          Somewhat Bikeable

          Nearby schools

          GreatSchools rating

          A local agent can set up tours, give advice and negotiate with sellers.

          A local lender can help you make sure your offer is ready when you are.

          Browse local experts

          Similar homes

          Skip to the end of the carouselSkip to the beginning of the carousel
              • Local buyer's agents are ready to help