Courtesy of Katie Miller, London Properties, Ltd. - [email protected]
Welcome to this well-appointed 3-bedroom, 2-bath Ahwahnee home, move-in ready and waiting for you! Turnkey and clean, this inviting home features an updated kitchen and bathrooms and is conveniently located between Oakhurst and Mariposa, just minutes from Yosemite National Park and Bass Lake. Whether you're looking for a full-time residence, a weekend getaway, or a fabulous rental opportunity, this property offers endless possibilities in a beautiful mountain setting.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1992
Region
Mountain
# of Stories
Single Story
Price Per Square Foot
$261
Price Per Acre
$188,889
Days On London
0
Cumulative Days On London
0
County
Madera
Leased Equipment
Solar Panels
REO / Bank Owned
No
Cross Street Address
Hwy 49
Directions
Highway 49, left onto Road 619, right onto Lulang Ln
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Kitchen
Electric Appliances, Dishwasher, Microwave, Eating Area, Refrigerator
Dining Room Features
Family Room/Area
Primary Bedroom Level
Main
Extra Rooms
Converted Garage
Flooring
Carpet, Tile, Vinyl
Exterior
Wood
Pool
No
Pool
No
Spa
No
Patio Features
Covered, Concrete
Yard
Fenced
Gas & Electric
Public Utilities, Propane
Sewer / Water
Public Water, Septic Tank
Energy Efficiency
Dual Pane Windows
Solar
Yes
Solar Type
Lease
Are there garage spaces?
No
APN
055 072 020 000
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Wasuma
School Type 3
Grade School
School Name 3
Wasuma
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)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1376 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1876 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` = 1689913 OR `props-main`.`id` = 1719081 OR `props-main`.`id` = 1719036 OR `props-main`.`id` = 1725507 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` = 1686974 OR `props-main`.`id` = 1686922 OR `props-main`.`id` = 1731636 OR `props-main`.`id` = 1748665 OR `props-main`.`id` = 1748616 OR `props-main`.`id` = 1742456 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` = 1705691 OR `props-main`.`id` = 1706718 OR `props-main`.`id` = 1716004 OR `props-main`.`id` = 1714989)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno652125' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-15' 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 1 hour 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.
