A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 700625 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 774375 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2636 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3136 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` = 1649166 OR `props-main`.`id` = 1613936 OR `props-main`.`id` = 1643845 OR `props-main`.`id` = 1641110 OR `props-main`.`id` = 1650911 OR `props-main`.`id` = 1650925 OR `props-main`.`id` = 1646319 OR `props-main`.`id` = 1651095 OR `props-main`.`id` = 1640792 OR `props-main`.`id` = 1648820 OR `props-main`.`id` = 1652851 OR `props-main`.`id` = 1640891 OR `props-main`.`id` = 1613819 OR `props-main`.`id` = 1636971 OR `props-main`.`id` = 1652926 OR `props-main`.`id` = 1652977 OR `props-main`.`id` = 1646866 OR `props-main`.`id` = 1647229 OR `props-main`.`id` = 1640855 OR `props-main`.`id` = 1652450 OR `props-main`.`id` = 1640858 OR `props-main`.`id` = 1640854 OR `props-main`.`id` = 1649330 OR `props-main`.`id` = 1641283 OR `props-main`.`id` = 1635906 OR `props-main`.`id` = 1645884 OR `props-main`.`id` = 1633258 OR `props-main`.`id` = 1648576 OR `props-main`.`id` = 1645531 OR `props-main`.`id` = 1652478 OR `props-main`.`id` = 1645869 OR `props-main`.`id` = 1652728 OR `props-main`.`id` = 1637767 OR `props-main`.`id` = 1640599 OR `props-main`.`id` = 1640604 OR `props-main`.`id` = 1651049 OR `props-main`.`id` = 1639087 OR `props-main`.`id` = 1640921 OR `props-main`.`id` = 1613825 OR `props-main`.`id` = 1654331 OR `props-main`.`id` = 1634642 OR `props-main`.`id` = 1650545 OR `props-main`.`id` = 1649435 OR `props-main`.`id` = 1649378 OR `props-main`.`id` = 1646930 OR `props-main`.`id` = 1652639 OR `props-main`.`id` = 1649377 OR `props-main`.`id` = 1638317 OR `props-main`.`id` = 1649371 OR `props-main`.`id` = 1638330 OR `props-main`.`id` = 1631607 OR `props-main`.`id` = 1638132 OR `props-main`.`id` = 1644607 OR `props-main`.`id` = 1645593 OR `props-main`.`id` = 1654881 OR `props-main`.`id` = 1654711 OR `props-main`.`id` = 1654832 OR `props-main`.`id` = 1649889 OR `props-main`.`id` = 1649425 OR `props-main`.`id` = 1641543 OR `props-main`.`id` = 1651932 OR `props-main`.`id` = 1650475 OR `props-main`.`id` = 1652752 OR `props-main`.`id` = 1650741)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno611469' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-04-24' 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:
$765,000
4
3.5
3,100
0.15
974 Talus Way S
Madera, CA 93636
$714,500
4
3
2,652
0.15
934 Talus Way S
Madera, CA 93636
Courtesy of Laura Leffingwell, London Properties, Ltd. Last modified 11 months ago Fresno MLS last checked for updates 34 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.
