A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 521550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 576450 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) >= 1727 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2227 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` = 1674387 OR `props-main`.`id` = 1653050 OR `props-main`.`id` = 1683409 OR `props-main`.`id` = 1681813 OR `props-main`.`id` = 1683240 OR `props-main`.`id` = 1661853 OR `props-main`.`id` = 1675162 OR `props-main`.`id` = 1683474 OR `props-main`.`id` = 1661842 OR `props-main`.`id` = 1683411 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` = 1689325 OR `props-main`.`id` = 1673391 OR `props-main`.`id` = 1687799 OR `props-main`.`id` = 1689275 OR `props-main`.`id` = 1688980 OR `props-main`.`id` = 1681314 OR `props-main`.`id` = 1688861 OR `props-main`.`id` = 1685760 OR `props-main`.`id` = 1685847 OR `props-main`.`id` = 1688409 OR `props-main`.`id` = 1689276 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` = 1677486 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` = 1679974 OR `props-main`.`id` = 1678401 OR `props-main`.`id` = 1679989 OR `props-main`.`id` = 1684582 OR `props-main`.`id` = 1688443 OR `props-main`.`id` = 1687088 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` = 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` = 1660743 OR `props-main`.`id` = 1680321 OR `props-main`.`id` = 1662266 OR `props-main`.`id` = 1617483 OR `props-main`.`id` = 1676419 OR `props-main`.`id` = 1679752 OR `props-main`.`id` = 1685622 OR `props-main`.`id` = 1681566 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)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare230353' 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();
2
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$540,000
3
3
2,137
0.19
2826 S Avocado Ct
Visalia, CA 93277
$524,900
4
2
2,065
0.21
3515 W Iris Ave
Visalia, CA 93277
Courtesy of Lindsey Tevelde, MD Graham & Associates, Inc.
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.
