Bonus *** $1000 to agent for putting back into escrow fell out due to buyer and not the home! Inspections done and ready to roll ! Don't let this slip bysellers loss is your gain. Priced under market. Fully furnished if you'd like. One of the biggest and nicest homes in the subdivision. You don't want to miss this , call to take a look! Great Buy! Move in Ready 1525 sq ft 3/2 Cabin in the Pines! You will feel right at home when you walk in and imagine living in this great community. . Primary bedroom downstairs and two bedrooms upstairs, Large deck is great for entertaining as is the kitchen with all the counter space. Amenities include a newer wood stove shaped propane heater, laundry room in bathroom upstairs, newer laminate flooring, plenty of parking, shed for storage, and open living room/dining room. Meadow Lakes Pond is an easy walk and an awesome place to go hang out and fish,picnic, play on swing set, bbq, and horseshoe pits too! . Home is located within 20 min of Shaver Lake....close for those who enjoy snow skiing or sail boating at Huntington Lake. This home is fully beautifully furnished and ready for Airbnb or spoil yourself with the convenience of the furnishings already there !! What a huge BONUS pool table/dining table , couches, tv's, bedroom sets, washer/dryer, fully stocked kitchen with dishes etc , appliances, everything you need to literally just move in or spend your time in your amazing get away !
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 246905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 272895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1274 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1774 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` = 1732213 OR `props-main`.`id` = 1726635 OR `props-main`.`id` = 1691752 OR `props-main`.`id` = 1732952 OR `props-main`.`id` = 1733221 OR `props-main`.`id` = 1730243 OR `props-main`.`id` = 1727378 OR `props-main`.`id` = 1724971 OR `props-main`.`id` = 1730521 OR `props-main`.`id` = 1735330 OR `props-main`.`id` = 1704900 OR `props-main`.`id` = 1703450 OR `props-main`.`id` = 1731419 OR `props-main`.`id` = 1717351 OR `props-main`.`id` = 1717932 OR `props-main`.`id` = 1728199 OR `props-main`.`id` = 1717031 OR `props-main`.`id` = 1726249 OR `props-main`.`id` = 1721422 OR `props-main`.`id` = 1731595 OR `props-main`.`id` = 1665813 OR `props-main`.`id` = 1722447 OR `props-main`.`id` = 1722439 OR `props-main`.`id` = 1717934 OR `props-main`.`id` = 612485 OR `props-main`.`id` = 1727589)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno619500' 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();
1
Similar Properties
$259,000
3
1.75
1,426
0.34
41722 Merriman Ln
Auberry, CA 93602
Last modified 1 week ago Fresno MLS last checked for updates 27 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.
