Larry Schrimp559.281.4061larry@londonproperties.comEmail Agent
A:SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 332405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 367395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 963 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1463 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` = 1572894 OR `props-main`.`id` = 1584202 OR `props-main`.`id` = 1585620 OR `props-main`.`id` = 1585648 OR `props-main`.`id` = 1570851 OR `props-main`.`id` = 1590832 OR `props-main`.`id` = 1587080 OR `props-main`.`id` = 1589859 OR `props-main`.`id` = 1590225 OR `props-main`.`id` = 1580148 OR `props-main`.`id` = 1589298 OR `props-main`.`id` = 1589660 OR `props-main`.`id` = 1583260 OR `props-main`.`id` = 1584564 OR `props-main`.`id` = 1582920 OR `props-main`.`id` = 1589604 OR `props-main`.`id` = 1590719 OR `props-main`.`id` = 1589634 OR `props-main`.`id` = 1590836 OR `props-main`.`id` = 1584649 OR `props-main`.`id` = 1589008 OR `props-main`.`id` = 1575532 OR `props-main`.`id` = 1575544 OR `props-main`.`id` = 1575545 OR `props-main`.`id` = 1575531 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` = 1582241 OR `props-main`.`id` = 1591060 OR `props-main`.`id` = 1587791 OR `props-main`.`id` = 1590868 OR `props-main`.`id` = 1587893 OR `props-main`.`id` = 1587970 OR `props-main`.`id` = 1572856 OR `props-main`.`id` = 1584467 OR `props-main`.`id` = 1576985 OR `props-main`.`id` = 1576949 OR `props-main`.`id` = 1576906 OR `props-main`.`id` = 1576954 OR `props-main`.`id` = 1590286 OR `props-main`.`id` = 1590519 OR `props-main`.`id` = 1577238 OR `props-main`.`id` = 1587747 OR `props-main`.`id` = 1580909 OR `props-main`.`id` = 1586507 OR `props-main`.`id` = 1586721 OR `props-main`.`id` = 1586705 OR `props-main`.`id` = 1590469 OR `props-main`.`id` = 1587808 OR `props-main`.`id` = 1581689 OR `props-main`.`id` = 1583759 OR `props-main`.`id` = 1591016 OR `props-main`.`id` = 1587547 OR `props-main`.`id` = 1585687 OR `props-main`.`id` = 1584858 OR `props-main`.`id` = 1583577 OR `props-main`.`id` = 1588227 OR `props-main`.`id` = 1591198 OR `props-main`.`id` = 1589031 OR `props-main`.`id` = 1584127 OR `props-main`.`id` = 1589830 OR `props-main`.`id` = 1584162 OR `props-main`.`id` = 1583266 OR `props-main`.`id` = 1583234 OR `props-main`.`id` = 1583236 OR `props-main`.`id` = 1583228 OR `props-main`.`id` = 1586797 OR `props-main`.`id` = 1568106 OR `props-main`.`id` = 1587704 OR `props-main`.`id` = 1591066 OR `props-main`.`id` = 1590810 OR `props-main`.`id` = 1589081 OR `props-main`.`id` = 1577902 OR `props-main`.`id` = 1581998 OR `props-main`.`id` = 1585235 OR `props-main`.`id` = 1578518 OR `props-main`.`id` = 1576027 OR `props-main`.`id` = 1588424 OR `props-main`.`id` = 1585767 OR `props-main`.`id` = 1587302 OR `props-main`.`id` = 1588532 OR `props-main`.`id` = 1588939 OR `props-main`.`id` = 1589193 OR `props-main`.`id` = 1590073 OR `props-main`.`id` = 1585728 OR `props-main`.`id` = 1583387 OR `props-main`.`id` = 1589460 OR `props-main`.`id` = 1578897 OR `props-main`.`id` = 1589661 OR `props-main`.`id` = 1583738 OR `props-main`.`id` = 1589778 OR `props-main`.`id` = 1589761 OR `props-main`.`id` = 1591019 OR `props-main`.`id` = 1567302 OR `props-main`.`id` = 1572646 OR `props-main`.`id` = 1588133 OR `props-main`.`id` = 1578959 OR `props-main`.`id` = 1550394 OR `props-main`.`id` = 1588717 OR `props-main`.`id` = 1590109 OR `props-main`.`id` = 1591245 OR `props-main`.`id` = 1569528 OR `props-main`.`id` = 1581196 OR `props-main`.`id` = 1580670 OR `props-main`.`id` = 1590423 OR `props-main`.`id` = 1590426 OR `props-main`.`id` = 1590388 OR `props-main`.`id` = 161024 OR `props-main`.`id` = 1570159 OR `props-main`.`id` = 1572663 OR `props-main`.`id` = 1586625 OR `props-main`.`id` = 1586414 OR `props-main`.`id` = 1587766 OR `props-main`.`id` = 1577279 OR `props-main`.`id` = 1587652 OR `props-main`.`id` = 1590161 OR `props-main`.`id` = 1586127 OR `props-main`.`id` = 1590985 OR `props-main`.`id` = 1591324 OR `props-main`.`id` = 1574733 OR `props-main`.`id` = 1591024 OR `props-main`.`id` = 102280 OR `props-main`.`id` = 1581241 OR `props-main`.`id` = 1578004 OR `props-main`.`id` = 1582493 OR `props-main`.`id` = 1577803)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno611513' 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:
$354,900
3
2
1,284
0.19
2432 W Indianapolis Ave
Fresno, CA 93705
$350,000
3
2
1,282
0.19
444 W Cortland Ave
Fresno, CA 93705
$350,000
3
2
1,454
0.16
1642 W Robinson
Fresno, CA 93705
$345,000
3
2
1,456
0.19
1005 W Fedora Ave
Fresno, CA 93705
Courtesy of Gracelyn Martinez, Iron Key Real Estate Last modified 1 week ago Fresno MLS last checked for updates 55 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.