This is an amazing, once-in-a-lifetime opportunity to own a pristine gentleman farmer's 38 acre spread. You will simply not find another property like this one. Located just minutes from Fresno or Madera, this property is located in a idyllic, pleasant, tucked away setting far from the hustle and bustle. The original home was removed and this super custom home was constructed in 2008. From the minute you see the wrap around porch with views of the Sierra mountains, you know this is the property you have always been looking for. Once you step inside, you immediately feel the opulence and know that not one detail has been overlooked. Every part of the home has been thought out, to the large gourmet kitchen to the master bedroom with views for miles, Even though it was built in 2008, this home oozes a simple country charm of yesteryear. Some, but not all of the custom features include: heated master bath floor completed with claw foot bathtub, two tankless water heaters for instant hot water, built-in desk, file drawers, and bookcase in the office that would be easy to turn into a 4th bedroom, custom flooring throughout, custom counters throughout, R.O. water system for drinking and ice, ceiling fans in every room and the porch, built-in speaker system inside and out, oversized laundry room, 2 fireplaces, full built-ins in kitchen including built-in color co-ordinated refrigerator, and much, much, more. But you don't want to forget about the OWNED solar system which drastically reduces your electric bills. Outside, beyond the wrap around porch, you will find a plunge salt water pool with an automatic pool cover and roof mounted, heating coils to heat the pool, a free standing jacuzzi, an oversized two car garage with mini split system heating/cooling and a wine fridge. The acreage features 18 acres (apx) of Thompson grapes and 18 acres (apx) of Selma Pete grapes. All of the grapes are on drip and flood irrigation (depending on the source of water you are using).There are two sources of water, MID and a shared well. The property is zoned AR 20 with a future possibility for splitting. Plus there is a large metal shed, a covered parking area, and a chicken coop complete with chickens (what gentleman's farm would be complete without chickens)? So, I ask you, what more could you ask for in a gentleman's farm? Nothing that I can think of. You do not want to pass up this opportunity to own something this rare and sought after.
For sale
Price cut: $100K (6/12)
$1,649,000
7826 Road 28, Madera, CA 93637
3beds
2,894sqft
Single Family Residence
Built in 2008
37.88 Acres Lot
$1,596,800 Zestimate®
$570/sqft
$-- HOA
What's special
- 132 days
- 113
- 7
Zillow last checked:
Listing updated:
Source: SFAR,MLS#: 226600144
Originating MLS: San Francisco Association of REALTORS
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 4
- Full bathrooms: 2
- 1/2 bathrooms: 2
Rooms
- Room types: Laundry, Office, Kitchen, Living Room, Family Room
Primary bedroom
- Area: 0
- Dimensions: 0 x 0
Bedroom 1
- Area: 0
- Dimensions: 0 x 0
Bedroom 2
- Area: 0
- Dimensions: 0 x 0
Bedroom 3
- Area: 0
- Dimensions: 0 x 0
Bedroom 4
- Area: 0
- Dimensions: 0 x 0
Bathroom
- Features: Shower Stall(s), Tub w/Shower Over
Dining room
- Features: Formal Area, Formal Room
- Area: 0
- Dimensions: 0 x 0
Family room
- Area: 0
- Dimensions: 0 x 0
Kitchen
- Area: 0
- Dimensions: 0 x 0
Living room
- Area: 0
- Dimensions: 0 x 0
Heating
- Central
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Microwave, Disposal, Dishwasher
- Laundry: Inside Room, Inside
Features
- Flooring: See Remarks
- Has fireplace: Yes
- Fireplace features: Living Room, Family Room, See Remarks
Interior area
- Total structure area: 2,894
- Total interior livable area: 2,894 sqft
Video & virtual tour
Property
Parking
- Total spaces: 6
- Parking features: Garage Door Opener, See Remarks, RV Possible, Garage Faces Rear
- Garage spaces: 2
- Uncovered spaces: 4
Features
- Levels: Two
- Stories: 2
- Patio & porch: Wrap Around
- Pool features: See Remarks, Salt Water, In Ground
- Has spa: Yes
- Has view: Yes
- View description: Vineyard, Mountain(s)
Lot
- Size: 37.88 Acres
- Features: Sprinklers In Rear, Sprinklers In Front
Details
- Additional structures: Other, Shed(s)
- Parcel number: 048130001
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Roof: Composition
Condition
- Year built: 2008
Utilities & green energy
- Sewer: Septic Tank
- Water: See Remarks, Shared Well
- Utilities for property: Electricity Available
Community & HOA
Community
- Security: Smoke Detector(s), Carbon Monoxide Detector(s)
HOA
- Has HOA: No
Location
- Region: Madera
- Elevation: 0
Financial & listing details
- Price per square foot: $570/sqft
- Tax assessed value: $1,217,533
- Price range: $1.6M - $1.6M
- Date on market: 4/19/2026
- Cumulative days on market: 13 days
- Listing terms: Cash,Conventional
- Total actual rent: 0
- Road surface type: Paved
Estimated market value
$1,596,800
$1.52M - $1.68M
$3,177/mo
Price history
| Date | Event | Price |
|---|---|---|
| 7/15/2026 | Pending sale | $1,549,000$535/sqft |
Source: Fresno MLS #647428 Report a problem | ||
| 6/12/2026 | Price change | $1,549,000-6.1%$535/sqft |
Source: Fresno MLS #647443 Report a problem | ||
| 4/18/2026 | Listed for sale | $1,649,000+233.8%$570/sqft |
Source: Fresno MLS #647428 Report a problem | ||
| 10/18/2005 | Sold | $494,000$171/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | -- | $1,217,533 +2.2% |
| 2025 | $16,047 -0.9% | $1,191,383 +1.7% |
| 2024 | $16,193 +2.2% | $1,171,837 +2.2% |
| 2023 | $15,843 +3.8% | $1,146,491 +4% |
| 2022 | $15,260 +3.1% | $1,102,742 +1.8% |
| 2021 | $14,800 +0.8% | $1,083,030 +3.6% |
| 2020 | $14,680 +1.8% | $1,045,515 +2.2% |
| 2019 | $14,418 +8.5% | $1,022,774 +4.3% |
| 2018 | $13,292 +2% | $980,222 +3% |
| 2017 | $13,028 | $952,097 +1.5% |
| 2016 | $13,028 +22.9% | $938,434 -0.2% |
| 2015 | $10,598 +15.5% | $940,014 +9.9% |
| 2014 | $9,178 +7.3% | $855,254 +7.9% |
| 2013 | $8,551 | $792,800 +12% |
| 2012 | -- | $707,920 -18.5% |
| 2011 | -- | $868,839 +0.7% |
| 2010 | -- | $862,401 |
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.Climate risks
Neighborhood: 93637
Local buyer's agents are ready to help




