A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 354340.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 391639.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) >= 1165 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1665 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` = 1669702 OR `props-main`.`id` = 1679817 OR `props-main`.`id` = 1636285 OR `props-main`.`id` = 1614339 OR `props-main`.`id` = 1613599 OR `props-main`.`id` = 1685402 OR `props-main`.`id` = 1688779 OR `props-main`.`id` = 1679384 OR `props-main`.`id` = 1688781 OR `props-main`.`id` = 1659576 OR `props-main`.`id` = 1660339 OR `props-main`.`id` = 1687039 OR `props-main`.`id` = 1687037 OR `props-main`.`id` = 1687321 OR `props-main`.`id` = 1667648 OR `props-main`.`id` = 1687046 OR `props-main`.`id` = 1690728 OR `props-main`.`id` = 1668875 OR `props-main`.`id` = 1676228 OR `props-main`.`id` = 1689477 OR `props-main`.`id` = 1689476 OR `props-main`.`id` = 1690924 OR `props-main`.`id` = 1690955 OR `props-main`.`id` = 1688187 OR `props-main`.`id` = 1687940 OR `props-main`.`id` = 1689618 OR `props-main`.`id` = 1688708 OR `props-main`.`id` = 1680311 OR `props-main`.`id` = 1689114 OR `props-main`.`id` = 1690906 OR `props-main`.`id` = 1690901 OR `props-main`.`id` = 1690908 OR `props-main`.`id` = 1686941 OR `props-main`.`id` = 1689293 OR `props-main`.`id` = 1689106 OR `props-main`.`id` = 1689110 OR `props-main`.`id` = 1673823 OR `props-main`.`id` = 1667593 OR `props-main`.`id` = 1689937 OR `props-main`.`id` = 1689935 OR `props-main`.`id` = 1689272 OR `props-main`.`id` = 1627862 OR `props-main`.`id` = 1681546 OR `props-main`.`id` = 1571373 OR `props-main`.`id` = 1571371 OR `props-main`.`id` = 1686895 OR `props-main`.`id` = 1681814 OR `props-main`.`id` = 1688656 OR `props-main`.`id` = 1666685 OR `props-main`.`id` = 1677774 OR `props-main`.`id` = 1666686 OR `props-main`.`id` = 1677314 OR `props-main`.`id` = 1622949 OR `props-main`.`id` = 1688313 OR `props-main`.`id` = 1689565 OR `props-main`.`id` = 1687273 OR `props-main`.`id` = 1683661 OR `props-main`.`id` = 1688664)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare230038' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-22' 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:
$384,490
4
2
1,509
0.13
1187 85 BR S Magna Carta Ave
Hanford, CA 93230
$370,000
3
2
1,658
0.16
1426 Sidonia St
Hanford, CA 93230
$362,990
3
2
1,291
0.11
1842 W Twilight St
Hanford, CA 93230
Courtesy of Wesley Bennett, BMC Realty Advisors
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.
