A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 451249.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 498748.95 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) >= 1329 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1829 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` = 1712273 OR `props-main`.`id` = 1713001 OR `props-main`.`id` = 1711457 OR `props-main`.`id` = 1696010 OR `props-main`.`id` = 1681783 OR `props-main`.`id` = 1702678 OR `props-main`.`id` = 1697186 OR `props-main`.`id` = 1712286 OR `props-main`.`id` = 1711568 OR `props-main`.`id` = 1687291 OR `props-main`.`id` = 1705354 OR `props-main`.`id` = 1712745 OR `props-main`.`id` = 1711740 OR `props-main`.`id` = 1711741 OR `props-main`.`id` = 1711742 OR `props-main`.`id` = 1711743 OR `props-main`.`id` = 1711744 OR `props-main`.`id` = 1711745 OR `props-main`.`id` = 1711746 OR `props-main`.`id` = 1711747 OR `props-main`.`id` = 1711748 OR `props-main`.`id` = 1711749 OR `props-main`.`id` = 1711750 OR `props-main`.`id` = 1711751 OR `props-main`.`id` = 1711752 OR `props-main`.`id` = 1689166 OR `props-main`.`id` = 1689176 OR `props-main`.`id` = 1712204 OR `props-main`.`id` = 1712203 OR `props-main`.`id` = 1684664 OR `props-main`.`id` = 1702139 OR `props-main`.`id` = 1684744 OR `props-main`.`id` = 1684666 OR `props-main`.`id` = 1684665 OR `props-main`.`id` = 1686130 OR `props-main`.`id` = 1712427 OR `props-main`.`id` = 1704956 OR `props-main`.`id` = 1705701 OR `props-main`.`id` = 1703453 OR `props-main`.`id` = 1711971 OR `props-main`.`id` = 1686951 OR `props-main`.`id` = 1711396 OR `props-main`.`id` = 1711719 OR `props-main`.`id` = 1701523 OR `props-main`.`id` = 1707867 OR `props-main`.`id` = 1705276 OR `props-main`.`id` = 1708453 OR `props-main`.`id` = 1695852 OR `props-main`.`id` = 1707893 OR `props-main`.`id` = 1706027 OR `props-main`.`id` = 1711277 OR `props-main`.`id` = 1705633 OR `props-main`.`id` = 1712930 OR `props-main`.`id` = 1691619 OR `props-main`.`id` = 1698029 OR `props-main`.`id` = 1712693 OR `props-main`.`id` = 1697405 OR `props-main`.`id` = 1712546 OR `props-main`.`id` = 1698103 OR `props-main`.`id` = 1694002 OR `props-main`.`id` = 1711083 OR `props-main`.`id` = 1702516 OR `props-main`.`id` = 1702546 OR `props-main`.`id` = 1704722 OR `props-main`.`id` = 1705597 OR `props-main`.`id` = 1711649 OR `props-main`.`id` = 1711721 OR `props-main`.`id` = 1702575 OR `props-main`.`id` = 1712360 OR `props-main`.`id` = 1694321 OR `props-main`.`id` = 1703778 OR `props-main`.`id` = 1702450 OR `props-main`.`id` = 1711799 OR `props-main`.`id` = 1712959 OR `props-main`.`id` = 1712909 OR `props-main`.`id` = 1705469 OR `props-main`.`id` = 1711965 OR `props-main`.`id` = 1711116 OR `props-main`.`id` = 1711584 OR `props-main`.`id` = 1711652 OR `props-main`.`id` = 1711701 OR `props-main`.`id` = 1693567 OR `props-main`.`id` = 1695355 OR `props-main`.`id` = 1703188 OR `props-main`.`id` = 1710256 OR `props-main`.`id` = 1709765 OR `props-main`.`id` = 1706664 OR `props-main`.`id` = 1704714 OR `props-main`.`id` = 1706954 OR `props-main`.`id` = 1711682)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226005451' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-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();
8
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$475,000
3
2
1,501
0.15
828 Olivewood Dr
Los Banos, CA 93635
$466,500
4
3
1,773
0.13
2114 Coulter Ln #393P
Los Banos, CA 93635
$460,000
3
3
1,598
0.13
408 RICE Way
Los Banos, CA 93635
$455,000
4
2
1,741
0.15
224 N Santa Ana St
Los Banos, CA 93635
Courtesy of Antonia Martin, Keller Williams Property Team IDX provided by Reliance Marketing
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.
