A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 375250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 414750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1313 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1813 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` = 1701925 OR `props-main`.`id` = 507301 OR `props-main`.`id` = 1700849 OR `props-main`.`id` = 722218 OR `props-main`.`id` = 1697693 OR `props-main`.`id` = 1702170 OR `props-main`.`id` = 1698450 OR `props-main`.`id` = 1684412 OR `props-main`.`id` = 1685973 OR `props-main`.`id` = 1695754 OR `props-main`.`id` = 1698824 OR `props-main`.`id` = 1691881 OR `props-main`.`id` = 1697009 OR `props-main`.`id` = 1696540 OR `props-main`.`id` = 1641625 OR `props-main`.`id` = 1695567 OR `props-main`.`id` = 1695963 OR `props-main`.`id` = 1691098 OR `props-main`.`id` = 1695657 OR `props-main`.`id` = 1695663 OR `props-main`.`id` = 1691001 OR `props-main`.`id` = 1695582 OR `props-main`.`id` = 1701281 OR `props-main`.`id` = 1685922 OR `props-main`.`id` = 1679178 OR `props-main`.`id` = 1679179 OR `props-main`.`id` = 1695439 OR `props-main`.`id` = 1696732 OR `props-main`.`id` = 1696455 OR `props-main`.`id` = 1696213 OR `props-main`.`id` = 1696446 OR `props-main`.`id` = 1696456 OR `props-main`.`id` = 1696215 OR `props-main`.`id` = 1696447 OR `props-main`.`id` = 1696457 OR `props-main`.`id` = 1696448 OR `props-main`.`id` = 1696452 OR `props-main`.`id` = 1691849 OR `props-main`.`id` = 1691767 OR `props-main`.`id` = 1677679 OR `props-main`.`id` = 1701423 OR `props-main`.`id` = 86628 OR `props-main`.`id` = 1694761 OR `props-main`.`id` = 1702120 OR `props-main`.`id` = 1701174 OR `props-main`.`id` = 1686743 OR `props-main`.`id` = 1700126 OR `props-main`.`id` = 1694301 OR `props-main`.`id` = 1700906 OR `props-main`.`id` = 1690591 OR `props-main`.`id` = 1695772 OR `props-main`.`id` = 1700806 OR `props-main`.`id` = 1698713 OR `props-main`.`id` = 1676891 OR `props-main`.`id` = 1696806 OR `props-main`.`id` = 1701418 OR `props-main`.`id` = 1701668 OR `props-main`.`id` = 1701246 OR `props-main`.`id` = 37605 OR `props-main`.`id` = 1680814 OR `props-main`.`id` = 1698164 OR `props-main`.`id` = 1694857 OR `props-main`.`id` = 1697925 OR `props-main`.`id` = 1690540 OR `props-main`.`id` = 1701564 OR `props-main`.`id` = 1700060 OR `props-main`.`id` = 1692404 OR `props-main`.`id` = 1689450 OR `props-main`.`id` = 1702006 OR `props-main`.`id` = 1678175 OR `props-main`.`id` = 1689226 OR `props-main`.`id` = 1689290 OR `props-main`.`id` = 1667572 OR `props-main`.`id` = 1694690 OR `props-main`.`id` = 1674697 OR `props-main`.`id` = 1701172 OR `props-main`.`id` = 1649781 OR `props-main`.`id` = 1678114 OR `props-main`.`id` = 1700887 OR `props-main`.`id` = 1694030 OR `props-main`.`id` = 1680361 OR `props-main`.`id` = 1692325 OR `props-main`.`id` = 1696609 OR `props-main`.`id` = 1696606 OR `props-main`.`id` = 1698002 OR `props-main`.`id` = 1685930 OR `props-main`.`id` = 1698699 OR `props-main`.`id` = 1691561 OR `props-main`.`id` = 1695855 OR `props-main`.`id` = 1698811 OR `props-main`.`id` = 1697319 OR `props-main`.`id` = 1693812 OR `props-main`.`id` = 1694858 OR `props-main`.`id` = 1671754 OR `props-main`.`id` = 1654023 OR `props-main`.`id` = 1698844 OR `props-main`.`id` = 1651438 OR `props-main`.`id` = 1680103 OR `props-main`.`id` = 1701263 OR `props-main`.`id` = 1701260 OR `props-main`.`id` = 1702208 OR `props-main`.`id` = 1638016 OR `props-main`.`id` = 1702095 OR `props-main`.`id` = 1702242 OR `props-main`.`id` = 1701231 OR `props-main`.`id` = 1699980 OR `props-main`.`id` = 1696497 OR `props-main`.`id` = 1690978 OR `props-main`.`id` = 1660355 OR `props-main`.`id` = 1687083 OR `props-main`.`id` = 138928 OR `props-main`.`id` = 1691716 OR `props-main`.`id` = 235292 OR `props-main`.`id` = 241543 OR `props-main`.`id` = 971585 OR `props-main`.`id` = 1686274)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno637565' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-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();
4
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$409,900
4
2
1,448
0.14
552 W Rialto Ave
Clovis, CA 93612
$399,950
4
2
1,645
0.15
1427 Pierce Dr
Clovis, CA 93612
$389,900
4
3
1,655
0.19
2902 N 4Th St
Fresno, CA 93703
$389,000
4
2
1,590
0.17
3654 E Donner Ave
Fresno, CA 93726
Courtesy of Monica Ignorosa-Vasquez, Envision Realty, Inc. Last modified 2 months ago Fresno MLS last checked for updates 19 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.