Courtesy of Katie Miller, London Properties, Ltd. - [email protected]
Fantastic ADA‑friendly setup with walk‑in showers, wide access points, and thoughtful single‑level living. The garage has been professionally converted into a charming granny unit complete with kitchenette, bedroom, and bathroomideal for multi‑generational living or added rental income. The main home features a bright dining area with a bay window overlooking peaceful landscaping and an above‑ground spa for relaxing evenings under the oak trees. Located in a quiet neighborhood surrounded by mature oaks, this property offers comfort, versatility, and investment potential. Looking for a family compound or dual‑investment opportunity? The neighboring home at 42339 Lulang is also for salemaking this a rare chance to secure two adjacent properties.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1997
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$216
Price Per Acre
$210,000
Days On London
0
Cumulative Days On London
0
County
Madera
Special Features
Other/See Remarks
REO / Bank Owned
No
Cross Street Address
Hwy 49 & Rd 619
Directions
From Hwy 49, head toward Ahwahnee. Turn east onto Road 600 (this is the main turnoff toward Ahwahnee). Continue on Road 600 for several miles until you reach Road 619. Turn left onto Road 619. Follow Road 619 until you reach the property
Style
Ranch
Heating & Cooling
Central Heat & Cool, Other
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Kitchen
Electric Appliances, Disposal, Dishwasher, Microwave
Primary Bedroom Level
Main
Bath Features
Shower
Extra Rooms
Converted Garage
Exterior
Wood
Pool
No
Pool
No
Patio Features
Covered, Enclosed, Concrete
Yard
Sprinklers Back
Gas & Electric
Public Utilities, Propane
Sewer / Water
Septic Tank, Private Well
Energy Efficiency
Dual Pane Windows
Solar
No
Are there garage spaces?
No
APN
055 072 010 000
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Oak Creek
School Type 3
Grade School
School Name 3
Oakhurst
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 498750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 551250 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) >= 2186 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2686 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` = 1735991 OR `props-main`.`id` = 1718208 OR `props-main`.`id` = 1718322 OR `props-main`.`id` = 1716342 OR `props-main`.`id` = 1737403 OR `props-main`.`id` = 1737395 OR `props-main`.`id` = 1751304 OR `props-main`.`id` = 1719081 OR `props-main`.`id` = 1719036 OR `props-main`.`id` = 1725507 OR `props-main`.`id` = 1753413 OR `props-main`.`id` = 1611781 OR `props-main`.`id` = 1611780 OR `props-main`.`id` = 1738609 OR `props-main`.`id` = 1716115 OR `props-main`.`id` = 1716195 OR `props-main`.`id` = 1767696 OR `props-main`.`id` = 1767697 OR `props-main`.`id` = 1686974 OR `props-main`.`id` = 1686922 OR `props-main`.`id` = 1748665 OR `props-main`.`id` = 1748616 OR `props-main`.`id` = 1742456 OR `props-main`.`id` = 1765469 OR `props-main`.`id` = 1753382 OR `props-main`.`id` = 1769167 OR `props-main`.`id` = 1769189 OR `props-main`.`id` = 1749710 OR `props-main`.`id` = 1749681 OR `props-main`.`id` = 1726581 OR `props-main`.`id` = 1722180 OR `props-main`.`id` = 1726566 OR `props-main`.`id` = 1723664 OR `props-main`.`id` = 1723658 OR `props-main`.`id` = 1722176 OR `props-main`.`id` = 1715530 OR `props-main`.`id` = 1697446 OR `props-main`.`id` = 1729079 OR `props-main`.`id` = 1729091 OR `props-main`.`id` = 1754372 OR `props-main`.`id` = 1754404 OR `props-main`.`id` = 1716004 OR `props-main`.`id` = 1714989 OR `props-main`.`id` = 1753129 OR `props-main`.`id` = 1753150)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno654389' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-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
Last modified 2 hours ago Fresno MLS last checked for updates 43 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.
