A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 375250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 414750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1262 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1762 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` = 1574826 OR `props-main`.`id` = 1689058 OR `props-main`.`id` = 1686759 OR `props-main`.`id` = 1688126 OR `props-main`.`id` = 1682088 OR `props-main`.`id` = 1680641 OR `props-main`.`id` = 1680630 OR `props-main`.`id` = 1685740 OR `props-main`.`id` = 1685741 OR `props-main`.`id` = 1676304 OR `props-main`.`id` = 1676311 OR `props-main`.`id` = 1650911 OR `props-main`.`id` = 1659420 OR `props-main`.`id` = 1680897 OR `props-main`.`id` = 1674955 OR `props-main`.`id` = 1674430 OR `props-main`.`id` = 1691079 OR `props-main`.`id` = 1690933 OR `props-main`.`id` = 1652851 OR `props-main`.`id` = 1683220 OR `props-main`.`id` = 1680213 OR `props-main`.`id` = 1673842 OR `props-main`.`id` = 1680120 OR `props-main`.`id` = 1656951 OR `props-main`.`id` = 1670995 OR `props-main`.`id` = 1684004 OR `props-main`.`id` = 1669671 OR `props-main`.`id` = 1671318 OR `props-main`.`id` = 1690223 OR `props-main`.`id` = 1690090 OR `props-main`.`id` = 1669691 OR `props-main`.`id` = 1690744 OR `props-main`.`id` = 1664689 OR `props-main`.`id` = 1671666 OR `props-main`.`id` = 1673629 OR `props-main`.`id` = 1689338 OR `props-main`.`id` = 1690952 OR `props-main`.`id` = 1689042 OR `props-main`.`id` = 1690954 OR `props-main`.`id` = 1690938 OR `props-main`.`id` = 1659435 OR `props-main`.`id` = 1690441 OR `props-main`.`id` = 1678329 OR `props-main`.`id` = 1661837 OR `props-main`.`id` = 1690267 OR `props-main`.`id` = 1679787 OR `props-main`.`id` = 1686394 OR `props-main`.`id` = 1687286 OR `props-main`.`id` = 1689893 OR `props-main`.`id` = 1687197 OR `props-main`.`id` = 1673127 OR `props-main`.`id` = 1684496 OR `props-main`.`id` = 1681799 OR `props-main`.`id` = 1684490 OR `props-main`.`id` = 1671535 OR `props-main`.`id` = 1671823 OR `props-main`.`id` = 1671802 OR `props-main`.`id` = 1683036 OR `props-main`.`id` = 1683548 OR `props-main`.`id` = 1663292 OR `props-main`.`id` = 1683733 OR `props-main`.`id` = 1673582 OR `props-main`.`id` = 1688271 OR `props-main`.`id` = 1684659 OR `props-main`.`id` = 1690351 OR `props-main`.`id` = 1669630 OR `props-main`.`id` = 1688462 OR `props-main`.`id` = 1690136 OR `props-main`.`id` = 1688445 OR `props-main`.`id` = 1678892 OR `props-main`.`id` = 1673738 OR `props-main`.`id` = 1685862 OR `props-main`.`id` = 1688690 OR `props-main`.`id` = 1658332 OR `props-main`.`id` = 1689731)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno616024' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-23' 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();
5
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$399,999
3
2.5
1,398
0.04
915 Winchell Way W
Madera, CA 93636
$399,900
3
2.5
1,512
0.04
157 Capstone Way S
Madera, CA 93636
$395,000
3
2.5
1,421
0.04
1109 Royalty Way W
Other, CA 93636
$390,000
3
2.5
1,579
0.05
933 Winchell Way W
Madera, CA 93636
Courtesy of Caprice Parry, Iron Key Real Estate Last modified 1 year, 2 months ago Fresno MLS last checked for updates 13 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.
