A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 391400 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 432600 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1921 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2421 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` = 1656882 OR `props-main`.`id` = 1663936 OR `props-main`.`id` = 1629637 OR `props-main`.`id` = 1680050 OR `props-main`.`id` = 1674657 OR `props-main`.`id` = 1674658 OR `props-main`.`id` = 1678584 OR `props-main`.`id` = 1668487 OR `props-main`.`id` = 1687704 OR `props-main`.`id` = 1685400 OR `props-main`.`id` = 1685393 OR `props-main`.`id` = 1680274 OR `props-main`.`id` = 1691374 OR `props-main`.`id` = 1691376 OR `props-main`.`id` = 1691399 OR `props-main`.`id` = 1685946 OR `props-main`.`id` = 1675298 OR `props-main`.`id` = 1690268 OR `props-main`.`id` = 1690259 OR `props-main`.`id` = 1690256 OR `props-main`.`id` = 1613860 OR `props-main`.`id` = 1660727 OR `props-main`.`id` = 1673344 OR `props-main`.`id` = 1673362 OR `props-main`.`id` = 1673462 OR `props-main`.`id` = 1660914 OR `props-main`.`id` = 1660916 OR `props-main`.`id` = 1663293 OR `props-main`.`id` = 1687652 OR `props-main`.`id` = 1665996 OR `props-main`.`id` = 1666404 OR `props-main`.`id` = 1674211 OR `props-main`.`id` = 1674205 OR `props-main`.`id` = 1674201)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno611363' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-29' 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,600 active listings.
Courtesy of Billy Lovewell, eXp Realty of California, Inc. Last modified 1 year, 1 month ago Fresno MLS last checked for updates 8 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.
