Discover this stunning corner lot estate offering breathtaking mountain and agricultural views that stretch as far as the eye can see. This spacious 4-bedroom, 3-bathroom home radiates quality craftsmanship and timeless elegance, featuring soaring vaulted ceilings, a sun-drenched skylight in the kitchen, and a thoughtful layout designed for both everyday living and effortless entertaining.The formal living and dining rooms set a refined tone, while a private junior suite with its own full bathroom offers ideal flexibility for multigenerational living or guests. A central whole-house vacuum system and a premium Bosch tankless instant water heater speak to the elevated, high-end finishes and thoughtful upgrades found throughout.Major capital improvements are already done enjoy peace of mind with a newer roof, updated well, and dual-pane windows throughout. The attached 3-car garage provides generous storage and convenience, while two mature fruit trees add a charming, established touch to the property.The crown jewel for the hobbyist, rancher, or entrepreneur: an extraordinary 60x40 ft shop nearly 2,400 sq ft of covered workspace ready for equipment, a business, or whatever you envision. Combined with the agricultural setting and corner lot positioning, the usability of this property is virtually unmatched in the area.Priced with opportunity in mind, this is truly a home where the bones and the setting do the talking. Bring your vision and make it your own. Properties like this rarely come to market schedule your private showing today.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1991
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$240
Price Per Acre
$559,200
Days On London
42
Cumulative Days On London
42
County
Madera
Special Features
Built In Cabinets, Central Vac, Skylight, Wet/Dry Bar, Horses Allowed
REO / Bank Owned
No
Cross Street Address
Mesa Dr.
Directions
Ave 134 and Mesa Dr. corner
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Utility Room
Roofing
Composition
Foundation
Concrete
Detached Structures
Shop, Shed
Kitchen
Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Eating Area, Breakfast Bar, Pantry
Dual Pane Windows, 13+ SEER A/C, Tankless Water Heater
Solar
No
Parking Features
Existing RV Parking, Work/Shop Area, Drive Thru, Street
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
3
Site Amenities
Corner, Cross Fenced
APN
049 191 010 000
School District
Golden Valley
School Type 1
High School
School Name 1
Liberty
School Type 2
Junior High School
School Name 2
Ranchos
School Type 3
Grade School
School Name 3
Webster
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 664050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 733950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2665 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3165 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1737180 OR `props-main`.`id` = 1728934 OR `props-main`.`id` = 1679767 OR `props-main`.`id` = 1731247 OR `props-main`.`id` = 1731800 OR `props-main`.`id` = 1739013 OR `props-main`.`id` = 1733409 OR `props-main`.`id` = 1722874 OR `props-main`.`id` = 1725865 OR `props-main`.`id` = 1729340 OR `props-main`.`id` = 1728972)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno648443' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-19' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
0
Last modified 2 weeks ago Fresno MLS last checked for updates 46 minutes ago
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
