Larry Schrimp559.281.4061larry@londonproperties.comEmail Agent
A:SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 559550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 618450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1915 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2415 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` = 1588897 OR `props-main`.`id` = 188254 OR `props-main`.`id` = 1586750 OR `props-main`.`id` = 1591026 OR `props-main`.`id` = 1588252 OR `props-main`.`id` = 1554217 OR `props-main`.`id` = 1589389 OR `props-main`.`id` = 1588874 OR `props-main`.`id` = 1586513 OR `props-main`.`id` = 1580928 OR `props-main`.`id` = 1581980 OR `props-main`.`id` = 1581895 OR `props-main`.`id` = 1581967 OR `props-main`.`id` = 1581972 OR `props-main`.`id` = 1589373 OR `props-main`.`id` = 1588135 OR `props-main`.`id` = 1588718 OR `props-main`.`id` = 1586482 OR `props-main`.`id` = 1577654 OR `props-main`.`id` = 1589483 OR `props-main`.`id` = 1571878 OR `props-main`.`id` = 1584197 OR `props-main`.`id` = 1585262 OR `props-main`.`id` = 1586570 OR `props-main`.`id` = 1586460 OR `props-main`.`id` = 1581366 OR `props-main`.`id` = 269824 OR `props-main`.`id` = 742025 OR `props-main`.`id` = 1586941 OR `props-main`.`id` = 1589258 OR `props-main`.`id` = 1585161 OR `props-main`.`id` = 1587350 OR `props-main`.`id` = 1584383 OR `props-main`.`id` = 1589912 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1588000 OR `props-main`.`id` = 1591017 OR `props-main`.`id` = 54055 OR `props-main`.`id` = 1589699 OR `props-main`.`id` = 1587745 OR `props-main`.`id` = 1580862 OR `props-main`.`id` = 1577949 OR `props-main`.`id` = 1588486 OR `props-main`.`id` = 1584044 OR `props-main`.`id` = 1587250 OR `props-main`.`id` = 1589810 OR `props-main`.`id` = 1585847 OR `props-main`.`id` = 1585513 OR `props-main`.`id` = 1583048 OR `props-main`.`id` = 1590833 OR `props-main`.`id` = 1579740 OR `props-main`.`id` = 1581687 OR `props-main`.`id` = 1589825 OR `props-main`.`id` = 1586464 OR `props-main`.`id` = 1586508 OR `props-main`.`id` = 1589374 OR `props-main`.`id` = 1578036 OR `props-main`.`id` = 1591253 OR `props-main`.`id` = 1588437 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1588408 OR `props-main`.`id` = 1590806 OR `props-main`.`id` = 1590133 OR `props-main`.`id` = 1590551 OR `props-main`.`id` = 1589971 OR `props-main`.`id` = 1580134 OR `props-main`.`id` = 1585949 OR `props-main`.`id` = 168075 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1588432 OR `props-main`.`id` = 1585002 OR `props-main`.`id` = 1585006 OR `props-main`.`id` = 1591144 OR `props-main`.`id` = 1590769 OR `props-main`.`id` = 1590735 OR `props-main`.`id` = 1582546 OR `props-main`.`id` = 1581826 OR `props-main`.`id` = 1581978 OR `props-main`.`id` = 1581798 OR `props-main`.`id` = 1591124 OR `props-main`.`id` = 1590951 OR `props-main`.`id` = 1581193 OR `props-main`.`id` = 1590870 OR `props-main`.`id` = 1586052 OR `props-main`.`id` = 1590092 OR `props-main`.`id` = 1580173 OR `props-main`.`id` = 1588851 OR `props-main`.`id` = 1582090 OR `props-main`.`id` = 1588362 OR `props-main`.`id` = 1589487 OR `props-main`.`id` = 1589351 OR `props-main`.`id` = 226899 OR `props-main`.`id` = 1590275 OR `props-main`.`id` = 1584756 OR `props-main`.`id` = 1588752 OR `props-main`.`id` = 1589656 OR `props-main`.`id` = 1590761 OR `props-main`.`id` = 1588294 OR `props-main`.`id` = 1587053 OR `props-main`.`id` = 1556348 OR `props-main`.`id` = 717214 OR `props-main`.`id` = 1586794 OR `props-main`.`id` = 1590776 OR `props-main`.`id` = 1586447 OR `props-main`.`id` = 1586999 OR `props-main`.`id` = 37606 OR `props-main`.`id` = 1588266 OR `props-main`.`id` = 1586275)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno611218' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2024-05-12' 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();
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$599,000
5
2.75
2,378
0.14
2258 E Ticonderoga Dr
Fresno, CA 93720
$580,000
5
3
2,398
0.22
252 N Terry Ave
Clovis, CA 93612
Courtesy of Christine Grooms, Real Broker Last modified 2 weeks ago Fresno MLS last checked for updates 48 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.