**Price reduced $100,000 on 6/11/26!**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's 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,549,000
7826 Road 28, Madera, CA 93637
3beds
3baths
--sqft
Farm
Built in 2008
37.88 Acres Lot
$1,483,700 Zestimate®
$--/sqft
$-- HOA
What's special
Covered parking areaLarge gourmet kitchenCustom flooring throughoutHeated master bath floorCustom counters throughoutClaw foot bathtubFree standing jacuzzi
- 83 days |
- 325 |
- 22 |
Zillow last checked:
Listing updated:
Listed by:
Louis Wiebe DRE #00788751 559-363-4940,
Wiebe Real Estate
Source: Fresno MLS,MLS#: 647443Originating MLS: Fresno MLS
Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
Video & virtual tour
Property
Lot
- Size: 37.88 Acres
- Features: Rural
- Topography: Flat
Details
- Additional structures: Residence, Shed(s), Other
- Parcel number: 048130001000
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Farm
Condition
- Year built: 2008
Utilities & green energy
- Sewer: Septic Tank
- Water: Well, District Water Avail
- Utilities for property: Propane, Electricity Connected
Community & HOA
Location
- Region: Madera
Financial & listing details
- Tax assessed value: $1,191,383
- Annual tax amount: $16,047
- Date on market: 4/17/2026
- Cumulative days on market: 83 days
- Listing agreement: Exclusive Right To Sell
- Electric utility on property: Yes
Estimated market value
$1,483,700
$1.41M - $1.56M
$3,469/mo
Price history
| Date | Event | Price |
|---|---|---|
| 6/12/2026 | Price change | $1,549,000-6.1% |
Source: Fresno MLS #647443 Report a problem | ||
| 4/18/2026 | Listed for sale | $1,649,000+233.8% |
Source: Fresno MLS #647428 Report a problem | ||
| 10/18/2005 | Sold | $494,000 |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 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$--/mo
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: 93637
Nearby schools
GreatSchools rating
- 2/10Eastin-Arcola Elementary SchoolGrades: K-8Distance: 1.6 mi
- 3/10Madera South High SchoolGrades: 9-12Distance: 5.2 mi
Schools provided by the listing agent
- Elementary: Eastin-Arcola
- Middle: Eastin-Arcola
- High: Madera South
Source: Fresno MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
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.
Local buyer's agents are ready to help
- California
- Madera County
- Madera
- 93637
- 7826 Road 28




