Larry Schrimp559.281.4061larry@londonproperties.comEmail Agent
A:SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 342000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 378000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1034 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1534 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` = 1587791 OR `props-main`.`id` = 1572855 OR `props-main`.`id` = 1587970 OR `props-main`.`id` = 1572856 OR `props-main`.`id` = 1586914 OR `props-main`.`id` = 1577238 OR `props-main`.`id` = 1587747 OR `props-main`.`id` = 1580909 OR `props-main`.`id` = 1587808 OR `props-main`.`id` = 1581689 OR `props-main`.`id` = 1585687 OR `props-main`.`id` = 1583577 OR `props-main`.`id` = 1587444 OR `props-main`.`id` = 1588227 OR `props-main`.`id` = 1589031 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` = 1568106 OR `props-main`.`id` = 1587704 OR `props-main`.`id` = 1579658 OR `props-main`.`id` = 1589081 OR `props-main`.`id` = 1577902 OR `props-main`.`id` = 1588403 OR `props-main`.`id` = 1588700 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` = 1585728 OR `props-main`.`id` = 1564509 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` = 1567302 OR `props-main`.`id` = 1532314 OR `props-main`.`id` = 1572646 OR `props-main`.`id` = 1588133 OR `props-main`.`id` = 1578959 OR `props-main`.`id` = 1589231 OR `props-main`.`id` = 1550394 OR `props-main`.`id` = 1588717 OR `props-main`.`id` = 1569528 OR `props-main`.`id` = 1586703 OR `props-main`.`id` = 1581196 OR `props-main`.`id` = 1571435 OR `props-main`.`id` = 1580670 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` = 1586127 OR `props-main`.`id` = 1574733 OR `props-main`.`id` = 102280 OR `props-main`.`id` = 1588103 OR `props-main`.`id` = 1587949 OR `props-main`.`id` = 1583383 OR `props-main`.`id` = 1588876 OR `props-main`.`id` = 1587464 OR `props-main`.`id` = 1581241 OR `props-main`.`id` = 1578004 OR `props-main`.`id` = 1582493 OR `props-main`.`id` = 1577803 OR `props-main`.`id` = 1579839 OR `props-main`.`id` = 1582047 OR `props-main`.`id` = 37604 OR `props-main`.`id` = 1585607 OR `props-main`.`id` = 1585888 OR `props-main`.`id` = 1585849 OR `props-main`.`id` = 1584299 OR `props-main`.`id` = 1589099 OR `props-main`.`id` = 1584042 OR `props-main`.`id` = 1587498 OR `props-main`.`id` = 1589807 OR `props-main`.`id` = 1586977 OR `props-main`.`id` = 1587167 OR `props-main`.`id` = 1589484 OR `props-main`.`id` = 1576349 OR `props-main`.`id` = 1587002)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno611109' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2024-05-03' 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:
$359,900
3
2
1,284
0.19
2432 W Indianapolis Ave
Fresno, CA 93705
$350,000
3
1.75
1,454
0.16
1642 W Robinson Ave
Fresno, CA 93705
$349,900
3
2
1,213
0.15
3982 N Woodson Ave
Fresno, CA 93705
$345,000
3
2
1,456
0.19
1005 W Fedora Ave
Fresno, CA 93705
Courtesy of Anneke Crew, Real Broker Last modified 2 weeks ago Fresno MLS last checked for updates 45 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.