Courtesy of Cherie Meyers, Thompson Real Estate Associates Corporation - [email protected]
Experience the best of country living in the sought after Yosemite Lakes Park community. This beautifully updated home offers comfort, versatility, and a serene settingideal for vacationing or year round living. A large shop with a loft adds tremendous value, providing space for storage, projects, or the opportunity to convert it into an ADU for added income or multigenerational living
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2006
Region
Mountain
# of Stories
Single Story
Price Per Square Foot
$252
Price Per Acre
$279,992
Days On London
0
Cumulative Days On London
0
County
Madera
REO / Bank Owned
No
Cross Street Address
Long Hollow Dr
Directions
Please google. Off HWY 41
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Composition
Foundation
Concrete
Detached Structures
Shop
Kitchen
Built In Range/Oven, Electric Appliances, Dishwasher, Pantry, Refrigerator
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
Flooring
Laminate, Tile
Exterior
Wood
Pool
Yes
Pool
Yes
Pool Type
In Ground
Patio Features
Covered
Gas & Electric
Public Utilities
Sewer / Water
Septic Tank, Community Well
Energy Efficiency
Dual Pane Windows
Solar
No
Parking Features
Existing RV Parking, Work/Shop Area
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
Site Amenities
Cul De Sac
APN
093 320 000 4
Association / Park Amenities
Club House
HOA Dues
200.00
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Grade School
School Name 2
Rivergold
School Type 3
Junior High School
School Name 3
Coarsegold
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 332490.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 367489.5 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) >= 1140 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1640 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` = 1717434 OR `props-main`.`id` = 1717601 OR `props-main`.`id` = 1717602 OR `props-main`.`id` = 1717603 OR `props-main`.`id` = 1717604 OR `props-main`.`id` = 1717605 OR `props-main`.`id` = 1716966 OR `props-main`.`id` = 1716595 OR `props-main`.`id` = 1719903 OR `props-main`.`id` = 1757614 OR `props-main`.`id` = 1747181 OR `props-main`.`id` = 1703501 OR `props-main`.`id` = 1754466 OR `props-main`.`id` = 1754469 OR `props-main`.`id` = 1776680 OR `props-main`.`id` = 1773357 OR `props-main`.`id` = 1666180 OR `props-main`.`id` = 1625902 OR `props-main`.`id` = 1775536 OR `props-main`.`id` = 1729357 OR `props-main`.`id` = 1729449 OR `props-main`.`id` = 1758457 OR `props-main`.`id` = 1758817 OR `props-main`.`id` = 1718863 OR `props-main`.`id` = 1713814 OR `props-main`.`id` = 1722852 OR `props-main`.`id` = 1724745 OR `props-main`.`id` = 1724749 OR `props-main`.`id` = 1762505 OR `props-main`.`id` = 1763249 OR `props-main`.`id` = 1746427 OR `props-main`.`id` = 1758250 OR `props-main`.`id` = 1735425 OR `props-main`.`id` = 1736539 OR `props-main`.`id` = 1736528 OR `props-main`.`id` = 1746407 OR `props-main`.`id` = 1666319 OR `props-main`.`id` = 1701326 OR `props-main`.`id` = 1687628 OR `props-main`.`id` = 1752936 OR `props-main`.`id` = 1752945 OR `props-main`.`id` = 1717940 OR `props-main`.`id` = 1727402 OR `props-main`.`id` = 1727475 OR `props-main`.`id` = 1722396 OR `props-main`.`id` = 1748357 OR `props-main`.`id` = 1747881 OR `props-main`.`id` = 1752138 OR `props-main`.`id` = 1742985 OR `props-main`.`id` = 91486 OR `props-main`.`id` = 1665857)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno655175' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-16' 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 3 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.
