A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 501118.35 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 553867.65 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2126 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2626 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` = 272957 OR `props-main`.`id` = 330635 OR `props-main`.`id` = 1666296 OR `props-main`.`id` = 1666083 OR `props-main`.`id` = 1665949 OR `props-main`.`id` = 1688926 OR `props-main`.`id` = 1688729 OR `props-main`.`id` = 1686356 OR `props-main`.`id` = 1689497 OR `props-main`.`id` = 1689537 OR `props-main`.`id` = 1688566 OR `props-main`.`id` = 1688738 OR `props-main`.`id` = 1685405 OR `props-main`.`id` = 1683685 OR `props-main`.`id` = 1689236 OR `props-main`.`id` = 1689670 OR `props-main`.`id` = 1685832 OR `props-main`.`id` = 1686411 OR `props-main`.`id` = 1687872 OR `props-main`.`id` = 1689048 OR `props-main`.`id` = 1686388 OR `props-main`.`id` = 1679836 OR `props-main`.`id` = 1684632 OR `props-main`.`id` = 1680200 OR `props-main`.`id` = 1684904 OR `props-main`.`id` = 1679864 OR `props-main`.`id` = 274621 OR `props-main`.`id` = 1673667 OR `props-main`.`id` = 1689235 OR `props-main`.`id` = 1690065 OR `props-main`.`id` = 849021 OR `props-main`.`id` = 1668911 OR `props-main`.`id` = 1687323 OR `props-main`.`id` = 1686203 OR `props-main`.`id` = 1670841 OR `props-main`.`id` = 1687510 OR `props-main`.`id` = 1683306 OR `props-main`.`id` = 1683282 OR `props-main`.`id` = 1665864 OR `props-main`.`id` = 1689896 OR `props-main`.`id` = 1636728 OR `props-main`.`id` = 1636687 OR `props-main`.`id` = 1666079 OR `props-main`.`id` = 1666475 OR `props-main`.`id` = 1676760 OR `props-main`.`id` = 656330 OR `props-main`.`id` = 1671669 OR `props-main`.`id` = 1683485 OR `props-main`.`id` = 1688602 OR `props-main`.`id` = 232981 OR `props-main`.`id` = 144625 OR `props-main`.`id` = 1680740 OR `props-main`.`id` = 1666292 OR `props-main`.`id` = 1689269 OR `props-main`.`id` = 1688626 OR `props-main`.`id` = 1688083 OR `props-main`.`id` = 1687939 OR `props-main`.`id` = 1685960 OR `props-main`.`id` = 1677619 OR `props-main`.`id` = 1679273 OR `props-main`.`id` = 1677279 OR `props-main`.`id` = 1685573 OR `props-main`.`id` = 1688567 OR `props-main`.`id` = 1688580 OR `props-main`.`id` = 1689644 OR `props-main`.`id` = 1689264)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno615104' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-16' 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();
2
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$525,000
4
2
2,188
0.20
4648 N Windward Way
Clovis, CA 93619
$514,995
4
3.5
2,245
0.11
3492 Hampton Way
Clovis, CA 93619
Courtesy of Theresa Mejia, KB Home Northern California Inc. Last modified 1 year, 3 months ago Fresno MLS last checked for updates 3 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.
