Courtesy of Leanne Shaw, Century 21 Select Real Estate - [email protected]
Spacious Mariposa Home on 6.8 Usable AcresClose to Town, Oakhurst & Yosemite!Welcome to this inviting 1,876 sq. ft. property offering comfort, functionality, and room to roam. Set on 6.8 acres of mostly usable land, this home is designed for easy living with an open floor plan, abundant windows, and beautiful natural light throughout.The standout feature is the expansive primary suite, complete with two separate bathrooms and a generous walk-through closeta rare and highly desirable layout. A guest bedroom and full bath sit on the opposite side of the home for privacy, while the additional den/bedroom offers the perfect space for a home office, guest room, or hobby area.Outside, includes an oversized detached garage with 18x8ft door with workshop space, an additional shop, and a large carport ideal for projects, storage, or extra vehicles. 50 yr.Roof less than 1 yr old, newer water heater, hvac and duct work, paint, window coverings and septic pumped. The acreage provides plenty of room for gardening, animals, or future improvements.
Property Type
Residential
Property Subtype 1
Single Family Residence
Property Subtype 2
Manufactured Home
Year Built
2005
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$213
Price Per Acre
$58,676
Days On London
157
Cumulative Days On London
157
County
Mariposa
Leased Equipment
Propane
Special Features
Isolated Bedroom, Built In Cabinets, Skylight, Horses Allowed
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 379050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 418950 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) >= 1626 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2126 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` = 1713543 OR `props-main`.`id` = 1731755 OR `props-main`.`id` = 1728611 OR `props-main`.`id` = 1728608 OR `props-main`.`id` = 1718709 OR `props-main`.`id` = 1721009 OR `props-main`.`id` = 1705200 OR `props-main`.`id` = 1704351 OR `props-main`.`id` = 1717576 OR `props-main`.`id` = 1731862 OR `props-main`.`id` = 1696421 OR `props-main`.`id` = 1724139 OR `props-main`.`id` = 1732157 OR `props-main`.`id` = 1681281 OR `props-main`.`id` = 1690236 OR `props-main`.`id` = 1690226 OR `props-main`.`id` = 1681568 OR `props-main`.`id` = 1705041 OR `props-main`.`id` = 1705205 OR `props-main`.`id` = 1734913)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno640543' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-09' 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 1 month ago Fresno MLS last checked for updates 22 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.
