A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 313405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 346395 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) >= 883 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1383 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` = 1661842 OR `props-main`.`id` = 1683411 OR `props-main`.`id` = 1648133 OR `props-main`.`id` = 1674942 OR `props-main`.`id` = 1684879 OR `props-main`.`id` = 1673294 OR `props-main`.`id` = 1687936 OR `props-main`.`id` = 1688752 OR `props-main`.`id` = 1661989 OR `props-main`.`id` = 1689084 OR `props-main`.`id` = 1657464 OR `props-main`.`id` = 1683598 OR `props-main`.`id` = 1683665 OR `props-main`.`id` = 1685810 OR `props-main`.`id` = 1685040 OR `props-main`.`id` = 1684183 OR `props-main`.`id` = 1684182 OR `props-main`.`id` = 1685892 OR `props-main`.`id` = 1653069 OR `props-main`.`id` = 1653027 OR `props-main`.`id` = 1664357 OR `props-main`.`id` = 1673309 OR `props-main`.`id` = 1675167 OR `props-main`.`id` = 1664358 OR `props-main`.`id` = 1653056 OR `props-main`.`id` = 1549450 OR `props-main`.`id` = 1648185 OR `props-main`.`id` = 1616928 OR `props-main`.`id` = 1686753 OR `props-main`.`id` = 1676423 OR `props-main`.`id` = 1549555 OR `props-main`.`id` = 1684180 OR `props-main`.`id` = 1681202 OR `props-main`.`id` = 1673391 OR `props-main`.`id` = 1648449 OR `props-main`.`id` = 1687799 OR `props-main`.`id` = 1689428 OR `props-main`.`id` = 1674485 OR `props-main`.`id` = 1688980 OR `props-main`.`id` = 1686709 OR `props-main`.`id` = 1633263 OR `props-main`.`id` = 1688861 OR `props-main`.`id` = 1668883 OR `props-main`.`id` = 1659459 OR `props-main`.`id` = 1685760 OR `props-main`.`id` = 1685847 OR `props-main`.`id` = 1688454 OR `props-main`.`id` = 1688919 OR `props-main`.`id` = 1687000 OR `props-main`.`id` = 1688409 OR `props-main`.`id` = 1689276 OR `props-main`.`id` = 1686269 OR `props-main`.`id` = 1685515 OR `props-main`.`id` = 1685249 OR `props-main`.`id` = 1685239 OR `props-main`.`id` = 1685240 OR `props-main`.`id` = 1685244 OR `props-main`.`id` = 1686881 OR `props-main`.`id` = 1673880 OR `props-main`.`id` = 1651729 OR `props-main`.`id` = 1651784 OR `props-main`.`id` = 1677486 OR `props-main`.`id` = 1687014 OR `props-main`.`id` = 1681923 OR `props-main`.`id` = 1650662 OR `props-main`.`id` = 1650663 OR `props-main`.`id` = 1650657 OR `props-main`.`id` = 1688400 OR `props-main`.`id` = 1650766 OR `props-main`.`id` = 1679196 OR `props-main`.`id` = 1668543 OR `props-main`.`id` = 1688223 OR `props-main`.`id` = 1678401 OR `props-main`.`id` = 1684582 OR `props-main`.`id` = 1681625 OR `props-main`.`id` = 1688443 OR `props-main`.`id` = 1688541 OR `props-main`.`id` = 1687402 OR `props-main`.`id` = 1657257 OR `props-main`.`id` = 1686422 OR `props-main`.`id` = 1687088 OR `props-main`.`id` = 1688895 OR `props-main`.`id` = 1683373 OR `props-main`.`id` = 1680183 OR `props-main`.`id` = 1680160 OR `props-main`.`id` = 1679090 OR `props-main`.`id` = 1615582 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` = 1679252 OR `props-main`.`id` = 1676140 OR `props-main`.`id` = 1683101 OR `props-main`.`id` = 1684110 OR `props-main`.`id` = 1681391 OR `props-main`.`id` = 1658789 OR `props-main`.`id` = 1675128 OR `props-main`.`id` = 1684901 OR `props-main`.`id` = 1670915 OR `props-main`.`id` = 1677111 OR `props-main`.`id` = 1684780 OR `props-main`.`id` = 1685238 OR `props-main`.`id` = 1677464 OR `props-main`.`id` = 1684082 OR `props-main`.`id` = 1684085 OR `props-main`.`id` = 1681802 OR `props-main`.`id` = 1681168 OR `props-main`.`id` = 1679610 OR `props-main`.`id` = 1687414 OR `props-main`.`id` = 1671647 OR `props-main`.`id` = 1676321 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` = 1687903 OR `props-main`.`id` = 1662266 OR `props-main`.`id` = 1617483 OR `props-main`.`id` = 1688514 OR `props-main`.`id` = 1648184 OR `props-main`.`id` = 1676419 OR `props-main`.`id` = 1679752 OR `props-main`.`id` = 1686434 OR `props-main`.`id` = 1685622 OR `props-main`.`id` = 1654787 OR `props-main`.`id` = 1654789 OR `props-main`.`id` = 1683895 OR `props-main`.`id` = 1687038 OR `props-main`.`id` = 1681566 OR `props-main`.`id` = 1646484 OR `props-main`.`id` = 1688649 OR `props-main`.`id` = 1688205 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` = 1680655 OR `props-main`.`id` = 1658114 OR `props-main`.`id` = 1675166 OR `props-main`.`id` = 1664044 OR `props-main`.`id` = 1673908 OR `props-main`.`id` = 1681847 OR `props-main`.`id` = 1685979 OR `props-main`.`id` = 1685529 OR `props-main`.`id` = 1687309 OR `props-main`.`id` = 1679033 OR `props-main`.`id` = 1679034 OR `props-main`.`id` = 1685387 OR `props-main`.`id` = 1685693 OR `props-main`.`id` = 1674891 OR `props-main`.`id` = 1688961 OR `props-main`.`id` = 1648473 OR `props-main`.`id` = 1686106 OR `props-main`.`id` = 1687918 OR `props-main`.`id` = 1688190 OR `props-main`.`id` = 1678055 OR `props-main`.`id` = 1648478 OR `props-main`.`id` = 1681548 OR `props-main`.`id` = 1681547 OR `props-main`.`id` = 1688918 OR `props-main`.`id` = 1686934 OR `props-main`.`id` = 1685845 OR `props-main`.`id` = 1687117 OR `props-main`.`id` = 1688841 OR `props-main`.`id` = 1659165 OR `props-main`.`id` = 1673163 OR `props-main`.`id` = 1659167 OR `props-main`.`id` = 1659216 OR `props-main`.`id` = 1688092 OR `props-main`.`id` = 1681328 OR `props-main`.`id` = 1688696 OR `props-main`.`id` = 1689157 OR `props-main`.`id` = 1674235 OR `props-main`.`id` = 1686738 OR `props-main`.`id` = 1648266 OR `props-main`.`id` = 1685046 OR `props-main`.`id` = 1663396 OR `props-main`.`id` = 1650946)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare230919' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-12' 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();
6
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$339,000
4
2
1,348
0.16
3425 W Laurel Ave
Visalia, CA 93277
$334,900
3
2
1,160
0.15
136 W Loyola Ave
Visalia, CA 93277
$329,900
3
2
1,330
0.16
2245 S Sallee St
Visalia, CA 93277
$315,000
3
2
1,355
0.16
1421 W Oak Ave
Visalia, CA 93291
Courtesy of Kathleen Busby, RE/MAX Success
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.
