A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 408500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 451500 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) >= 1666 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2166 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` = 1683910 OR `props-main`.`id` = 1683007 OR `props-main`.`id` = 1684212 OR `props-main`.`id` = 1673907 OR `props-main`.`id` = 1674264 OR `props-main`.`id` = 1684428 OR `props-main`.`id` = 1656199 OR `props-main`.`id` = 1670956 OR `props-main`.`id` = 1685590 OR `props-main`.`id` = 1683543 OR `props-main`.`id` = 1686108 OR `props-main`.`id` = 1688716 OR `props-main`.`id` = 1676200 OR `props-main`.`id` = 1681869 OR `props-main`.`id` = 1664296 OR `props-main`.`id` = 1685072 OR `props-main`.`id` = 1685121 OR `props-main`.`id` = 1684914 OR `props-main`.`id` = 1687409 OR `props-main`.`id` = 1686779 OR `props-main`.`id` = 1686448 OR `props-main`.`id` = 1685563 OR `props-main`.`id` = 1685702 OR `props-main`.`id` = 1658427 OR `props-main`.`id` = 1673704 OR `props-main`.`id` = 1685851 OR `props-main`.`id` = 1668940 OR `props-main`.`id` = 1666539 OR `props-main`.`id` = 1683652 OR `props-main`.`id` = 1687298 OR `props-main`.`id` = 1689432 OR `props-main`.`id` = 1684634 OR `props-main`.`id` = 1681133 OR `props-main`.`id` = 1679806 OR `props-main`.`id` = 1686669 OR `props-main`.`id` = 1684943 OR `props-main`.`id` = 1648159 OR `props-main`.`id` = 1689780 OR `props-main`.`id` = 1689787 OR `props-main`.`id` = 1674324 OR `props-main`.`id` = 1667549 OR `props-main`.`id` = 1689776 OR `props-main`.`id` = 1683957 OR `props-main`.`id` = 1688998 OR `props-main`.`id` = 1671066 OR `props-main`.`id` = 1671068 OR `props-main`.`id` = 1671071 OR `props-main`.`id` = 1685817 OR `props-main`.`id` = 1670859 OR `props-main`.`id` = 1688911 OR `props-main`.`id` = 1685328 OR `props-main`.`id` = 1683190 OR `props-main`.`id` = 1689921 OR `props-main`.`id` = 1676525 OR `props-main`.`id` = 1667888 OR `props-main`.`id` = 1688408 OR `props-main`.`id` = 1685766 OR `props-main`.`id` = 1651113 OR `props-main`.`id` = 1646438 OR `props-main`.`id` = 1681844 OR `props-main`.`id` = 1681857 OR `props-main`.`id` = 1681850 OR `props-main`.`id` = 1681860 OR `props-main`.`id` = 1674482 OR `props-main`.`id` = 1685043 OR `props-main`.`id` = 1673933 OR `props-main`.`id` = 1667398 OR `props-main`.`id` = 1660481 OR `props-main`.`id` = 1657630 OR `props-main`.`id` = 1660958 OR `props-main`.`id` = 1648117 OR `props-main`.`id` = 1685715 OR `props-main`.`id` = 1685057 OR `props-main`.`id` = 1676218 OR `props-main`.`id` = 1685014 OR `props-main`.`id` = 1657603 OR `props-main`.`id` = 1680330 OR `props-main`.`id` = 1679365 OR `props-main`.`id` = 1686051 OR `props-main`.`id` = 1686049 OR `props-main`.`id` = 1686062 OR `props-main`.`id` = 1686068 OR `props-main`.`id` = 1679366 OR `props-main`.`id` = 1690471 OR `props-main`.`id` = 1673478 OR `props-main`.`id` = 1658533 OR `props-main`.`id` = 1687932 OR `props-main`.`id` = 1683191 OR `props-main`.`id` = 1675130 OR `props-main`.`id` = 1675133 OR `props-main`.`id` = 1675129 OR `props-main`.`id` = 1680534 OR `props-main`.`id` = 1688392 OR `props-main`.`id` = 1648872 OR `props-main`.`id` = 1655181 OR `props-main`.`id` = 1682534 OR `props-main`.`id` = 1674543 OR `props-main`.`id` = 1673932 OR `props-main`.`id` = 1688342 OR `props-main`.`id` = 1680925)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare229735' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-19' 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();
10
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$449,900
4
3
1,967
0.24
602 N Barranca Ct
Tulare, CA 93274
$446,900
4
2
2,154
0.17
2690 Kelty Meadow Ave
Tulare, CA 93274
$427,990
4
3
1,842
0.15
3068 Isleworth Ave #537 Sft
Tulare, CA 93274
$414,999
4
2
1,764
0.22
1687 Kaweah Dr
Tulare, CA 93274
Courtesy of Steve Macias, Re/Max Gold
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.
