A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 299250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 330750 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) >= 1155 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1655 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` = 1686753 OR `props-main`.`id` = 1676423 OR `props-main`.`id` = 1549555 OR `props-main`.`id` = 1684180 OR `props-main`.`id` = 1673391 OR `props-main`.`id` = 1687799 OR `props-main`.`id` = 1674485 OR `props-main`.`id` = 1688980 OR `props-main`.`id` = 1688861 OR `props-main`.`id` = 1685760 OR `props-main`.`id` = 1685847 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` = 1688400 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` = 1687088 OR `props-main`.`id` = 1688895 OR `props-main`.`id` = 1680183 OR `props-main`.`id` = 1680160 OR `props-main`.`id` = 1679090 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` = 1677474 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` = 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` = 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` = 1683895 OR `props-main`.`id` = 1687038 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` = 1664044 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` = 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` = 1686038 OR `props-main`.`id` = 1648473 OR `props-main`.`id` = 1686106 OR `props-main`.`id` = 1686066 OR `props-main`.`id` = 1685884 OR `props-main`.`id` = 1687918 OR `props-main`.`id` = 1689108 OR `props-main`.`id` = 1688190 OR `props-main`.`id` = 1678055 OR `props-main`.`id` = 1648478 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` = 1685845 OR `props-main`.`id` = 1687117 OR `props-main`.`id` = 1656391 OR `props-main`.`id` = 1688841 OR `props-main`.`id` = 1673163 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` = 1648401 OR `props-main`.`id` = 1685046 OR `props-main`.`id` = 1663396 OR `props-main`.`id` = 1650946 OR `props-main`.`id` = 1676624 OR `props-main`.`id` = 1678981 OR `props-main`.`id` = 1689463 OR `props-main`.`id` = 1688234 OR `props-main`.`id` = 1686608 OR `props-main`.`id` = 1682081 OR `props-main`.`id` = 1674706 OR `props-main`.`id` = 1687160 OR `props-main`.`id` = 1689123 OR `props-main`.`id` = 1678992 OR `props-main`.`id` = 1670011 OR `props-main`.`id` = 1686287 OR `props-main`.`id` = 1686098 OR `props-main`.`id` = 1657018)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsDW24126709' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-11' 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:
$329,900
3
2
1,330
0.16
2245 S Sallee St
Visalia, CA 93277
$329,000
4
2
1,263
0.21
4140 W School Ave
Visalia, CA 93291
$315,000
3
2
1,355
0.16
1421 W Oak Ave
Visalia, CA 93291
$309,000
3
2
1,288
0.20
704 N Divisadero St
Visalia, CA 93291
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.
