Larry Schrimp559.281.4061larry@londonproperties.comEmail Agent
A:SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 94050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 103950 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) >= 1127 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1627 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` = 1557337 OR `props-main`.`id` = 1585859 OR `props-main`.`id` = 1577884 OR `props-main`.`id` = 1584405 OR `props-main`.`id` = 1580881 OR `props-main`.`id` = 1582616 OR `props-main`.`id` = 1586106 OR `props-main`.`id` = 1582028 OR `props-main`.`id` = 1581572 OR `props-main`.`id` = 1570979 OR `props-main`.`id` = 1566663 OR `props-main`.`id` = 1585032 OR `props-main`.`id` = 1585625 OR `props-main`.`id` = 1587001 OR `props-main`.`id` = 1586571 OR `props-main`.`id` = 1578830 OR `props-main`.`id` = 1578820 OR `props-main`.`id` = 1584067 OR `props-main`.`id` = 1580097 OR `props-main`.`id` = 1586974 OR `props-main`.`id` = 1587016 OR `props-main`.`id` = 1553762 OR `props-main`.`id` = 1572133 OR `props-main`.`id` = 1577761 OR `props-main`.`id` = 1572109 OR `props-main`.`id` = 1577760 OR `props-main`.`id` = 1579029 OR `props-main`.`id` = 1573390 OR `props-main`.`id` = 1582868 OR `props-main`.`id` = 1585278 OR `props-main`.`id` = 1585642 OR `props-main`.`id` = 1584225 OR `props-main`.`id` = 1585487 OR `props-main`.`id` = 1577508 OR `props-main`.`id` = 1586772 OR `props-main`.`id` = 1585517 OR `props-main`.`id` = 1583090 OR `props-main`.`id` = 1582019 OR `props-main`.`id` = 194016 OR `props-main`.`id` = 1576138 OR `props-main`.`id` = 1577860 OR `props-main`.`id` = 1577911 OR `props-main`.`id` = 1565536 OR `props-main`.`id` = 1583947 OR `props-main`.`id` = 1583601 OR `props-main`.`id` = 1584958 OR `props-main`.`id` = 1586084 OR `props-main`.`id` = 1583762 OR `props-main`.`id` = 1572891 OR `props-main`.`id` = 1577525 OR `props-main`.`id` = 1570715 OR `props-main`.`id` = 1576107 OR `props-main`.`id` = 1479802 OR `props-main`.`id` = 1586701 OR `props-main`.`id` = 1571557 OR `props-main`.`id` = 1578176 OR `props-main`.`id` = 1578179 OR `props-main`.`id` = 1578170 OR `props-main`.`id` = 1582511 OR `props-main`.`id` = 1576483 OR `props-main`.`id` = 1585697 OR `props-main`.`id` = 1585680 OR `props-main`.`id` = 1585685 OR `props-main`.`id` = 1585700 OR `props-main`.`id` = 1585682 OR `props-main`.`id` = 1586546 OR `props-main`.`id` = 1582654 OR `props-main`.`id` = 232302 OR `props-main`.`id` = 232595 OR `props-main`.`id` = 1585045 OR `props-main`.`id` = 1574941 OR `props-main`.`id` = 1574926 OR `props-main`.`id` = 1574938 OR `props-main`.`id` = 1574930 OR `props-main`.`id` = 1517159 OR `props-main`.`id` = 1574943 OR `props-main`.`id` = 1577907 OR `props-main`.`id` = 1587044 OR `props-main`.`id` = 1576502 OR `props-main`.`id` = 1576505 OR `props-main`.`id` = 1580792 OR `props-main`.`id` = 1583000 OR `props-main`.`id` = 228066 OR `props-main`.`id` = 1583381 OR `props-main`.`id` = 1584524 OR `props-main`.`id` = 1583377 OR `props-main`.`id` = 1586700 OR `props-main`.`id` = 1585899 OR `props-main`.`id` = 131234 OR `props-main`.`id` = 1586535 OR `props-main`.`id` = 1584974 OR `props-main`.`id` = 1584088 OR `props-main`.`id` = 1557982 OR `props-main`.`id` = 1578965 OR `props-main`.`id` = 1567940 OR `props-main`.`id` = 1578628 OR `props-main`.`id` = 1586425 OR `props-main`.`id` = 1584543 OR `props-main`.`id` = 1583669 OR `props-main`.`id` = 1583640 OR `props-main`.`id` = 1578924 OR `props-main`.`id` = 1585018 OR `props-main`.`id` = 1585024 OR `props-main`.`id` = 1584902 OR `props-main`.`id` = 1567503 OR `props-main`.`id` = 1586306 OR `props-main`.`id` = 1571197 OR `props-main`.`id` = 1557264 OR `props-main`.`id` = 1549059 OR `props-main`.`id` = 1562130 OR `props-main`.`id` = 1587036 OR `props-main`.`id` = 1584148 OR `props-main`.`id` = 1583092 OR `props-main`.`id` = 1584876 OR `props-main`.`id` = 1584807 OR `props-main`.`id` = 1572566 OR `props-main`.`id` = 1575625 OR `props-main`.`id` = 1583021 OR `props-main`.`id` = 1582986 OR `props-main`.`id` = 1587047 OR `props-main`.`id` = 1583091 OR `props-main`.`id` = 1580522 OR `props-main`.`id` = 52454 OR `props-main`.`id` = 361177 OR `props-main`.`id` = 282686 OR `props-main`.`id` = 1575279 OR `props-main`.`id` = 1566994 OR `props-main`.`id` = 1577960 OR `props-main`.`id` = 1585521 OR `props-main`.`id` = 1586673 OR `props-main`.`id` = 1582481 OR `props-main`.`id` = 1581348 OR `props-main`.`id` = 1581182 OR `props-main`.`id` = 1581174 OR `props-main`.`id` = 1562979 OR `props-main`.`id` = 1582672 OR `props-main`.`id` = 1583835 OR `props-main`.`id` = 1583842 OR `props-main`.`id` = 1585017 OR `props-main`.`id` = 1580493 OR `props-main`.`id` = 1570809 OR `props-main`.`id` = 1576696 OR `props-main`.`id` = 1585069 OR `props-main`.`id` = 1571560 OR `props-main`.`id` = 1587040 OR `props-main`.`id` = 1577246 OR `props-main`.`id` = 1581324 OR `props-main`.`id` = 1573932 OR `props-main`.`id` = 1585236 OR `props-main`.`id` = 1586743 OR `props-main`.`id` = 1584747 OR `props-main`.`id` = 1545174 OR `props-main`.`id` = 1544912 OR `props-main`.`id` = 1583205 OR `props-main`.`id` = 1585460 OR `props-main`.`id` = 1585458 OR `props-main`.`id` = 1538327 OR `props-main`.`id` = 1553968 OR `props-main`.`id` = 1555765 OR `props-main`.`id` = 1585133 OR `props-main`.`id` = 1569210 OR `props-main`.`id` = 1586383 OR `props-main`.`id` = 1575239 OR `props-main`.`id` = 1586382 OR `props-main`.`id` = 1578346 OR `props-main`.`id` = 1579688 OR `props-main`.`id` = 1586449 OR `props-main`.`id` = 1582154 OR `props-main`.`id` = 1570214 OR `props-main`.`id` = 1586121 OR `props-main`.`id` = 1584111 OR `props-main`.`id` = 1581772 OR `props-main`.`id` = 507301 OR `props-main`.`id` = 1586122 OR `props-main`.`id` = 1579162 OR `props-main`.`id` = 1585488 OR `props-main`.`id` = 1580985 OR `props-main`.`id` = 1585960 OR `props-main`.`id` = 722218 OR `props-main`.`id` = 1584176 OR `props-main`.`id` = 1560442)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno461542' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2024-04-20' 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,800 active listings.
Courtesy of Lawrence Schrimp, London Properties-Lender Servi Last modified 8 years ago Fresno MLS last checked for updates 16 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.