A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 289750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 320250 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) >= 888 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1388 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` = 1715776 OR `props-main`.`id` = 1706024 OR `props-main`.`id` = 1714162 OR `props-main`.`id` = 1714478 OR `props-main`.`id` = 1702753 OR `props-main`.`id` = 1702723 OR `props-main`.`id` = 1702726 OR `props-main`.`id` = 1705411 OR `props-main`.`id` = 1705403 OR `props-main`.`id` = 1715997 OR `props-main`.`id` = 1696870 OR `props-main`.`id` = 1681986 OR `props-main`.`id` = 1687548 OR `props-main`.`id` = 1683655 OR `props-main`.`id` = 1718885 OR `props-main`.`id` = 1719540 OR `props-main`.`id` = 1702515 OR `props-main`.`id` = 1682011 OR `props-main`.`id` = 1714519 OR `props-main`.`id` = 1682055 OR `props-main`.`id` = 1715513 OR `props-main`.`id` = 1716534 OR `props-main`.`id` = 1715483 OR `props-main`.`id` = 1715484 OR `props-main`.`id` = 1713994 OR `props-main`.`id` = 1701748 OR `props-main`.`id` = 1714727)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno612957' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-02' 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:
$310,000
3
3
1,212
0.17
1950 Center Ave
Dos Palos, CA 93620
$300,000
3
2
1,127
0.15
1340 Bennett Ave
Dos Palos, CA 93620
$299,000
3
2
1,274
0.11
22146 6th St
South Dos Palos, CA 93620
Courtesy of Emily Derderian, SME Real Estate Last modified 1 year, 7 months ago Fresno MLS last checked for updates 54 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.
