VALUE IMPROVEMENT Consider this custom built home and creek side vacant land an opportunity to enjoy superb architectural, great location, and if you choose, vacation rental income. Yes, also included in the sale is vacant land parcel number 2. Private creek access from this home is across the street. Enjoy the year round serenity of Lewis creek. You and your guest will enjoy the shady shore and inviting cool waters. 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.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1980
Region
Mountain
# of Stories
Multi/Split
Price Per Square Foot
$437
Price Per Acre
$2,327,586
Days On Market
243
Cumulative Days On Market
337
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) >= 641250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 708750 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` = 1687547 OR `props-main`.`id` = 1687534 OR `props-main`.`id` = 1666298 OR `props-main`.`id` = 1685749 OR `props-main`.`id` = 1635838 OR `props-main`.`id` = 1635840 OR `props-main`.`id` = 1685734 OR `props-main`.`id` = 1669916 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` = 1685943 OR `props-main`.`id` = 1685921 OR `props-main`.`id` = 1682709 OR `props-main`.`id` = 1687261 OR `props-main`.`id` = 1637104 OR `props-main`.`id` = 1690329 OR `props-main`.`id` = 1690188 OR `props-main`.`id` = 1627751 OR `props-main`.`id` = 1627748 OR `props-main`.`id` = 1641529 OR `props-main`.`id` = 1641389 OR `props-main`.`id` = 1670965 OR `props-main`.`id` = 1666303 OR `props-main`.`id` = 1683736 OR `props-main`.`id` = 1662319 OR `props-main`.`id` = 1687624 OR `props-main`.`id` = 1690354 OR `props-main`.`id` = 1679336 OR `props-main`.`id` = 1671544 OR `props-main`.`id` = 1671553 OR `props-main`.`id` = 1683721 OR `props-main`.`id` = 1584048 OR `props-main`.`id` = 1559272 OR `props-main`.`id` = 1686240 OR `props-main`.`id` = 230457)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno625035' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-28' 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 5 months 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.
