A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 331550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 366450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1100 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1600 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` = 1719880 OR `props-main`.`id` = 1728150 OR `props-main`.`id` = 1726137 OR `props-main`.`id` = 1726155 OR `props-main`.`id` = 1726135 OR `props-main`.`id` = 1700077 OR `props-main`.`id` = 1655657 OR `props-main`.`id` = 1650605 OR `props-main`.`id` = 1655666 OR `props-main`.`id` = 1728132 OR `props-main`.`id` = 1726924 OR `props-main`.`id` = 1727253 OR `props-main`.`id` = 1726989 OR `props-main`.`id` = 1727008 OR `props-main`.`id` = 1737249 OR `props-main`.`id` = 1729900 OR `props-main`.`id` = 1731288 OR `props-main`.`id` = 1726785 OR `props-main`.`id` = 1726997 OR `props-main`.`id` = 1732112 OR `props-main`.`id` = 1725022 OR `props-main`.`id` = 1727240 OR `props-main`.`id` = 1725524 OR `props-main`.`id` = 1719897 OR `props-main`.`id` = 1720190 OR `props-main`.`id` = 1721413 OR `props-main`.`id` = 1713393 OR `props-main`.`id` = 1722237 OR `props-main`.`id` = 1721423 OR `props-main`.`id` = 1731289 OR `props-main`.`id` = 1728670 OR `props-main`.`id` = 1714389 OR `props-main`.`id` = 1719976)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare242320' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-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();
3
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$359,000
4
2
1,407
0.14
30750 Farr Rd
Visalia, CA 93291
$357,900
4
2
1,271
0.11
30574 Bellwood Rd
Visalia, CA 93291
$355,000
4
2
1,418
0.14
7443 Ensminger
Visalia, CA 93291
Courtesy of Franklin Romine, The Equity Group
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.
