A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 388550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 429450 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) >= 1434 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1934 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` = 1689618 OR `props-main`.`id` = 1688708 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` = 1684096 OR `props-main`.`id` = 1684127 OR `props-main`.`id` = 1684151 OR `props-main`.`id` = 1684099 OR `props-main`.`id` = 1684134 OR `props-main`.`id` = 1667593 OR `props-main`.`id` = 1689272 OR `props-main`.`id` = 1627862 OR `props-main`.`id` = 1632242 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` = 1669910 OR `props-main`.`id` = 1622949 OR `props-main`.`id` = 1688313 OR `props-main`.`id` = 1681909 OR `props-main`.`id` = 1686587 OR `props-main`.`id` = 1685459 OR `props-main`.`id` = 1685460 OR `props-main`.`id` = 1689565 OR `props-main`.`id` = 1684733 OR `props-main`.`id` = 1684918 OR `props-main`.`id` = 1670944 OR `props-main`.`id` = 1664322 OR `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` = 1687273 OR `props-main`.`id` = 1687950 OR `props-main`.`id` = 1687955 OR `props-main`.`id` = 1687957 OR `props-main`.`id` = 1687982 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` = 1688584 OR `props-main`.`id` = 1688519 OR `props-main`.`id` = 1689240 OR `props-main`.`id` = 1675217 OR `props-main`.`id` = 1683522 OR `props-main`.`id` = 1683663 OR `props-main`.`id` = 1688055 OR `props-main`.`id` = 1657588 OR `props-main`.`id` = 1681076 OR `props-main`.`id` = 1657568 OR `props-main`.`id` = 1687097 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` = 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` = 1636871 OR `props-main`.`id` = 1688211 OR `props-main`.`id` = 1689008 OR `props-main`.`id` = 1676324 OR `props-main`.`id` = 1686882 OR `props-main`.`id` = 1684453 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` = 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` = 1687914 OR `props-main`.`id` = 1684535 OR `props-main`.`id` = 1684598 OR `props-main`.`id` = 1688307 OR `props-main`.`id` = 1688513)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno615410' 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();
8
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$425,000
3
2
1,715
0.13
2516 Cortner St
Hanford, CA 93230
$415,000
3
2
1,644
0.12
2533 W Claridge Way
Hanford, CA 93230
$394,000
3
2
1,809
0.20
1365 Muscat Ct
Hanford, CA 93230
$389,990
4
2
1,509
0.12
2241 81 BR Samuel St
Hanford, CA 93230
Courtesy of Ashley Lovrencevic, London Properties Last modified 1 year, 2 months ago Fresno MLS last checked for updates 39 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.
