Consider this custom built home an opportunity to enjoy superb architectural, great location, and if you choose, vacation rental income. A short 13 mile drive north on Hwy 41 will grant you access to Yosemite National Park and the Mariposa Grove of Giant Sequoias. Vaulted open beam ceilings throughout the house (yes, in the three bedrooms too) are only one of the features that make this home standout as a cut above the rest. Come experience it yourself. Game room in the garage, wrap around deck, spa, new central heating and air conditioning, on demand propane water heater, sold furnished. Windows, windows, windows; let the light flow through the house and create smiles on all your guests. It's truly an amazing experience to arise for the new day in mountain luxury with plans to take the short ride to Yosemite or Bass Lake with friends and family. Sold mostly furnished with everything you need for a second home or vacation rental.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1980
Region
Mountain
# of Stories
Multi/Split
Price Per Square Foot
$369
Price Per Acre
$1,965,514
Days On Market
0
Cumulative Days On Market
401
County
Madera
REO / Bank Owned
No
Cross Street Address
Shady
Directions
Hwy 41 to Springwood Dr. turn left onto Shady ln. turn left onto Scenic
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 541499.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 598498.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1294 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1794 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` = 1687534 OR `props-main`.`id` = 1685749 OR `props-main`.`id` = 1635838 OR `props-main`.`id` = 1635840 OR `props-main`.`id` = 1685734 OR `props-main`.`id` = 1696418 OR `props-main`.`id` = 1696415 OR `props-main`.`id` = 1678407 OR `props-main`.`id` = 1687579 OR `props-main`.`id` = 1665912 OR `props-main`.`id` = 1676628 OR `props-main`.`id` = 1676642 OR `props-main`.`id` = 1662495 OR `props-main`.`id` = 1657428 OR `props-main`.`id` = 1657431 OR `props-main`.`id` = 1700464 OR `props-main`.`id` = 1687261 OR `props-main`.`id` = 1637104 OR `props-main`.`id` = 1690329 OR `props-main`.`id` = 1690188 OR `props-main`.`id` = 1701192 OR `props-main`.`id` = 1666303 OR `props-main`.`id` = 1693743 OR `props-main`.`id` = 1694055 OR `props-main`.`id` = 1683736 OR `props-main`.`id` = 1687624 OR `props-main`.`id` = 1690354 OR `props-main`.`id` = 1679336 OR `props-main`.`id` = 1683721 OR `props-main`.`id` = 1694724 OR `props-main`.`id` = 1584048 OR `props-main`.`id` = 1559272 OR `props-main`.`id` = 230457)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno641572' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-02' 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 John Zisa, Compass - [email protected] Last modified 1 hour ago Fresno MLS last checked for updates 9 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.
