A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 372400 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 411600 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) >= 1283 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1783 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` = 1726137 OR `props-main`.`id` = 1726155 OR `props-main`.`id` = 1726135 OR `props-main`.`id` = 1655657 OR `props-main`.`id` = 1650605 OR `props-main`.`id` = 1655666 OR `props-main`.`id` = 1744131 OR `props-main`.`id` = 1728132 OR `props-main`.`id` = 1726924 OR `props-main`.`id` = 1727253 OR `props-main`.`id` = 1741375 OR `props-main`.`id` = 1727008 OR `props-main`.`id` = 1737249 OR `props-main`.`id` = 1729900 OR `props-main`.`id` = 1726785 OR `props-main`.`id` = 1726997 OR `props-main`.`id` = 1732112 OR `props-main`.`id` = 1725022 OR `props-main`.`id` = 1720190 OR `props-main`.`id` = 1741962 OR `props-main`.`id` = 1713393 OR `props-main`.`id` = 1722237 OR `props-main`.`id` = 1720225 OR `props-main`.`id` = 1731289 OR `props-main`.`id` = 1742315 OR `props-main`.`id` = 1728670 OR `props-main`.`id` = 1714389 OR `props-main`.`id` = 1719976)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare242663' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-03' 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();
5
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$399,390
4
2
1,756
0.12
7092 Oriole Ave
Visalia, CA 93291
$398,990
4
2
1,699
0.16
7008 Oriole Ave
Visalia, CA 93291
$385,000
4
2
1,699
0.11
31061 Road 72
Visalia, CA 93291
$379,990
4
2
1,699
0.12
7070 Elm St
Visalia, CA 93291
Courtesy of Brandon Madrid, Melson Realty, 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.
