A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 3990000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 4410000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '6' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2752 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3252 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` = 1749613 OR `props-main`.`id` = 1747419 OR `props-main`.`id` = 1745459 OR `props-main`.`id` = 1754760 OR `props-main`.`id` = 1745166 OR `props-main`.`id` = 1657720 OR `props-main`.`id` = 1745677 OR `props-main`.`id` = 1742865 OR `props-main`.`id` = 1692599 OR `props-main`.`id` = 1733507 OR `props-main`.`id` = 1658089 OR `props-main`.`id` = 1755758 OR `props-main`.`id` = 1623290 OR `props-main`.`id` = 1725157 OR `props-main`.`id` = 1719213 OR `props-main`.`id` = 1725158 OR `props-main`.`id` = 1703436 OR `props-main`.`id` = 1750846 OR `props-main`.`id` = 1713152 OR `props-main`.`id` = 1713275 OR `props-main`.`id` = 1704178 OR `props-main`.`id` = 1705202 OR `props-main`.`id` = 1704179 OR `props-main`.`id` = 1742760 OR `props-main`.`id` = 1742431 OR `props-main`.`id` = 1742213 OR `props-main`.`id` = 1746440 OR `props-main`.`id` = 1705047 OR `props-main`.`id` = 1726339 OR `props-main`.`id` = 1744700 OR `props-main`.`id` = 1717752 OR `props-main`.`id` = 1701088 OR `props-main`.`id` = 1715917 OR `props-main`.`id` = 1748197 OR `props-main`.`id` = 1742864 OR `props-main`.`id` = 1747281 OR `props-main`.`id` = 1722539 OR `props-main`.`id` = 1726338 OR `props-main`.`id` = 1753287 OR `props-main`.`id` = 1757477 OR `props-main`.`id` = 1750721 OR `props-main`.`id` = 1750767 OR `props-main`.`id` = 1757066 OR `props-main`.`id` = 1757176 OR `props-main`.`id` = 1732757 OR `props-main`.`id` = 1716747 OR `props-main`.`id` = 1716025 OR `props-main`.`id` = 1667554 OR `props-main`.`id` = 1727593 OR `props-main`.`id` = 1725276 OR `props-main`.`id` = 1662005 OR `props-main`.`id` = 1686614 OR `props-main`.`id` = 1742281 OR `props-main`.`id` = 1712649 OR `props-main`.`id` = 1728663 OR `props-main`.`id` = 1756212 OR `props-main`.`id` = 1756211 OR `props-main`.`id` = 1751305)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare243287' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-04' 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();
1
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$4,200,000
6
3
3,002
0.18
534 Pacific Ave
Cayucos, CA 93430
Courtesy of Tamara Burgos, Downtown Realty Visalia
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.
