A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 379050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 418950 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) >= 1433 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1933 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` = 1737659 OR `props-main`.`id` = 1737691 OR `props-main`.`id` = 1737656 OR `props-main`.`id` = 1737642 OR `props-main`.`id` = 1737672 OR `props-main`.`id` = 1737640 OR `props-main`.`id` = 1728113 OR `props-main`.`id` = 1716994 OR `props-main`.`id` = 1725486 OR `props-main`.`id` = 1728588 OR `props-main`.`id` = 1740835 OR `props-main`.`id` = 1740729 OR `props-main`.`id` = 1728810 OR `props-main`.`id` = 1733382 OR `props-main`.`id` = 1733342 OR `props-main`.`id` = 1733388 OR `props-main`.`id` = 1735820 OR `props-main`.`id` = 1719289 OR `props-main`.`id` = 1722748 OR `props-main`.`id` = 1734796 OR `props-main`.`id` = 1738137 OR `props-main`.`id` = 1724772 OR `props-main`.`id` = 1724773 OR `props-main`.`id` = 1717233 OR `props-main`.`id` = 1725304 OR `props-main`.`id` = 1696785 OR `props-main`.`id` = 1723940 OR `props-main`.`id` = 1741086 OR `props-main`.`id` = 1728277 OR `props-main`.`id` = 1726555 OR `props-main`.`id` = 1737704 OR `props-main`.`id` = 1725240 OR `props-main`.`id` = 1725541 OR `props-main`.`id` = 1736244 OR `props-main`.`id` = 1713746 OR `props-main`.`id` = 1732099 OR `props-main`.`id` = 1736547 OR `props-main`.`id` = 1738248 OR `props-main`.`id` = 1732860 OR `props-main`.`id` = 1736324 OR `props-main`.`id` = 1735823 OR `props-main`.`id` = 1705626 OR `props-main`.`id` = 1725456 OR `props-main`.`id` = 1660481 OR `props-main`.`id` = 1657630 OR `props-main`.`id` = 1715884 OR `props-main`.`id` = 1715601 OR `props-main`.`id` = 1727120 OR `props-main`.`id` = 1722536 OR `props-main`.`id` = 1727693 OR `props-main`.`id` = 1685715 OR `props-main`.`id` = 1643854 OR `props-main`.`id` = 1726412 OR `props-main`.`id` = 1677929 OR `props-main`.`id` = 1726625 OR `props-main`.`id` = 1732697 OR `props-main`.`id` = 1717849 OR `props-main`.`id` = 1701505 OR `props-main`.`id` = 1718127 OR `props-main`.`id` = 1719473 OR `props-main`.`id` = 1719866 OR `props-main`.`id` = 1719864 OR `props-main`.`id` = 1728136 OR `props-main`.`id` = 1737638 OR `props-main`.`id` = 1716986 OR `props-main`.`id` = 1736335 OR `props-main`.`id` = 1717382 OR `props-main`.`id` = 1719975)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare242484' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-23' 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();
4
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$399,900
3
3
1,662
0.07
2785 Ruby Port St #Sor21
Tulare, CA 93274
$394,750
3
3
1,662
0.07
2827 Ruby Port St #Sor17
Tulare, CA 93274
$388,780
3
3
1,662
0.07
2865 Ruby Port St #Sor13
Tulare, CA 93274
$380,450
3
3
1,494
0.07
2809 Ruby Port St #Sor 19
Tulare, CA 93274
Courtesy of Martina Miller, eXp of Northern California
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.
