A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 389500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 430500 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) >= 1598 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2098 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` = 1685515 OR `props-main`.`id` = 1688400 OR `props-main`.`id` = 1688223 OR `props-main`.`id` = 1685971 OR `props-main`.`id` = 1686164 OR `props-main`.`id` = 1686689 OR `props-main`.`id` = 1685966 OR `props-main`.`id` = 1679973 OR `props-main`.`id` = 1678401 OR `props-main`.`id` = 1684582 OR `props-main`.`id` = 1688443 OR `props-main`.`id` = 1687088 OR `props-main`.`id` = 1688895 OR `props-main`.`id` = 1680183 OR `props-main`.`id` = 1680160 OR `props-main`.`id` = 1683660 OR `props-main`.`id` = 1685373 OR `props-main`.`id` = 1685364 OR `props-main`.`id` = 1685379 OR `props-main`.`id` = 1685442 OR `props-main`.`id` = 1685551 OR `props-main`.`id` = 1677474 OR `props-main`.`id` = 1668276 OR `props-main`.`id` = 1683101 OR `props-main`.`id` = 1684110 OR `props-main`.`id` = 1658789 OR `props-main`.`id` = 1677111 OR `props-main`.`id` = 1685238 OR `props-main`.`id` = 1677464 OR `props-main`.`id` = 1684082 OR `props-main`.`id` = 1684085 OR `props-main`.`id` = 1681168 OR `props-main`.`id` = 1679610 OR `props-main`.`id` = 1687414 OR `props-main`.`id` = 1671647 OR `props-main`.`id` = 1683585 OR `props-main`.`id` = 1683774 OR `props-main`.`id` = 1688494 OR `props-main`.`id` = 1660743 OR `props-main`.`id` = 1680321 OR `props-main`.`id` = 1689851 OR `props-main`.`id` = 1687903 OR `props-main`.`id` = 1662266 OR `props-main`.`id` = 1617483 OR `props-main`.`id` = 1648184 OR `props-main`.`id` = 1676419 OR `props-main`.`id` = 1679752 OR `props-main`.`id` = 1689766 OR `props-main`.`id` = 1686434 OR `props-main`.`id` = 1685622 OR `props-main`.`id` = 1681566 OR `props-main`.`id` = 1688649 OR `props-main`.`id` = 1650558 OR `props-main`.`id` = 1671574 OR `props-main`.`id` = 1667925 OR `props-main`.`id` = 1670946 OR `props-main`.`id` = 1658113 OR `props-main`.`id` = 1658112 OR `props-main`.`id` = 1686704 OR `props-main`.`id` = 1658114 OR `props-main`.`id` = 1675166 OR `props-main`.`id` = 1673908 OR `props-main`.`id` = 1688552 OR `props-main`.`id` = 1688473 OR `props-main`.`id` = 1685979 OR `props-main`.`id` = 1685529 OR `props-main`.`id` = 1688527 OR `props-main`.`id` = 1687309 OR `props-main`.`id` = 1686038 OR `props-main`.`id` = 1686106 OR `props-main`.`id` = 1686066 OR `props-main`.`id` = 1685884 OR `props-main`.`id` = 1668427 OR `props-main`.`id` = 1671874 OR `props-main`.`id` = 1689108 OR `props-main`.`id` = 1688190 OR `props-main`.`id` = 1678055 OR `props-main`.`id` = 1681548 OR `props-main`.`id` = 1653061 OR `props-main`.`id` = 1681547 OR `props-main`.`id` = 1688918 OR `props-main`.`id` = 1686934 OR `props-main`.`id` = 1681740 OR `props-main`.`id` = 1687117 OR `props-main`.`id` = 1656391 OR `props-main`.`id` = 1688841 OR `props-main`.`id` = 1683204 OR `props-main`.`id` = 1689200 OR `props-main`.`id` = 1688696 OR `props-main`.`id` = 1686738 OR `props-main`.`id` = 1648266 OR `props-main`.`id` = 1648401 OR `props-main`.`id` = 1685046 OR `props-main`.`id` = 1663396 OR `props-main`.`id` = 1650946 OR `props-main`.`id` = 1686195 OR `props-main`.`id` = 1687055 OR `props-main`.`id` = 1681833 OR `props-main`.`id` = 1681831 OR `props-main`.`id` = 1666495 OR `props-main`.`id` = 1676624 OR `props-main`.`id` = 1684201 OR `props-main`.`id` = 1684375 OR `props-main`.`id` = 1678981 OR `props-main`.`id` = 1689463 OR `props-main`.`id` = 1689661 OR `props-main`.`id` = 1688234 OR `props-main`.`id` = 1678002 OR `props-main`.`id` = 1664023 OR `props-main`.`id` = 1686608 OR `props-main`.`id` = 1679192 OR `props-main`.`id` = 1682081 OR `props-main`.`id` = 1674706 OR `props-main`.`id` = 1687160 OR `props-main`.`id` = 1689123 OR `props-main`.`id` = 1668864 OR `props-main`.`id` = 1670011 OR `props-main`.`id` = 1686287 OR `props-main`.`id` = 1686098 OR `props-main`.`id` = 1680191 OR `props-main`.`id` = 1657018 OR `props-main`.`id` = 1679483 OR `props-main`.`id` = 1652898 OR `props-main`.`id` = 1677934 OR `props-main`.`id` = 1677921 OR `props-main`.`id` = 1677924 OR `props-main`.`id` = 1677928 OR `props-main`.`id` = 1688937 OR `props-main`.`id` = 1688758 OR `props-main`.`id` = 1675071 OR `props-main`.`id` = 1674667 OR `props-main`.`id` = 1688949 OR `props-main`.`id` = 1688950 OR `props-main`.`id` = 929721 OR `props-main`.`id` = 1683993 OR `props-main`.`id` = 1686314 OR `props-main`.`id` = 1664698 OR `props-main`.`id` = 1687864 OR `props-main`.`id` = 1687853 OR `props-main`.`id` = 1687856 OR `props-main`.`id` = 1671529 OR `props-main`.`id` = 1671562 OR `props-main`.`id` = 1681742 OR `props-main`.`id` = 1681741 OR `props-main`.`id` = 1681403)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare234068' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-14' 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();
7
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$409,000
3
2
1,929
0.14
209 S Atwood Ct
Visalia, CA 93291
$399,000
4
2
1,776
0.21
2135 S Woodland St
Visalia, CA 93277
$399,000
3
2
1,668
0.22
3116 W Beech Ave
Visalia, CA 93277
$389,500
3
2
1,978
0.19
4523 W Evergreen Ct
Visalia, CA 93277
Courtesy of Amy Davis, London Properties - Kingsburg
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.
