A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 422655 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 467145 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1654 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2154 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` = 1671691 OR `props-main`.`id` = 1691351 OR `props-main`.`id` = 1657266 OR `props-main`.`id` = 1684940 OR `props-main`.`id` = 1691647 OR `props-main`.`id` = 1688454 OR `props-main`.`id` = 1648464 OR `props-main`.`id` = 1689458 OR `props-main`.`id` = 1689662 OR `props-main`.`id` = 1663985 OR `props-main`.`id` = 1683884 OR `props-main`.`id` = 1683994 OR `props-main`.`id` = 1632306 OR `props-main`.`id` = 1690113 OR `props-main`.`id` = 1690131 OR `props-main`.`id` = 1668447 OR `props-main`.`id` = 1673131 OR `props-main`.`id` = 1680492 OR `props-main`.`id` = 1687014 OR `props-main`.`id` = 1689737 OR `props-main`.`id` = 1691667 OR `props-main`.`id` = 1650662 OR `props-main`.`id` = 1650663 OR `props-main`.`id` = 1650657 OR `props-main`.`id` = 1650766 OR `props-main`.`id` = 1679196 OR `props-main`.`id` = 1684937 OR `props-main`.`id` = 1690013 OR `props-main`.`id` = 1648093 OR `props-main`.`id` = 1660586 OR `props-main`.`id` = 1660576 OR `props-main`.`id` = 1690044 OR `props-main`.`id` = 1680235 OR `props-main`.`id` = 1680319 OR `props-main`.`id` = 1680320 OR `props-main`.`id` = 1691654 OR `props-main`.`id` = 1691653 OR `props-main`.`id` = 1691658 OR `props-main`.`id` = 1691650 OR `props-main`.`id` = 1690634 OR `props-main`.`id` = 1691317 OR `props-main`.`id` = 1689713 OR `props-main`.`id` = 1688541 OR `props-main`.`id` = 1659352 OR `props-main`.`id` = 1689079 OR `props-main`.`id` = 1680789 OR `props-main`.`id` = 1679909 OR `props-main`.`id` = 1641233 OR `props-main`.`id` = 1679937 OR `props-main`.`id` = 1674209 OR `props-main`.`id` = 1689809 OR `props-main`.`id` = 1683373 OR `props-main`.`id` = 1679150 OR `props-main`.`id` = 1656407 OR `props-main`.`id` = 1690662 OR `props-main`.`id` = 1690664 OR `props-main`.`id` = 1615582 OR `props-main`.`id` = 1688033 OR `props-main`.`id` = 1688035 OR `props-main`.`id` = 1688037 OR `props-main`.`id` = 1688036 OR `props-main`.`id` = 1680674 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` = 1634648 OR `props-main`.`id` = 1664537 OR `props-main`.`id` = 1615347 OR `props-main`.`id` = 1678866 OR `props-main`.`id` = 1690967 OR `props-main`.`id` = 1691628 OR `props-main`.`id` = 1691643 OR `props-main`.`id` = 1690732 OR `props-main`.`id` = 1684901 OR `props-main`.`id` = 1684916 OR `props-main`.`id` = 1684921 OR `props-main`.`id` = 1691159 OR `props-main`.`id` = 1655595 OR `props-main`.`id` = 1686677 OR `props-main`.`id` = 1690047 OR `props-main`.`id` = 1691143 OR `props-main`.`id` = 1667884 OR `props-main`.`id` = 1668461 OR `props-main`.`id` = 1671652 OR `props-main`.`id` = 1681802 OR `props-main`.`id` = 1691197 OR `props-main`.`id` = 1689152 OR `props-main`.`id` = 1691244 OR `props-main`.`id` = 1691587 OR `props-main`.`id` = 1690981 OR `props-main`.`id` = 1691066 OR `props-main`.`id` = 1683895 OR `props-main`.`id` = 1691272 OR `props-main`.`id` = 1688205 OR `props-main`.`id` = 1681095 OR `props-main`.`id` = 1680655 OR `props-main`.`id` = 1691121 OR `props-main`.`id` = 1664044 OR `props-main`.`id` = 1687919 OR `props-main`.`id` = 1681847 OR `props-main`.`id` = 1690371 OR `props-main`.`id` = 1664760 OR `props-main`.`id` = 1674208 OR `props-main`.`id` = 1679033 OR `props-main`.`id` = 1679034 OR `props-main`.`id` = 1648164 OR `props-main`.`id` = 1689237 OR `props-main`.`id` = 1674891 OR `props-main`.`id` = 1688961 OR `props-main`.`id` = 1691245 OR `props-main`.`id` = 1648478 OR `props-main`.`id` = 1680333 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` = 1691209 OR `props-main`.`id` = 1659308 OR `props-main`.`id` = 1685845 OR `props-main`.`id` = 1689829 OR `props-main`.`id` = 1679773 OR `props-main`.`id` = 1689104 OR `props-main`.`id` = 1688092 OR `props-main`.`id` = 1689980 OR `props-main`.`id` = 1689213 OR `props-main`.`id` = 1690281 OR `props-main`.`id` = 1690626 OR `props-main`.`id` = 1690628 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` = 1689092 OR `props-main`.`id` = 1689078 OR `props-main`.`id` = 1684534 OR `props-main`.`id` = 1690011 OR `props-main`.`id` = 1670839 OR `props-main`.`id` = 1690580 OR `props-main`.`id` = 1690581 OR `props-main`.`id` = 1690583 OR `props-main`.`id` = 1648192 OR `props-main`.`id` = 1648399 OR `props-main`.`id` = 1689189 OR `props-main`.`id` = 1681874 OR `props-main`.`id` = 1688751 OR `props-main`.`id` = 1684022 OR `props-main`.`id` = 1690658 OR `props-main`.`id` = 1667824 OR `props-main`.`id` = 1691522 OR `props-main`.`id` = 1689957)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare230112' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-28' 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();
4
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$444,900
4
3
1,875
0.13
301 O\'Malley St #Mw133
Visalia, CA 93292
$435,000
4
3
1,842
0.13
1138 E Packwood Ave
Visalia, CA 93292
$430,000
4
2
1,870
0.17
2320 S Cotta St
Visalia, CA 93292
$429,900
4
2.5
1,862
0.16
2520 S Spruce St
Visalia, CA 93292
Courtesy of Concetto Sciacca, Century 21 Jordan-Link & Co.
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.
