This exceptional, usable, fenced and cross fenced 5.57 acres offers the best of country living yet is under 25 minutes from Clovis off of Hwy 168. Paved roads and a paved driveway lead to a private paradise with 2 fenced pastures, fenced garden with water, fenced chicken coop, fire pit area and a very large barn. The barn/shop has a concrete floor and is finished with drywall, water, power and 2 roll up doors.The single story home boast a large open floor plan with the kitchen opening to a grand living room with it's high vaulted ceiling, picturesque windows and a wood stove and a huge dining area with bay windows to enjoy the abundance of property beauty. Three bedrooms occupy one side of the home with the fourth on the opposite side. The primary suite offers a sliding glass door onto the large inviting covered patio. The attached garage is very deep with high ceilings. Sitting on the covered back patio surrounded by beautiful landscaping and acreage will draw you in and you won't want to leave.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 560500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 619500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1780 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2280 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` = 1707166 OR `props-main`.`id` = 1705426 OR `props-main`.`id` = 1704706 OR `props-main`.`id` = 1704721 OR `props-main`.`id` = 1705728 OR `props-main`.`id` = 1720888 OR `props-main`.`id` = 1719163 OR `props-main`.`id` = 1723045 OR `props-main`.`id` = 1722640 OR `props-main`.`id` = 1722004 OR `props-main`.`id` = 1718996)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno647530' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-22' 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
Courtesy of Jeri Kuddes, Realty Concepts - Prather - [email protected] Last modified 2 hours ago Fresno MLS last checked for updates 45 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.
