A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 344840.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 381139.5 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) >= 980 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1480 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` = 1716929 OR `props-main`.`id` = 1716910 OR `props-main`.`id` = 1717105 OR `props-main`.`id` = 1717659 OR `props-main`.`id` = 1717672 OR `props-main`.`id` = 1717453 OR `props-main`.`id` = 1717643 OR `props-main`.`id` = 1687940 OR `props-main`.`id` = 1719333 OR `props-main`.`id` = 1715631 OR `props-main`.`id` = 1716144 OR `props-main`.`id` = 1710013 OR `props-main`.`id` = 1718327 OR `props-main`.`id` = 1718335 OR `props-main`.`id` = 1718330 OR `props-main`.`id` = 1718344 OR `props-main`.`id` = 1717104 OR `props-main`.`id` = 1717116 OR `props-main`.`id` = 1705296 OR `props-main`.`id` = 1717957 OR `props-main`.`id` = 1717785 OR `props-main`.`id` = 1718418 OR `props-main`.`id` = 1718383 OR `props-main`.`id` = 1705459 OR `props-main`.`id` = 1702909 OR `props-main`.`id` = 1716139 OR `props-main`.`id` = 1701341 OR `props-main`.`id` = 1713884 OR `props-main`.`id` = 1703027 OR `props-main`.`id` = 1702012 OR `props-main`.`id` = 1702016 OR `props-main`.`id` = 1702021 OR `props-main`.`id` = 1712336 OR `props-main`.`id` = 1712367 OR `props-main`.`id` = 1713905 OR `props-main`.`id` = 1716730 OR `props-main`.`id` = 1716731 OR `props-main`.`id` = 1703694 OR `props-main`.`id` = 1712807 OR `props-main`.`id` = 1714894 OR `props-main`.`id` = 1712814 OR `props-main`.`id` = 1677314 OR `props-main`.`id` = 1622949 OR `props-main`.`id` = 1692171 OR `props-main`.`id` = 1713710 OR `props-main`.`id` = 1713974 OR `props-main`.`id` = 1713982 OR `props-main`.`id` = 1713971 OR `props-main`.`id` = 1710007 OR `props-main`.`id` = 1697920 OR `props-main`.`id` = 1702783 OR `props-main`.`id` = 1688012 OR `props-main`.`id` = 1704066 OR `props-main`.`id` = 1717395 OR `props-main`.`id` = 1717401 OR `props-main`.`id` = 1710025 OR `props-main`.`id` = 1709911 OR `props-main`.`id` = 1718070 OR `props-main`.`id` = 1718797 OR `props-main`.`id` = 1718796 OR `props-main`.`id` = 1718823 OR `props-main`.`id` = 1711371 OR `props-main`.`id` = 1702833 OR `props-main`.`id` = 1702845 OR `props-main`.`id` = 1709188 OR `props-main`.`id` = 1709193 OR `props-main`.`id` = 1713472 OR `props-main`.`id` = 1716841 OR `props-main`.`id` = 1716839 OR `props-main`.`id` = 1713704 OR `props-main`.`id` = 1705922 OR `props-main`.`id` = 1705925 OR `props-main`.`id` = 1708431 OR `props-main`.`id` = 1708433 OR `props-main`.`id` = 1717617 OR `props-main`.`id` = 1717980 OR `props-main`.`id` = 1718508 OR `props-main`.`id` = 1713386 OR `props-main`.`id` = 1696935 OR `props-main`.`id` = 1696934 OR `props-main`.`id` = 1094176 OR `props-main`.`id` = 1719330 OR `props-main`.`id` = 1719327 OR `props-main`.`id` = 1719328 OR `props-main`.`id` = 1718945 OR `props-main`.`id` = 1695753 OR `props-main`.`id` = 1715663 OR `props-main`.`id` = 1719073 OR `props-main`.`id` = 1718727 OR `props-main`.`id` = 1718975 OR `props-main`.`id` = 1718614 OR `props-main`.`id` = 1718980 OR `props-main`.`id` = 1718840 OR `props-main`.`id` = 1697745 OR `props-main`.`id` = 1716905 OR `props-main`.`id` = 1718120 OR `props-main`.`id` = 1718696 OR `props-main`.`id` = 1718695 OR `props-main`.`id` = 1698937 OR `props-main`.`id` = 1698938 OR `props-main`.`id` = 1708238 OR `props-main`.`id` = 1712572 OR `props-main`.`id` = 1712568 OR `props-main`.`id` = 1712626 OR `props-main`.`id` = 1716333 OR `props-main`.`id` = 1712621 OR `props-main`.`id` = 1711095 OR `props-main`.`id` = 1711081 OR `props-main`.`id` = 1711093 OR `props-main`.`id` = 1718235)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings233269' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-02' 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();
5
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$376,000
3
2
1,432
0.15
2141 W Hampton Dr
Hanford, CA 93230
$364,900
3
2
1,344
0.11
13713 Crocus Way
Armona, CA 93202
$354,000
3
2
1,187
0.18
1209 Neville St
Hanford, CA 93230
$350,000
3
2
1,344
0.11
10692 Daisy Way
Armona, CA 93202
Courtesy of Christian Perez, D.R. Horton CA3, 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.
