A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1282500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1417500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3903 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4403 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` = 1760981 OR `props-main`.`id` = 1774565 OR `props-main`.`id` = 1721479 OR `props-main`.`id` = 1785650 OR `props-main`.`id` = 1781408 OR `props-main`.`id` = 1777813 OR `props-main`.`id` = 1701497 OR `props-main`.`id` = 1773758 OR `props-main`.`id` = 1755155 OR `props-main`.`id` = 102873 OR `props-main`.`id` = 1725917 OR `props-main`.`id` = 1758156 OR `props-main`.`id` = 1784004 OR `props-main`.`id` = 1788837 OR `props-main`.`id` = 1764664 OR `props-main`.`id` = 1752225 OR `props-main`.`id` = 1786174 OR `props-main`.`id` = 1781514 OR `props-main`.`id` = 1779952 OR `props-main`.`id` = 1790171 OR `props-main`.`id` = 1789721 OR `props-main`.`id` = 1749676 OR `props-main`.`id` = 1726492 OR `props-main`.`id` = 1735331 OR `props-main`.`id` = 1781745 OR `props-main`.`id` = 1779970 OR `props-main`.`id` = 1758195 OR `props-main`.`id` = 1765274 OR `props-main`.`id` = 1765315 OR `props-main`.`id` = 1750746 OR `props-main`.`id` = 1768475 OR `props-main`.`id` = 1779075 OR `props-main`.`id` = 1748931 OR `props-main`.`id` = 1761824 OR `props-main`.`id` = 1761518 OR `props-main`.`id` = 1779560 OR `props-main`.`id` = 1747692 OR `props-main`.`id` = 1757547 OR `props-main`.`id` = 227897 OR `props-main`.`id` = 1789284 OR `props-main`.`id` = 1728553 OR `props-main`.`id` = 1733417 OR `props-main`.`id` = 1733470 OR `props-main`.`id` = 1779561 OR `props-main`.`id` = 1747382 OR `props-main`.`id` = 1747383 OR `props-main`.`id` = 1747380 OR `props-main`.`id` = 1771015 OR `props-main`.`id` = 1665744 OR `props-main`.`id` = 1665747 OR `props-main`.`id` = 1732200 OR `props-main`.`id` = 1766896 OR `props-main`.`id` = 1693768 OR `props-main`.`id` = 1689764 OR `props-main`.`id` = 1771968 OR `props-main`.`id` = 1744307 OR `props-main`.`id` = 1744308 OR `props-main`.`id` = 1744309 OR `props-main`.`id` = 1721548)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno647067' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-13' 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:
$1,399,900
5
4.5
3,951
0.17
11170 N Via Ravenna Dr
Fresno, CA 93730
$1,350,000
4
3.5
4,153
0.37
3386 E Via Monte Verdi Ave
Clovis, CA 93619
Last modified 2 months ago Fresno MLS last checked for updates 3 hours 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.
