A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 344223 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 380457 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) >= 900 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1400 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` = 1720207 OR `props-main`.`id` = 1736781 OR `props-main`.`id` = 1737646 OR `props-main`.`id` = 1741723 OR `props-main`.`id` = 1741729 OR `props-main`.`id` = 1748836 OR `props-main`.`id` = 1704348 OR `props-main`.`id` = 1702918 OR `props-main`.`id` = 1702942 OR `props-main`.`id` = 1720107 OR `props-main`.`id` = 1722792 OR `props-main`.`id` = 1722805 OR `props-main`.`id` = 1727203 OR `props-main`.`id` = 1726130 OR `props-main`.`id` = 1726134 OR `props-main`.`id` = 1748865 OR `props-main`.`id` = 1737639 OR `props-main`.`id` = 1720252 OR `props-main`.`id` = 1746492 OR `props-main`.`id` = 1738135 OR `props-main`.`id` = 1751162 OR `props-main`.`id` = 1738480 OR `props-main`.`id` = 1748010 OR `props-main`.`id` = 1738481 OR `props-main`.`id` = 1738992 OR `props-main`.`id` = 1750564 OR `props-main`.`id` = 1738781 OR `props-main`.`id` = 1738791 OR `props-main`.`id` = 1709422 OR `props-main`.`id` = 1748895 OR `props-main`.`id` = 1736091 OR `props-main`.`id` = 1728805 OR `props-main`.`id` = 1743675 OR `props-main`.`id` = 1737929 OR `props-main`.`id` = 1615630 OR `props-main`.`id` = 1737884 OR `props-main`.`id` = 1720763)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare242965' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-18' 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:
$376,740
3
2
1,386
0.12
857 Westwood Ave
Lindsay, CA 93247
Courtesy of Jesus Barraza-Torres, T.C. James Homes
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.
