A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 360050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 397950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1346 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1846 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` = 1748490 OR `props-main`.`id` = 1748522 OR `props-main`.`id` = 1776777 OR `props-main`.`id` = 1776776 OR `props-main`.`id` = 1748543 OR `props-main`.`id` = 1776779 OR `props-main`.`id` = 1748707 OR `props-main`.`id` = 1776780 OR `props-main`.`id` = 1748751 OR `props-main`.`id` = 1776781 OR `props-main`.`id` = 1783292 OR `props-main`.`id` = 1768603 OR `props-main`.`id` = 1776129 OR `props-main`.`id` = 1726288 OR `props-main`.`id` = 1752871 OR `props-main`.`id` = 1773127 OR `props-main`.`id` = 1736924 OR `props-main`.`id` = 1791386 OR `props-main`.`id` = 1791387 OR `props-main`.`id` = 1746597 OR `props-main`.`id` = 1722679 OR `props-main`.`id` = 1769104 OR `props-main`.`id` = 1776287 OR `props-main`.`id` = 1715660 OR `props-main`.`id` = 1737344 OR `props-main`.`id` = 1788114 OR `props-main`.`id` = 1788130 OR `props-main`.`id` = 1770278 OR `props-main`.`id` = 1783398 OR `props-main`.`id` = 1768986 OR `props-main`.`id` = 1783294 OR `props-main`.`id` = 1791937 OR `props-main`.`id` = 1784983 OR `props-main`.`id` = 246307 OR `props-main`.`id` = 1790382 OR `props-main`.`id` = 1787827 OR `props-main`.`id` = 1748070 OR `props-main`.`id` = 1744129 OR `props-main`.`id` = 1757433 OR `props-main`.`id` = 1778384 OR `props-main`.`id` = 1727078 OR `props-main`.`id` = 1765527 OR `props-main`.`id` = 1765526 OR `props-main`.`id` = 1718983 OR `props-main`.`id` = 1757095 OR `props-main`.`id` = 1757434 OR `props-main`.`id` = 1782939 OR `props-main`.`id` = 1791299 OR `props-main`.`id` = 1788792 OR `props-main`.`id` = 1791193)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare244674' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-16' 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 12,400 active listings.
Courtesy of Vivian Swiney, Realty Concepts, Ltd. - 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.
