A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 308750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 341250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 883 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1383 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` = 1697093 OR `props-main`.`id` = 1684204 OR `props-main`.`id` = 1688159 OR `props-main`.`id` = 1691637 OR `props-main`.`id` = 1697008 OR `props-main`.`id` = 1695472 OR `props-main`.`id` = 1688864 OR `props-main`.`id` = 1693913 OR `props-main`.`id` = 1695935 OR `props-main`.`id` = 1695617 OR `props-main`.`id` = 1698487 OR `props-main`.`id` = 1649222 OR `props-main`.`id` = 1666275 OR `props-main`.`id` = 1681870 OR `props-main`.`id` = 1681952 OR `props-main`.`id` = 1684697 OR `props-main`.`id` = 1692033 OR `props-main`.`id` = 1695398 OR `props-main`.`id` = 1696948 OR `props-main`.`id` = 1702562 OR `props-main`.`id` = 1702614 OR `props-main`.`id` = 1702558 OR `props-main`.`id` = 1681452 OR `props-main`.`id` = 1696068 OR `props-main`.`id` = 1689195 OR `props-main`.`id` = 1695682 OR `props-main`.`id` = 1702454 OR `props-main`.`id` = 1701212 OR `props-main`.`id` = 1687873 OR `props-main`.`id` = 1690749 OR `props-main`.`id` = 1689861 OR `props-main`.`id` = 1701925 OR `props-main`.`id` = 507301 OR `props-main`.`id` = 1698410 OR `props-main`.`id` = 1700849 OR `props-main`.`id` = 722218 OR `props-main`.`id` = 1697693 OR `props-main`.`id` = 1698450 OR `props-main`.`id` = 1684412 OR `props-main`.`id` = 1702246 OR `props-main`.`id` = 1695754 OR `props-main`.`id` = 1702760 OR `props-main`.`id` = 1696540 OR `props-main`.`id` = 1691098 OR `props-main`.`id` = 1695657 OR `props-main`.`id` = 1695663 OR `props-main`.`id` = 180610 OR `props-main`.`id` = 1695582 OR `props-main`.`id` = 1685922 OR `props-main`.`id` = 1679178 OR `props-main`.`id` = 1679179 OR `props-main`.`id` = 1695439 OR `props-main`.`id` = 1696732 OR `props-main`.`id` = 1696455 OR `props-main`.`id` = 1696213 OR `props-main`.`id` = 1696446 OR `props-main`.`id` = 1696456 OR `props-main`.`id` = 1696215 OR `props-main`.`id` = 1696447 OR `props-main`.`id` = 1696457 OR `props-main`.`id` = 1696448 OR `props-main`.`id` = 1696452 OR `props-main`.`id` = 1691767 OR `props-main`.`id` = 1702335 OR `props-main`.`id` = 86628 OR `props-main`.`id` = 1702120 OR `props-main`.`id` = 1701174 OR `props-main`.`id` = 1686743 OR `props-main`.`id` = 1700126 OR `props-main`.`id` = 1700906 OR `props-main`.`id` = 1690591 OR `props-main`.`id` = 1700806 OR `props-main`.`id` = 1698713 OR `props-main`.`id` = 1676891 OR `props-main`.`id` = 1701418 OR `props-main`.`id` = 1701668 OR `props-main`.`id` = 1702542 OR `props-main`.`id` = 1680814 OR `props-main`.`id` = 1697925 OR `props-main`.`id` = 1690540 OR `props-main`.`id` = 1692404 OR `props-main`.`id` = 1689450 OR `props-main`.`id` = 1678175 OR `props-main`.`id` = 1689290 OR `props-main`.`id` = 1667572 OR `props-main`.`id` = 1674697 OR `props-main`.`id` = 1701172)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno642040' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-15' 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();
3
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$315,000
3
1.75
1,242
0.15
3734 E Dakota Ave
Fresno, CA 93726
$315,000
3
1.75
1,226
0.19
4022 E Ashlan
Fresno, CA 93726
$309,998
3
1
1,000
0.17
4139 E Hedges Ave
Fresno, CA 93703
Courtesy of Don Scordino, Realty Concepts, Ltd. - Fresno Last modified 5 days ago Fresno MLS last checked for updates 6 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.
