A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 407550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 450450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1466 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1966 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` = 1741686 OR `props-main`.`id` = 1741476 OR `props-main`.`id` = 1741473 OR `props-main`.`id` = 1715683 OR `props-main`.`id` = 1723765 OR `props-main`.`id` = 1715674 OR `props-main`.`id` = 1743481 OR `props-main`.`id` = 1740790 OR `props-main`.`id` = 1751661 OR `props-main`.`id` = 1746603 OR `props-main`.`id` = 1724024 OR `props-main`.`id` = 1719879 OR `props-main`.`id` = 1749690 OR `props-main`.`id` = 1748350 OR `props-main`.`id` = 1719359 OR `props-main`.`id` = 1743981 OR `props-main`.`id` = 1751840 OR `props-main`.`id` = 1749496 OR `props-main`.`id` = 1719988 OR `props-main`.`id` = 1727490 OR `props-main`.`id` = 1737657 OR `props-main`.`id` = 1725819 OR `props-main`.`id` = 1750991 OR `props-main`.`id` = 1719363 OR `props-main`.`id` = 1751748 OR `props-main`.`id` = 1726363 OR `props-main`.`id` = 1737634 OR `props-main`.`id` = 1750558 OR `props-main`.`id` = 1720052 OR `props-main`.`id` = 1695654 OR `props-main`.`id` = 1745419 OR `props-main`.`id` = 1744545 OR `props-main`.`id` = 1737643 OR `props-main`.`id` = 1735547 OR `props-main`.`id` = 1747443 OR `props-main`.`id` = 1749057 OR `props-main`.`id` = 1736782 OR `props-main`.`id` = 1736980 OR `props-main`.`id` = 1751773 OR `props-main`.`id` = 1721490 OR `props-main`.`id` = 1737658 OR `props-main`.`id` = 1723373 OR `props-main`.`id` = 1673945 OR `props-main`.`id` = 1727281 OR `props-main`.`id` = 1748883 OR `props-main`.`id` = 1720077 OR `props-main`.`id` = 1725262 OR `props-main`.`id` = 1720203 OR `props-main`.`id` = 1719555 OR `props-main`.`id` = 1698027 OR `props-main`.`id` = 1719556 OR `props-main`.`id` = 1750729 OR `props-main`.`id` = 1737434 OR `props-main`.`id` = 1725194 OR `props-main`.`id` = 1744548 OR `props-main`.`id` = 1719985 OR `props-main`.`id` = 1719922 OR `props-main`.`id` = 1732395 OR `props-main`.`id` = 1750776 OR `props-main`.`id` = 1748218 OR `props-main`.`id` = 1746604 OR `props-main`.`id` = 1733289 OR `props-main`.`id` = 1742715 OR `props-main`.`id` = 1728699 OR `props-main`.`id` = 1719963 OR `props-main`.`id` = 1725621 OR `props-main`.`id` = 1725624 OR `props-main`.`id` = 1723215 OR `props-main`.`id` = 1720126 OR `props-main`.`id` = 1720053 OR `props-main`.`id` = 1751363 OR `props-main`.`id` = 1737648 OR `props-main`.`id` = 1748578 OR `props-main`.`id` = 1748562 OR `props-main`.`id` = 1736979 OR `props-main`.`id` = 1720259 OR `props-main`.`id` = 1721583 OR `props-main`.`id` = 1720016 OR `props-main`.`id` = 1728867 OR `props-main`.`id` = 1741741 OR `props-main`.`id` = 1747021 OR `props-main`.`id` = 1726904 OR `props-main`.`id` = 1747016 OR `props-main`.`id` = 1745590 OR `props-main`.`id` = 1709760 OR `props-main`.`id` = 1706869 OR `props-main`.`id` = 1721391 OR `props-main`.`id` = 1748354)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare243004' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-21' 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();
4
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$428,900
3
2
1,530
0.11
1534 S Conley St
Porterville, CA 93257
$425,000
3
2
1,530
0.13
493 W Richard Ave
Porterville, CA 93257
$420,000
4
2
1,619
0.14
1797 W Date Ave
Porterville, CA 93257
$415,000
4
2
1,760
0.16
283 S Parkwest St
Porterville, CA 93257
Courtesy of Quinn Atherton, Bloom Group, 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.
