Courtesy of Rogelio Guizar, Universal Realty Services, Inc. - [email protected]
Great Country Living at the nice Community Known as Yosemite Lakes Park, Come take a look at this nice Ranch style Home. The Home sits on an Acre and Just minutes from The local Market and Minutes from The Golf Course and restaurant. This Cute Home is Move in Ready has a Great open Floor plan and an Abundance of Space for Entertainment or Family Gatherings. This home offers 3 bedrooms and 2 baths, Dual pane windows and Central Heat and Air, all the modern Amenities. Call your Favorite Agent make YLP your Forever Home.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1980
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$242
Price Per Acre
$369,900
Days On London
0
Cumulative Days On London
0
County
Madera
Reports Available
Other HOA Documents
Leased Equipment
Propane
REO / Bank Owned
No
Cross Street Address
Yosemite Springs PKWY
Directions
Yosemite Springs Parkway to Crystal Cave West.
Unit Description
Ground Floor
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
In Garage
Roofing
Composition
Foundation
Concrete
Detached Structures
Shed
Kitchen
Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Eating Area
Pool, Spa, Club House, Tennis, Lake/Pond, Other/None
HOA Dues
78.00
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Coarsegold
School Type 3
Grade School
School Name 3
Coarsegold
Seller Will Consider
Government, Conventional, Cash
1st Loan Type
Free & Clear
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 351405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 388395 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) >= 1280 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1780 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` = 1726475 OR `props-main`.`id` = 1694180 OR `props-main`.`id` = 1715005 OR `props-main`.`id` = 1715000 OR `props-main`.`id` = 1726369 OR `props-main`.`id` = 1686833 OR `props-main`.`id` = 1728389 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` = 1719903 OR `props-main`.`id` = 1733186 OR `props-main`.`id` = 1687706 OR `props-main`.`id` = 1685636 OR `props-main`.`id` = 1731367 OR `props-main`.`id` = 1727867 OR `props-main`.`id` = 1727890 OR `props-main`.`id` = 1735505 OR `props-main`.`id` = 1726763 OR `props-main`.`id` = 1726776 OR `props-main`.`id` = 1731326 OR `props-main`.`id` = 1731414 OR `props-main`.`id` = 1701727 OR `props-main`.`id` = 1703501 OR `props-main`.`id` = 1727196 OR `props-main`.`id` = 1655334 OR `props-main`.`id` = 1731331 OR `props-main`.`id` = 1731471 OR `props-main`.`id` = 1731531 OR `props-main`.`id` = 1666180 OR `props-main`.`id` = 1704149 OR `props-main`.`id` = 1704013 OR `props-main`.`id` = 1625902 OR `props-main`.`id` = 1724833 OR `props-main`.`id` = 1726030 OR `props-main`.`id` = 1714763 OR `props-main`.`id` = 1725288 OR `props-main`.`id` = 1666082 OR `props-main`.`id` = 1729357 OR `props-main`.`id` = 1729449 OR `props-main`.`id` = 1687593 OR `props-main`.`id` = 1725990 OR `props-main`.`id` = 1721266 OR `props-main`.`id` = 1718871 OR `props-main`.`id` = 1700844 OR `props-main`.`id` = 1732169 OR `props-main`.`id` = 1718863 OR `props-main`.`id` = 1733220 OR `props-main`.`id` = 1733238 OR `props-main`.`id` = 1718510 OR `props-main`.`id` = 1718429 OR `props-main`.`id` = 1718458 OR `props-main`.`id` = 1700853 OR `props-main`.`id` = 1726153 OR `props-main`.`id` = 1731407 OR `props-main`.`id` = 1731450 OR `props-main`.`id` = 1687690 OR `props-main`.`id` = 1705132 OR `props-main`.`id` = 1726219 OR `props-main`.`id` = 1735425 OR `props-main`.`id` = 1725196 OR `props-main`.`id` = 1705139 OR `props-main`.`id` = 1703905 OR `props-main`.`id` = 1703925 OR `props-main`.`id` = 1717940 OR `props-main`.`id` = 1712355 OR `props-main`.`id` = 1712541 OR `props-main`.`id` = 1731483 OR `props-main`.`id` = 1722725 OR `props-main`.`id` = 1722836 OR `props-main`.`id` = 1722396 OR `props-main`.`id` = 1731676 OR `props-main`.`id` = 1725475 OR `props-main`.`id` = 1725481 OR `props-main`.`id` = 1689800 OR `props-main`.`id` = 1729575 OR `props-main`.`id` = 1720964 OR `props-main`.`id` = 1720988 OR `props-main`.`id` = 1716191 OR `props-main`.`id` = 1716166 OR `props-main`.`id` = 1728398 OR `props-main`.`id` = 1726519 OR `props-main`.`id` = 1704611 OR `props-main`.`id` = 1671972 OR `props-main`.`id` = 1666255 OR `props-main`.`id` = 1731334 OR `props-main`.`id` = 1727118)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno650183' 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 2 hours ago Fresno MLS last checked for updates 52 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.
