A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 342000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 378000 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) >= 1290 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1790 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` = 1682180 OR `props-main`.`id` = 1682191 OR `props-main`.`id` = 1687212 OR `props-main`.`id` = 1687213 OR `props-main`.`id` = 1687244 OR `props-main`.`id` = 1687245 OR `props-main`.`id` = 1687246 OR `props-main`.`id` = 1687255 OR `props-main`.`id` = 1687256 OR `props-main`.`id` = 1683661 OR `props-main`.`id` = 1688664 OR `props-main`.`id` = 1667587 OR `props-main`.`id` = 1664766 OR `props-main`.`id` = 1689496 OR `props-main`.`id` = 1688012 OR `props-main`.`id` = 1689498 OR `props-main`.`id` = 1662046 OR `props-main`.`id` = 1657276 OR `props-main`.`id` = 1683085 OR `props-main`.`id` = 1674596 OR `props-main`.`id` = 1686355 OR `props-main`.`id` = 1668439 OR `props-main`.`id` = 1668454 OR `props-main`.`id` = 1668433 OR `props-main`.`id` = 1668444 OR `props-main`.`id` = 1668943 OR `props-main`.`id` = 1688638 OR `props-main`.`id` = 1683329 OR `props-main`.`id` = 1676838 OR `props-main`.`id` = 1642940 OR `props-main`.`id` = 1644759 OR `props-main`.`id` = 1657138 OR `props-main`.`id` = 1677794 OR `props-main`.`id` = 1677800 OR `props-main`.`id` = 1677797 OR `props-main`.`id` = 1683205 OR `props-main`.`id` = 1685298 OR `props-main`.`id` = 1667477 OR `props-main`.`id` = 1686593 OR `props-main`.`id` = 1679624 OR `props-main`.`id` = 1689425 OR `props-main`.`id` = 1679881 OR `props-main`.`id` = 1686714 OR `props-main`.`id` = 1686713 OR `props-main`.`id` = 1675152 OR `props-main`.`id` = 1675155 OR `props-main`.`id` = 1681688 OR `props-main`.`id` = 1681689 OR `props-main`.`id` = 1685719 OR `props-main`.`id` = 1675154 OR `props-main`.`id` = 1675217 OR `props-main`.`id` = 1685720 OR `props-main`.`id` = 1683522 OR `props-main`.`id` = 1683663 OR `props-main`.`id` = 1612813 OR `props-main`.`id` = 1684013 OR `props-main`.`id` = 1684461 OR `props-main`.`id` = 1686360 OR `props-main`.`id` = 1627122 OR `props-main`.`id` = 1677676 OR `props-main`.`id` = 1657588 OR `props-main`.`id` = 1681076 OR `props-main`.`id` = 1657568 OR `props-main`.`id` = 1687097 OR `props-main`.`id` = 1683692 OR `props-main`.`id` = 1677493 OR `props-main`.`id` = 1686231 OR `props-main`.`id` = 1686230 OR `props-main`.`id` = 1686236 OR `props-main`.`id` = 1684519 OR `props-main`.`id` = 1683722 OR `props-main`.`id` = 1637597 OR `props-main`.`id` = 1681250 OR `props-main`.`id` = 1094176 OR `props-main`.`id` = 1676856 OR `props-main`.`id` = 1676897 OR `props-main`.`id` = 1688140 OR `props-main`.`id` = 1688152 OR `props-main`.`id` = 1688133 OR `props-main`.`id` = 1688139 OR `props-main`.`id` = 1688562 OR `props-main`.`id` = 1615610 OR `props-main`.`id` = 1614319 OR `props-main`.`id` = 1613643 OR `props-main`.`id` = 1685519 OR `props-main`.`id` = 1685528 OR `props-main`.`id` = 1688188 OR `props-main`.`id` = 1657694 OR `props-main`.`id` = 1674591 OR `props-main`.`id` = 1686674 OR `props-main`.`id` = 1685501 OR `props-main`.`id` = 1679737 OR `props-main`.`id` = 1689489 OR `props-main`.`id` = 1636871 OR `props-main`.`id` = 1688211 OR `props-main`.`id` = 1686898 OR `props-main`.`id` = 1686890 OR `props-main`.`id` = 1686908 OR `props-main`.`id` = 1689008 OR `props-main`.`id` = 1676324 OR `props-main`.`id` = 1688614 OR `props-main`.`id` = 1686882 OR `props-main`.`id` = 1688546 OR `props-main`.`id` = 1688559 OR `props-main`.`id` = 1684453 OR `props-main`.`id` = 1680768 OR `props-main`.`id` = 1688539 OR `props-main`.`id` = 1680481 OR `props-main`.`id` = 1680496 OR `props-main`.`id` = 1688765 OR `props-main`.`id` = 1688755 OR `props-main`.`id` = 1688795 OR `props-main`.`id` = 1689010 OR `props-main`.`id` = 1673193 OR `props-main`.`id` = 1658281 OR `props-main`.`id` = 1649972 OR `props-main`.`id` = 1686012 OR `props-main`.`id` = 1686009 OR `props-main`.`id` = 1680031 OR `props-main`.`id` = 1685164 OR `props-main`.`id` = 1680275 OR `props-main`.`id` = 1685942 OR `props-main`.`id` = 1684996 OR `props-main`.`id` = 1684097 OR `props-main`.`id` = 1684104 OR `props-main`.`id` = 1684098 OR `props-main`.`id` = 1684111 OR `props-main`.`id` = 1678533 OR `props-main`.`id` = 1678527 OR `props-main`.`id` = 1678528 OR `props-main`.`id` = 1678529 OR `props-main`.`id` = 1668628 OR `props-main`.`id` = 1673503 OR `props-main`.`id` = 1680247 OR `props-main`.`id` = 1668942 OR `props-main`.`id` = 1687914 OR `props-main`.`id` = 1684535 OR `props-main`.`id` = 1684598 OR `props-main`.`id` = 1689541 OR `props-main`.`id` = 1688835 OR `props-main`.`id` = 1688838 OR `props-main`.`id` = 1688307 OR `props-main`.`id` = 1688430 OR `props-main`.`id` = 1688513 OR `props-main`.`id` = 1684915 OR `props-main`.`id` = 1683885 OR `props-main`.`id` = 1656855 OR `props-main`.`id` = 1646535 OR `props-main`.`id` = 1646585)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsFR24148612' 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();
5
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$377,900
3
2
1,482
0.22
2234 Carter Way
Hanford, CA 93230
$350,000
3
2
1,370
0.08
2390 Chardonnay Pl
Hanford, CA 93230
$349,000
4
2
1,748
0.21
2094 2094 N Burl
Hanford, CA 93230
$347,000
3
2
1,556
0.20
2851 Julia Cir
Hanford, CA 93230
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.
