London Properties, Ltd.559.436.4071Email Agentinfo@londonproperties.com
A:SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 274550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 303450 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) >= 1661 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2161 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` = 1573295 OR `props-main`.`id` = 1529092 OR `props-main`.`id` = 1566564 OR `props-main`.`id` = 1529462 OR `props-main`.`id` = 1569347 OR `props-main`.`id` = 1579861 OR `props-main`.`id` = 1578103 OR `props-main`.`id` = 1497594 OR `props-main`.`id` = 1582304 OR `props-main`.`id` = 1559395 OR `props-main`.`id` = 1570851 OR `props-main`.`id` = 1580148 OR `props-main`.`id` = 1580507 OR `props-main`.`id` = 1579816 OR `props-main`.`id` = 804394 OR `props-main`.`id` = 1578864 OR `props-main`.`id` = 1575532 OR `props-main`.`id` = 1575544 OR `props-main`.`id` = 1575545 OR `props-main`.`id` = 1575531 OR `props-main`.`id` = 160601 OR `props-main`.`id` = 1579366 OR `props-main`.`id` = 1579353 OR `props-main`.`id` = 1579359 OR `props-main`.`id` = 1579367 OR `props-main`.`id` = 1579361 OR `props-main`.`id` = 1580761 OR `props-main`.`id` = 1585274 OR `props-main`.`id` = 1578784 OR `props-main`.`id` = 1585277 OR `props-main`.`id` = 1572855 OR `props-main`.`id` = 1572856 OR `props-main`.`id` = 1569979 OR `props-main`.`id` = 1577238 OR `props-main`.`id` = 1580961 OR `props-main`.`id` = 985326 OR `props-main`.`id` = 249079 OR `props-main`.`id` = 1584127 OR `props-main`.`id` = 1568106 OR `props-main`.`id` = 1585483 OR `props-main`.`id` = 1579663 OR `props-main`.`id` = 230296 OR `props-main`.`id` = 858027 OR `props-main`.`id` = 1580853 OR `props-main`.`id` = 283623 OR `props-main`.`id` = 1585699 OR `props-main`.`id` = 1581820 OR `props-main`.`id` = 1581396 OR `props-main`.`id` = 1571809 OR `props-main`.`id` = 1583538 OR `props-main`.`id` = 1585659 OR `props-main`.`id` = 1582516 OR `props-main`.`id` = 1567534 OR `props-main`.`id` = 1584547 OR `props-main`.`id` = 1584565 OR `props-main`.`id` = 1569574)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno524878' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2024-04-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();
CAME_FROM_PROP_SITE:
We're sorry, this listing is no longer available. Please click here to search from over 7,600 active listings.
Courtesy of Cherie Lewis, Central Valley Home Services Last modified 4 years, 10 months ago Fresno MLS last checked for updates 35 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.
