A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 474905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 524895 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) >= 2388 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2888 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` = 1686833 OR `props-main`.`id` = 1686834 OR `props-main`.`id` = 1674716 OR `props-main`.`id` = 1655732 OR `props-main`.`id` = 1655741 OR `props-main`.`id` = 1685911 OR `props-main`.`id` = 1681610 OR `props-main`.`id` = 1655334 OR `props-main`.`id` = 1671944 OR `props-main`.`id` = 1683996 OR `props-main`.`id` = 1666082 OR `props-main`.`id` = 1685906 OR `props-main`.`id` = 1677614 OR `props-main`.`id` = 1666114 OR `props-main`.`id` = 1687596 OR `props-main`.`id` = 1681951 OR `props-main`.`id` = 1687593 OR `props-main`.`id` = 1687674 OR `props-main`.`id` = 1677984 OR `props-main`.`id` = 1677976 OR `props-main`.`id` = 1687095 OR `props-main`.`id` = 1687703 OR `props-main`.`id` = 1685276 OR `props-main`.`id` = 1689456 OR `props-main`.`id` = 1689452 OR `props-main`.`id` = 1678692 OR `props-main`.`id` = 1687690 OR `props-main`.`id` = 1687689 OR `props-main`.`id` = 1668732 OR `props-main`.`id` = 1668734 OR `props-main`.`id` = 1665952 OR `props-main`.`id` = 1683765 OR `props-main`.`id` = 1683758 OR `props-main`.`id` = 1687580 OR `props-main`.`id` = 1683170 OR `props-main`.`id` = 1686072 OR `props-main`.`id` = 1673519 OR `props-main`.`id` = 1674105 OR `props-main`.`id` = 1645467 OR `props-main`.`id` = 1645426 OR `props-main`.`id` = 1687545 OR `props-main`.`id` = 1665764 OR `props-main`.`id` = 1665914 OR `props-main`.`id` = 1665931 OR `props-main`.`id` = 1684120 OR `props-main`.`id` = 1687694 OR `props-main`.`id` = 1686832 OR `props-main`.`id` = 1652816 OR `props-main`.`id` = 1671972 OR `props-main`.`id` = 1666255 OR `props-main`.`id` = 1681315 OR `props-main`.`id` = 1687686 OR `props-main`.`id` = 1679114 OR `props-main`.`id` = 1663346 OR `props-main`.`id` = 1663343 OR `props-main`.`id` = 1662244 OR `props-main`.`id` = 1666398 OR `props-main`.`id` = 1666375 OR `props-main`.`id` = 1689623 OR `props-main`.`id` = 1689619 OR `props-main`.`id` = 1661856 OR `props-main`.`id` = 1651393 OR `props-main`.`id` = 1651359 OR `props-main`.`id` = 1687215 OR `props-main`.`id` = 1687249 OR `props-main`.`id` = 1656457 OR `props-main`.`id` = 1656435 OR `props-main`.`id` = 1677241 OR `props-main`.`id` = 1688936 OR `props-main`.`id` = 1684122 OR `props-main`.`id` = 1622991 OR `props-main`.`id` = 1687174 OR `props-main`.`id` = 1681930 OR `props-main`.`id` = 1681934 OR `props-main`.`id` = 1651395 OR `props-main`.`id` = 1685316 OR `props-main`.`id` = 1687693 OR `props-main`.`id` = 1663482 OR `props-main`.`id` = 1663458 OR `props-main`.`id` = 1687651 OR `props-main`.`id` = 1680366 OR `props-main`.`id` = 1671327 OR `props-main`.`id` = 1689125 OR `props-main`.`id` = 1641618 OR `props-main`.`id` = 1670842 OR `props-main`.`id` = 1688978 OR `props-main`.`id` = 1665717 OR `props-main`.`id` = 1684139 OR `props-main`.`id` = 1679171 OR `props-main`.`id` = 1679133 OR `props-main`.`id` = 1684130 OR `props-main`.`id` = 1684155 OR `props-main`.`id` = 1687535 OR `props-main`.`id` = 1687573 OR `props-main`.`id` = 1677672 OR `props-main`.`id` = 1686950 OR `props-main`.`id` = 1665915 OR `props-main`.`id` = 1684920 OR `props-main`.`id` = 1666289 OR `props-main`.`id` = 1641308 OR `props-main`.`id` = 1640381 OR `props-main`.`id` = 1683689 OR `props-main`.`id` = 1681332 OR `props-main`.`id` = 1681340 OR `props-main`.`id` = 1684936)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno623462' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-11' 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,800 active listings.
Courtesy of Patricia Escobar, London Properties, Ltd. Last modified 7 months ago Fresno MLS last checked for updates 39 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.
