Incredible barn conversion on 3.35 beautiful acres. This lovely mountain home has rustic charm throughout with all the modern amenities as well. The well appointed kitchen has stainless steel appliances and newer light pine cabinetry. The open and spacious lower level has two living areas, indoor laundry, a full bathroom, and a large breakfast nook area At the top of the extra wide staircase lies an expansive primary suite loft with an office area within as well as a cute en suite bathroom with a freestanding soaking tub. The french doors lead to a huge covered balcony that overlooks the picturesque property. There is also an outside private staircase and entrance to the Master suite. At the top of the grounds, there is a manufactured home that is to be included with no warranty or value. Once done, this adu can be rented for up to $1500 a month. On the opposite end of the property there is a separate entrance from the road and a huge 800 square foot shop with two 15 foot roll up doors that could rent for appx. 700 per month Leaving a very small payment to live in the main home. There are also two train cars by the shop with one that looks like it is set up as a little store. There are also sprinkler towers throughout the property, and two well storage tanks (10,000 gal drinking water, and 15,000 for irrigation and livestock). Bedroom and bathroom count is 1 bed 2 bath in the main home, and 2 bedroom 1 bath in the manufactured home.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1990
Region
Mountain
# of Stories
Two
Price Per Square Foot
$185
Price Per Acre
$119,731
Days On London
2
Cumulative Days On London
2
County
Madera
Special Features
Security System, Built In Cabinets, Horses Allowed
REO / Bank Owned
No
Cross Street Address
hwy 41
Directions
hwy 41 north from fresno and property is on the right just a few miles past YLP.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 379905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 419895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1916 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2416 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` = 1715005 OR `props-main`.`id` = 1715000 OR `props-main`.`id` = 1686833 OR `props-main`.`id` = 1697830 OR `props-main`.`id` = 1701872 OR `props-main`.`id` = 1703080 OR `props-main`.`id` = 1703090 OR `props-main`.`id` = 1715645 OR `props-main`.`id` = 1715628 OR `props-main`.`id` = 1689856 OR `props-main`.`id` = 1689840 OR `props-main`.`id` = 1714047 OR `props-main`.`id` = 1709677 OR `props-main`.`id` = 1700161 OR `props-main`.`id` = 1700167 OR `props-main`.`id` = 1702230 OR `props-main`.`id` = 1689800 OR `props-main`.`id` = 1666255 OR `props-main`.`id` = 1695425 OR `props-main`.`id` = 1622991)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno645149' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-13' 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
Courtesy of Daniel Markendorf, Markendorf and Associates - [email protected] Last modified 2 days ago Fresno MLS last checked for updates 6 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.
