A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 203300 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 224700 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1531 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2031 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` = 1685249 OR `props-main`.`id` = 1685239 OR `props-main`.`id` = 1685240 OR `props-main`.`id` = 1685244 OR `props-main`.`id` = 1688400 OR `props-main`.`id` = 1688223 OR `props-main`.`id` = 1678401 OR `props-main`.`id` = 1687402 OR `props-main`.`id` = 1657257 OR `props-main`.`id` = 1680183 OR `props-main`.`id` = 1680160 OR `props-main`.`id` = 1685442 OR `props-main`.`id` = 1685551 OR `props-main`.`id` = 1677474 OR `props-main`.`id` = 1692036 OR `props-main`.`id` = 1692035 OR `props-main`.`id` = 1683101 OR `props-main`.`id` = 1684110 OR `props-main`.`id` = 1658789 OR `props-main`.`id` = 1691780 OR `props-main`.`id` = 1689985 OR `props-main`.`id` = 1691143 OR `props-main`.`id` = 1677464 OR `props-main`.`id` = 1690503 OR `props-main`.`id` = 1679610 OR `props-main`.`id` = 1691892 OR `props-main`.`id` = 1671647 OR `props-main`.`id` = 1691546 OR `props-main`.`id` = 1683774 OR `props-main`.`id` = 1688494 OR `props-main`.`id` = 1680321 OR `props-main`.`id` = 1689851 OR `props-main`.`id` = 1687903 OR `props-main`.`id` = 1662266 OR `props-main`.`id` = 1691286 OR `props-main`.`id` = 1691949 OR `props-main`.`id` = 1617483 OR `props-main`.`id` = 1648184 OR `props-main`.`id` = 1676419 OR `props-main`.`id` = 1679752 OR `props-main`.`id` = 1689766 OR `props-main`.`id` = 1686434 OR `props-main`.`id` = 1685622 OR `props-main`.`id` = 1691899 OR `props-main`.`id` = 1691904 OR `props-main`.`id` = 1683895 OR `props-main`.`id` = 1681566 OR `props-main`.`id` = 1692071 OR `props-main`.`id` = 1650558 OR `props-main`.`id` = 1671574 OR `props-main`.`id` = 1667925 OR `props-main`.`id` = 1658113 OR `props-main`.`id` = 1658112 OR `props-main`.`id` = 1686704 OR `props-main`.`id` = 1658114 OR `props-main`.`id` = 1675166 OR `props-main`.`id` = 1690801 OR `props-main`.`id` = 1664044 OR `props-main`.`id` = 1688473 OR `props-main`.`id` = 1685529 OR `props-main`.`id` = 1688527 OR `props-main`.`id` = 1687309 OR `props-main`.`id` = 1686038 OR `props-main`.`id` = 1686106 OR `props-main`.`id` = 1686066 OR `props-main`.`id` = 1685884 OR `props-main`.`id` = 1668427 OR `props-main`.`id` = 1671874 OR `props-main`.`id` = 1692210 OR `props-main`.`id` = 1689108 OR `props-main`.`id` = 1688190 OR `props-main`.`id` = 1678055 OR `props-main`.`id` = 1648478 OR `props-main`.`id` = 1681548 OR `props-main`.`id` = 1690423 OR `props-main`.`id` = 1653061 OR `props-main`.`id` = 1688918 OR `props-main`.`id` = 1681740 OR `props-main`.`id` = 1687117 OR `props-main`.`id` = 1656391 OR `props-main`.`id` = 1688841 OR `props-main`.`id` = 1688092 OR `props-main`.`id` = 1690606 OR `props-main`.`id` = 1688696 OR `props-main`.`id` = 1691817 OR `props-main`.`id` = 1674235 OR `props-main`.`id` = 1686738 OR `props-main`.`id` = 1648266 OR `props-main`.`id` = 1691666 OR `props-main`.`id` = 1692288 OR `props-main`.`id` = 1663396 OR `props-main`.`id` = 1650946 OR `props-main`.`id` = 1686195 OR `props-main`.`id` = 1687055 OR `props-main`.`id` = 1681833 OR `props-main`.`id` = 1681831 OR `props-main`.`id` = 1690130 OR `props-main`.`id` = 1691067 OR `props-main`.`id` = 1666495 OR `props-main`.`id` = 1676624 OR `props-main`.`id` = 1684201 OR `props-main`.`id` = 1684375 OR `props-main`.`id` = 1689463 OR `props-main`.`id` = 1689661 OR `props-main`.`id` = 1678002 OR `props-main`.`id` = 1664023 OR `props-main`.`id` = 1692113 OR `props-main`.`id` = 1691458 OR `props-main`.`id` = 1679192 OR `props-main`.`id` = 1690845 OR `props-main`.`id` = 1674706 OR `props-main`.`id` = 1687160 OR `props-main`.`id` = 1689123 OR `props-main`.`id` = 1668864 OR `props-main`.`id` = 1691646 OR `props-main`.`id` = 1691649 OR `props-main`.`id` = 1691645 OR `props-main`.`id` = 1689917 OR `props-main`.`id` = 1686287 OR `props-main`.`id` = 1686098 OR `props-main`.`id` = 1680191 OR `props-main`.`id` = 1677934 OR `props-main`.`id` = 1677921 OR `props-main`.`id` = 1677924 OR `props-main`.`id` = 1677928 OR `props-main`.`id` = 1688937 OR `props-main`.`id` = 1690124 OR `props-main`.`id` = 1691257 OR `props-main`.`id` = 1691256 OR `props-main`.`id` = 1691270 OR `props-main`.`id` = 1688949 OR `props-main`.`id` = 1688950 OR `props-main`.`id` = 929721 OR `props-main`.`id` = 1686314 OR `props-main`.`id` = 1664698 OR `props-main`.`id` = 1690638 OR `props-main`.`id` = 1671529 OR `props-main`.`id` = 1671562 OR `props-main`.`id` = 1681742 OR `props-main`.`id` = 1681741)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno503949' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-01' 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 Preston Miller, Modern Broker, Inc Last modified 7 years ago Fresno MLS last checked for updates 4 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.