A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 369550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 408450 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) >= 1388 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1888 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` = 1767641 OR `props-main`.`id` = 1755613 OR `props-main`.`id` = 1758991 OR `props-main`.`id` = 1752306 OR `props-main`.`id` = 1752333 OR `props-main`.`id` = 1745214 OR `props-main`.`id` = 1747642 OR `props-main`.`id` = 1752302 OR `props-main`.`id` = 1752305 OR `props-main`.`id` = 1773845 OR `props-main`.`id` = 1782964 OR `props-main`.`id` = 1782866 OR `props-main`.`id` = 1718806 OR `props-main`.`id` = 1773985 OR `props-main`.`id` = 1719359 OR `props-main`.`id` = 1748816 OR `props-main`.`id` = 1763288 OR `props-main`.`id` = 1782927 OR `props-main`.`id` = 1783219 OR `props-main`.`id` = 1750992 OR `props-main`.`id` = 1789701 OR `props-main`.`id` = 1783111 OR `props-main`.`id` = 1723324 OR `props-main`.`id` = 1787753 OR `props-main`.`id` = 1787749 OR `props-main`.`id` = 1789091 OR `props-main`.`id` = 1787766 OR `props-main`.`id` = 1777021 OR `props-main`.`id` = 1782884 OR `props-main`.`id` = 1695654 OR `props-main`.`id` = 1779540 OR `props-main`.`id` = 1782883 OR `props-main`.`id` = 1788044 OR `props-main`.`id` = 1790381 OR `props-main`.`id` = 1774999 OR `props-main`.`id` = 1779925 OR `props-main`.`id` = 1773141 OR `props-main`.`id` = 1743097 OR `props-main`.`id` = 1791965 OR `props-main`.`id` = 1778362 OR `props-main`.`id` = 1785237 OR `props-main`.`id` = 1783296 OR `props-main`.`id` = 1782953 OR `props-main`.`id` = 1725262 OR `props-main`.`id` = 1783191 OR `props-main`.`id` = 1698027 OR `props-main`.`id` = 1783188 OR `props-main`.`id` = 1784771 OR `props-main`.`id` = 1783189 OR `props-main`.`id` = 1760038 OR `props-main`.`id` = 1744565 OR `props-main`.`id` = 1723067 OR `props-main`.`id` = 1725194 OR `props-main`.`id` = 1763339 OR `props-main`.`id` = 1763250 OR `props-main`.`id` = 1782919 OR `props-main`.`id` = 1782893 OR `props-main`.`id` = 1732749 OR `props-main`.`id` = 1719132 OR `props-main`.`id` = 1791289 OR `props-main`.`id` = 1777746 OR `props-main`.`id` = 1767715 OR `props-main`.`id` = 1782966 OR `props-main`.`id` = 1771323 OR `props-main`.`id` = 1791428 OR `props-main`.`id` = 1791948 OR `props-main`.`id` = 1783392 OR `props-main`.`id` = 1779923 OR `props-main`.`id` = 1752340 OR `props-main`.`id` = 1748876 OR `props-main`.`id` = 1782928 OR `props-main`.`id` = 1783141 OR `props-main`.`id` = 1783206 OR `props-main`.`id` = 1687173 OR `props-main`.`id` = 1783335 OR `props-main`.`id` = 1782955 OR `props-main`.`id` = 1790648 OR `props-main`.`id` = 1788812 OR `props-main`.`id` = 1783057 OR `props-main`.`id` = 1783151 OR `props-main`.`id` = 1736891 OR `props-main`.`id` = 1736894 OR `props-main`.`id` = 1791368 OR `props-main`.`id` = 1782977 OR `props-main`.`id` = 1782910)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare244678' 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();
1
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$389,000
3
3
1,638
0.34
496 E Putnam
Porterville, CA 93257
Courtesy of Tricia Santy, Real Brokerage Technologies
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.
