A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 418000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 462000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1830 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2330 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` = 1686961 OR `props-main`.`id` = 1686967 OR `props-main`.`id` = 1689044 OR `props-main`.`id` = 1668447 OR `props-main`.`id` = 1660586 OR `props-main`.`id` = 1660576 OR `props-main`.`id` = 1680235 OR `props-main`.`id` = 1680319 OR `props-main`.`id` = 1680320 OR `props-main`.`id` = 1615248 OR `props-main`.`id` = 1659352 OR `props-main`.`id` = 1689079 OR `props-main`.`id` = 1648453 OR `props-main`.`id` = 1679909 OR `props-main`.`id` = 1641233 OR `props-main`.`id` = 1679937 OR `props-main`.`id` = 1674209 OR `props-main`.`id` = 1679150 OR `props-main`.`id` = 1688033 OR `props-main`.`id` = 1688035 OR `props-main`.`id` = 1688037 OR `props-main`.`id` = 1688036 OR `props-main`.`id` = 1687935 OR `props-main`.`id` = 1680187 OR `props-main`.`id` = 1688885 OR `props-main`.`id` = 1676697 OR `props-main`.`id` = 1688516 OR `props-main`.`id` = 1664537 OR `props-main`.`id` = 1615347 OR `props-main`.`id` = 1678866 OR `props-main`.`id` = 1684916 OR `props-main`.`id` = 1684921 OR `props-main`.`id` = 1655595 OR `props-main`.`id` = 1686677 OR `props-main`.`id` = 1690047 OR `props-main`.`id` = 1667884 OR `props-main`.`id` = 1668461 OR `props-main`.`id` = 1671652 OR `props-main`.`id` = 1689152 OR `props-main`.`id` = 1676308 OR `props-main`.`id` = 1676309 OR `props-main`.`id` = 1689620 OR `props-main`.`id` = 1680536 OR `props-main`.`id` = 1681095 OR `props-main`.`id` = 1687919 OR `props-main`.`id` = 1648379 OR `props-main`.`id` = 1674208 OR `props-main`.`id` = 1648164 OR `props-main`.`id` = 1689237 OR `props-main`.`id` = 1666211 OR `props-main`.`id` = 1680333 OR `props-main`.`id` = 1689899 OR `props-main`.`id` = 1680354 OR `props-main`.`id` = 1686253 OR `props-main`.`id` = 1677954 OR `props-main`.`id` = 1689696 OR `props-main`.`id` = 1668480 OR `props-main`.`id` = 1686251 OR `props-main`.`id` = 1679542 OR `props-main`.`id` = 1604069 OR `props-main`.`id` = 1679773 OR `props-main`.`id` = 1689980 OR `props-main`.`id` = 1685729 OR `props-main`.`id` = 1685820 OR `props-main`.`id` = 1685755 OR `props-main`.`id` = 1685759 OR `props-main`.`id` = 1674182 OR `props-main`.`id` = 1684534 OR `props-main`.`id` = 1670839 OR `props-main`.`id` = 1648192 OR `props-main`.`id` = 1681874 OR `props-main`.`id` = 1688751 OR `props-main`.`id` = 1684022 OR `props-main`.`id` = 1689959 OR `props-main`.`id` = 1667824 OR `props-main`.`id` = 1688866 OR `props-main`.`id` = 1688865 OR `props-main`.`id` = 1688873 OR `props-main`.`id` = 1688934 OR `props-main`.`id` = 1689957)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare222216' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-17' 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();
1
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$449,900
4
3
1,875
0.13
301 O\'Malley St #Mw133
Visalia, CA 93292
Courtesy of Kim McElhannon, Buy It Real Estate
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.
