You'll enjoy stunning sunsets from the decks as you unwind at the end of the day. This custom-built home features beautiful oak flooring, vaulted beam ceilings, and 9-foot ceilings throughout the bedrooms. Tall windows and doors open to the newer deck off the living room, perfectly designed to capture the fantastic views while filling the home with natural light.Be sure to check out the oversized downstairs family room, complete with a full bath and potential for an additional bedroom. The spacious laundry area includes an extra 220-volt outlet, ideal for canning, along with a large walk-in pantry for added storage.The detached two-bay garage offers approximately 725 sq. ft. with both power and water. Recent upgrades include a new heat pump, water heater, metal roof on the home, and new composition roofing on the garage.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1972
Region
Rural
# of Stories
Two
Price Per Square Foot
$278
Price Per Acre
$425,000
Days On London
1
Cumulative Days On London
1
County
Madera
REO / Bank Owned
No
Cross Street Address
Road 415
Directions
Highway 41 to Road 415 to Road 400 to sign on right
Style
Cabin
Heating & Cooling
Central Cooling, Other
Laundry
Utility Room
Roofing
Composition, Metal
Foundation
Concrete
Primary Bedroom Level
Main
Bath Features
Shower
Flooring
Carpet, Vinyl
# of Fireplaces
1
Exterior
Wood
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Septic Tank, Private Well
Solar
No
Are there garage spaces?
Yes
Garage Type
Detached
Garage Spaces
2
APN
054 281 008 000
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Rivergold
School Type 3
Grade School
School Name 3
Rivergold
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 403750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 446250 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) >= 1279 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1779 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` = 1687174 OR `props-main`.`id` = 1687651 OR `props-main`.`id` = 1671327 OR `props-main`.`id` = 1708115 OR `props-main`.`id` = 1708102 OR `props-main`.`id` = 1720098 OR `props-main`.`id` = 1702353 OR `props-main`.`id` = 1718550 OR `props-main`.`id` = 1687573 OR `props-main`.`id` = 1718266 OR `props-main`.`id` = 1665915 OR `props-main`.`id` = 1726842 OR `props-main`.`id` = 1676323 OR `props-main`.`id` = 1676330 OR `props-main`.`id` = 1723177 OR `props-main`.`id` = 1719041 OR `props-main`.`id` = 1719083 OR `props-main`.`id` = 1726382 OR `props-main`.`id` = 1726362 OR `props-main`.`id` = 1725794 OR `props-main`.`id` = 1725813 OR `props-main`.`id` = 1721416 OR `props-main`.`id` = 1722419 OR `props-main`.`id` = 1687556 OR `props-main`.`id` = 1693882 OR `props-main`.`id` = 1726490 OR `props-main`.`id` = 1665763 OR `props-main`.`id` = 1687544 OR `props-main`.`id` = 1728256 OR `props-main`.`id` = 1728260 OR `props-main`.`id` = 1724372 OR `props-main`.`id` = 1705347 OR `props-main`.`id` = 1722098 OR `props-main`.`id` = 1718679)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649227' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-22' 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 Bortz, Century 21 Ditton Realty - [email protected] Last modified 17 hours 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.
