A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 323000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 357000 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) >= 1155 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1655 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` = 1643823 OR `props-main`.`id` = 1686772 OR `props-main`.`id` = 1686774 OR `props-main`.`id` = 1686785 OR `props-main`.`id` = 1688157 OR `props-main`.`id` = 1688180 OR `props-main`.`id` = 1688156 OR `props-main`.`id` = 1688158 OR `props-main`.`id` = 1690903 OR `props-main`.`id` = 1690098 OR `props-main`.`id` = 1684423 OR `props-main`.`id` = 1684402 OR `props-main`.`id` = 1684418 OR `props-main`.`id` = 1651828 OR `props-main`.`id` = 1651827 OR `props-main`.`id` = 1689732 OR `props-main`.`id` = 1688051 OR `props-main`.`id` = 1688046 OR `props-main`.`id` = 1688053 OR `props-main`.`id` = 1684605 OR `props-main`.`id` = 1684504 OR `props-main`.`id` = 1665598 OR `props-main`.`id` = 1691173 OR `props-main`.`id` = 1674858 OR `props-main`.`id` = 1631140 OR `props-main`.`id` = 1631142 OR `props-main`.`id` = 1660473 OR `props-main`.`id` = 1589173 OR `props-main`.`id` = 1690137 OR `props-main`.`id` = 1665600 OR `props-main`.`id` = 1647420 OR `props-main`.`id` = 1647419 OR `props-main`.`id` = 1647413 OR `props-main`.`id` = 1682989 OR `props-main`.`id` = 1682999 OR `props-main`.`id` = 1680927 OR `props-main`.`id` = 1681130 OR `props-main`.`id` = 1681125 OR `props-main`.`id` = 1681138 OR `props-main`.`id` = 1681142 OR `props-main`.`id` = 1680421 OR `props-main`.`id` = 1678840 OR `props-main`.`id` = 1678823 OR `props-main`.`id` = 1678827 OR `props-main`.`id` = 1685941 OR `props-main`.`id` = 1648496 OR `props-main`.`id` = 1686052 OR `props-main`.`id` = 1689923 OR `props-main`.`id` = 1672026 OR `props-main`.`id` = 1671982 OR `props-main`.`id` = 1688682 OR `props-main`.`id` = 1688709 OR `props-main`.`id` = 1690033 OR `props-main`.`id` = 1689871 OR `props-main`.`id` = 1686107 OR `props-main`.`id` = 1686100 OR `props-main`.`id` = 1686124 OR `props-main`.`id` = 1688167 OR `props-main`.`id` = 1678224 OR `props-main`.`id` = 1687325 OR `props-main`.`id` = 1690553 OR `props-main`.`id` = 1667694 OR `props-main`.`id` = 1671588 OR `props-main`.`id` = 1684939 OR `props-main`.`id` = 1684938 OR `props-main`.`id` = 1684947 OR `props-main`.`id` = 1687119 OR `props-main`.`id` = 1687285 OR `props-main`.`id` = 1684114 OR `props-main`.`id` = 1687138 OR `props-main`.`id` = 1690487 OR `props-main`.`id` = 1690777 OR `props-main`.`id` = 1691127 OR `props-main`.`id` = 1678655 OR `props-main`.`id` = 1651878)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno629102' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-27' 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();
2
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$350,000
3
2
1,442
0.18
1463 Cedar Ln
Lemoore, CA 93245
$340,000
3
2
1,476
0.17
108 W Deodar
Lemoore, CA 93245
Courtesy of Carolyn Collins, London Properties, Ltd. Last modified 6 months ago
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.
