A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 721999.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 797998.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2948 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3448 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` = 1671188 OR `props-main`.`id` = 1671191 OR `props-main`.`id` = 1671194 OR `props-main`.`id` = 1689136 OR `props-main`.`id` = 1674009 OR `props-main`.`id` = 1679396 OR `props-main`.`id` = 1658353 OR `props-main`.`id` = 1658160 OR `props-main`.`id` = 1666359 OR `props-main`.`id` = 1682676 OR `props-main`.`id` = 1687635 OR `props-main`.`id` = 1660410 OR `props-main`.`id` = 1674617 OR `props-main`.`id` = 1678377 OR `props-main`.`id` = 1687374 OR `props-main`.`id` = 1684488 OR `props-main`.`id` = 1674587 OR `props-main`.`id` = 1687295 OR `props-main`.`id` = 1669907 OR `props-main`.`id` = 1666047 OR `props-main`.`id` = 1657181 OR `props-main`.`id` = 1656886 OR `props-main`.`id` = 1657177 OR `props-main`.`id` = 1657184 OR `props-main`.`id` = 1657365 OR `props-main`.`id` = 1689582 OR `props-main`.`id` = 1668912 OR `props-main`.`id` = 1650126)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno616757' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-14' 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
CAME_FROM_PROP_SITE:
We're sorry, this listing is no longer available. Please click here to search from over 9,700 active listings.
Courtesy of Alexander Kington, Realty Concepts, Ltd. - Clovis Last modified 11 months ago Fresno MLS last checked for updates 1 minute 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.
