A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 414190.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 457789.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1162 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1662 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` = 1636126 OR `props-main`.`id` = 1685407 OR `props-main`.`id` = 1681156 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1701322 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1693773 OR `props-main`.`id` = 1685455 OR `props-main`.`id` = 1701151 OR `props-main`.`id` = 1701489 OR `props-main`.`id` = 1691387 OR `props-main`.`id` = 1691413 OR `props-main`.`id` = 1701346 OR `props-main`.`id` = 1695805 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1685947 OR `props-main`.`id` = 1696570 OR `props-main`.`id` = 1699173 OR `props-main`.`id` = 1690107 OR `props-main`.`id` = 1696276 OR `props-main`.`id` = 1695631 OR `props-main`.`id` = 1693708 OR `props-main`.`id` = 168075 OR `props-main`.`id` = 1679313 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1697704 OR `props-main`.`id` = 1701508 OR `props-main`.`id` = 1701459 OR `props-main`.`id` = 1701437 OR `props-main`.`id` = 1701537 OR `props-main`.`id` = 1698913 OR `props-main`.`id` = 1701433 OR `props-main`.`id` = 1701434 OR `props-main`.`id` = 1701435 OR `props-main`.`id` = 1701535 OR `props-main`.`id` = 1701460 OR `props-main`.`id` = 1701461 OR `props-main`.`id` = 1701462 OR `props-main`.`id` = 1701536 OR `props-main`.`id` = 1701539 OR `props-main`.`id` = 1701436 OR `props-main`.`id` = 1701538 OR `props-main`.`id` = 1701439 OR `props-main`.`id` = 1701440 OR `props-main`.`id` = 1701438 OR `props-main`.`id` = 1693614 OR `props-main`.`id` = 1685068 OR `props-main`.`id` = 1701534 OR `props-main`.`id` = 1688989 OR `props-main`.`id` = 1697889 OR `props-main`.`id` = 1685980 OR `props-main`.`id` = 1701430 OR `props-main`.`id` = 1701431 OR `props-main`.`id` = 1701432 OR `props-main`.`id` = 1697082 OR `props-main`.`id` = 1697320 OR `props-main`.`id` = 1696286 OR `props-main`.`id` = 1685082 OR `props-main`.`id` = 1697347 OR `props-main`.`id` = 1699235 OR `props-main`.`id` = 1700153 OR `props-main`.`id` = 1677702 OR `props-main`.`id` = 1677889 OR `props-main`.`id` = 1689630 OR `props-main`.`id` = 1653256)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno639545' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-06' 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();
14
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$453,990
3
2.5
1,651
0.05
1486 Vintage Ln
Clovis, CA 93619
$435,990
3
2.5
1,412
0.05
1526 Redbrick Ln
Clovis, CA 93619
$435,990
3
2.5
1,412
0.05
1478 Redbrick Ln
Clovis, CA 93619
$435,990
3
2.5
1,412
0.05
1507 Redbrick Ln
Clovis, CA 93619
Courtesy of Doreen Davis, Wilson Homes, Inc. Last modified 2 weeks ago Fresno MLS last checked for updates 6 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.
