A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 408500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 451500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1719 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2219 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` = 1659455 OR `props-main`.`id` = 1678253 OR `props-main`.`id` = 1651828 OR `props-main`.`id` = 1651827 OR `props-main`.`id` = 1689732 OR `props-main`.`id` = 1684605 OR `props-main`.`id` = 1684504 OR `props-main`.`id` = 1665598 OR `props-main`.`id` = 1691173 OR `props-main`.`id` = 1631140 OR `props-main`.`id` = 1631142 OR `props-main`.`id` = 1660473 OR `props-main`.`id` = 1589173 OR `props-main`.`id` = 1690137 OR `props-main`.`id` = 1665600 OR `props-main`.`id` = 1647420 OR `props-main`.`id` = 1647419 OR `props-main`.`id` = 1647413 OR `props-main`.`id` = 1682989 OR `props-main`.`id` = 1682999 OR `props-main`.`id` = 1680421 OR `props-main`.`id` = 1678840 OR `props-main`.`id` = 1678823 OR `props-main`.`id` = 1678827 OR `props-main`.`id` = 1648496 OR `props-main`.`id` = 1686052 OR `props-main`.`id` = 1689923 OR `props-main`.`id` = 1672026 OR `props-main`.`id` = 1671982 OR `props-main`.`id` = 1688682 OR `props-main`.`id` = 1688709 OR `props-main`.`id` = 1690033 OR `props-main`.`id` = 1689871 OR `props-main`.`id` = 1686107 OR `props-main`.`id` = 1686100 OR `props-main`.`id` = 1686124 OR `props-main`.`id` = 1688167 OR `props-main`.`id` = 1678224 OR `props-main`.`id` = 1687325 OR `props-main`.`id` = 1690553 OR `props-main`.`id` = 1667694 OR `props-main`.`id` = 1671588 OR `props-main`.`id` = 1684939 OR `props-main`.`id` = 1684938 OR `props-main`.`id` = 1684947 OR `props-main`.`id` = 1687119 OR `props-main`.`id` = 1687285 OR `props-main`.`id` = 1684114 OR `props-main`.`id` = 1687138 OR `props-main`.`id` = 1690487 OR `props-main`.`id` = 1690777 OR `props-main`.`id` = 1691127)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings230193' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-26' 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 Debra White, Keller Williams Fresno
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.
