A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 451244.3 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 498743.7 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) >= 1878 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2378 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` = 1700873 OR `props-main`.`id` = 1648426 OR `props-main`.`id` = 1666076 OR `props-main`.`id` = 1690493 OR `props-main`.`id` = 1701568 OR `props-main`.`id` = 1701649 OR `props-main`.`id` = 1685735 OR `props-main`.`id` = 1685737 OR `props-main`.`id` = 1697271 OR `props-main`.`id` = 1697251 OR `props-main`.`id` = 1698646 OR `props-main`.`id` = 1696619 OR `props-main`.`id` = 1697211 OR `props-main`.`id` = 1645564 OR `props-main`.`id` = 1700953 OR `props-main`.`id` = 1698540 OR `props-main`.`id` = 1698615 OR `props-main`.`id` = 1701566 OR `props-main`.`id` = 1701565 OR `props-main`.`id` = 1681363 OR `props-main`.`id` = 1689869 OR `props-main`.`id` = 1698664 OR `props-main`.`id` = 1697323 OR `props-main`.`id` = 1698672 OR `props-main`.`id` = 1668131 OR `props-main`.`id` = 1693923 OR `props-main`.`id` = 1694492 OR `props-main`.`id` = 1666395 OR `props-main`.`id` = 1662429 OR `props-main`.`id` = 1700140 OR `props-main`.`id` = 246307 OR `props-main`.`id` = 1698749 OR `props-main`.`id` = 1700136 OR `props-main`.`id` = 1696368 OR `props-main`.`id` = 1685513 OR `props-main`.`id` = 1693919 OR `props-main`.`id` = 1685507 OR `props-main`.`id` = 1700087 OR `props-main`.`id` = 1698469 OR `props-main`.`id` = 1700100 OR `props-main`.`id` = 1700101 OR `props-main`.`id` = 1700102 OR `props-main`.`id` = 1700104 OR `props-main`.`id` = 1697284 OR `props-main`.`id` = 1691339 OR `props-main`.`id` = 1691366 OR `props-main`.`id` = 1691199 OR `props-main`.`id` = 1697827 OR `props-main`.`id` = 1676794 OR `props-main`.`id` = 1698575 OR `props-main`.`id` = 1672885)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare237653' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-07' 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 8,100 active listings.
Courtesy of John Bonadelle, Bonadelle Realty, Inc.
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.
