A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 294500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 325500 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) >= 1150 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1650 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` = 1658791 OR `props-main`.`id` = 1659455 OR `props-main`.`id` = 1678253 OR `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` = 1684423 OR `props-main`.`id` = 1684402 OR `props-main`.`id` = 1684418 OR `props-main`.`id` = 1677490 OR `props-main`.`id` = 1651828 OR `props-main`.`id` = 1651827 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` = 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` = 1683487 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` = 1667908 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` = 1686310 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` = 1672026 OR `props-main`.`id` = 1671982 OR `props-main`.`id` = 1688682 OR `props-main`.`id` = 1688709 OR `props-main`.`id` = 1679184 OR `props-main`.`id` = 1686782 OR `props-main`.`id` = 1686788 OR `props-main`.`id` = 1686678 OR `props-main`.`id` = 1686169 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` = 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` = 1685433 OR `props-main`.`id` = 1684683)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno623772' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-11' 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();
3
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$315,000
3
2
1,392
0.17
83 W Deodar Ln
Lemoore, CA 93245
$315,000
4
2
1,250
0.19
840 Daphne Ln
Lemoore, CA 93245
$310,000
3
2
1,552
0.17
252 W Deodar Ln
Lemoore, CA 93245
Courtesy of Adriana Bourdeau, London Properties, Ltd. Last modified 8 months ago Fresno MLS last checked for updates 36 minutes 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.
