A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 415150 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 458850 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) >= 1305 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1805 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` = 1667484 OR `props-main`.`id` = 1667579 OR `props-main`.`id` = 1686784 OR `props-main`.`id` = 1686792 OR `props-main`.`id` = 1685356 OR `props-main`.`id` = 1687547 OR `props-main`.`id` = 1677521 OR `props-main`.`id` = 1685286 OR `props-main`.`id` = 1685061 OR `props-main`.`id` = 1686201 OR `props-main`.`id` = 1687534 OR `props-main`.`id` = 1666298 OR `props-main`.`id` = 1685749 OR `props-main`.`id` = 1635838 OR `props-main`.`id` = 1635840 OR `props-main`.`id` = 1685734 OR `props-main`.`id` = 1669916 OR `props-main`.`id` = 1678407 OR `props-main`.`id` = 1687579 OR `props-main`.`id` = 1665912 OR `props-main`.`id` = 1676628 OR `props-main`.`id` = 1676642 OR `props-main`.`id` = 1662495 OR `props-main`.`id` = 1657428 OR `props-main`.`id` = 1657431 OR `props-main`.`id` = 1686031 OR `props-main`.`id` = 1685943 OR `props-main`.`id` = 1685921 OR `props-main`.`id` = 1682709 OR `props-main`.`id` = 1687261 OR `props-main`.`id` = 1637104 OR `props-main`.`id` = 1627751 OR `props-main`.`id` = 1627748 OR `props-main`.`id` = 1641529 OR `props-main`.`id` = 1641389 OR `props-main`.`id` = 1670965 OR `props-main`.`id` = 1666303 OR `props-main`.`id` = 1683736 OR `props-main`.`id` = 1662319 OR `props-main`.`id` = 1687624 OR `props-main`.`id` = 1679336 OR `props-main`.`id` = 1671544 OR `props-main`.`id` = 1671553 OR `props-main`.`id` = 1683721 OR `props-main`.`id` = 1654308 OR `props-main`.`id` = 1654365 OR `props-main`.`id` = 1584048 OR `props-main`.`id` = 1559272 OR `props-main`.`id` = 1686240 OR `props-main`.`id` = 230457)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno627571' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-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();
2
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$450,000
3
2
1,526
0.84
51338 Hillside
Oakhurst, CA 93644
$435,000
3
2
1,330
0.33
43149 W Sugar Pine Dr
Oakhurst, CA 93644
Courtesy of Katie Miller, London Properties, Ltd. Last modified 5 months ago Fresno MLS last checked for updates 18 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.
