A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 411825 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 455175 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1605 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2105 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` = 1648426 OR `props-main`.`id` = 1666076 OR `props-main`.`id` = 1685735 OR `props-main`.`id` = 1685737 OR `props-main`.`id` = 1683392 OR `props-main`.`id` = 1678354 OR `props-main`.`id` = 1659642 OR `props-main`.`id` = 1658029 OR `props-main`.`id` = 1645564 OR `props-main`.`id` = 1686483 OR `props-main`.`id` = 1648501 OR `props-main`.`id` = 1681507 OR `props-main`.`id` = 1686313 OR `props-main`.`id` = 1686789 OR `props-main`.`id` = 1681363 OR `props-main`.`id` = 1648309 OR `props-main`.`id` = 1688151 OR `props-main`.`id` = 1674292 OR `props-main`.`id` = 1685771 OR `props-main`.`id` = 1673728 OR `props-main`.`id` = 1689867 OR `props-main`.`id` = 1689869 OR `props-main`.`id` = 1658134 OR `props-main`.`id` = 1672871 OR `props-main`.`id` = 1671768 OR `props-main`.`id` = 1668131 OR `props-main`.`id` = 1685575 OR `props-main`.`id` = 1681773 OR `props-main`.`id` = 1684867 OR `props-main`.`id` = 1690008 OR `props-main`.`id` = 1690005 OR `props-main`.`id` = 1666395 OR `props-main`.`id` = 1687059 OR `props-main`.`id` = 1689063 OR `props-main`.`id` = 1662429 OR `props-main`.`id` = 246307 OR `props-main`.`id` = 1689892 OR `props-main`.`id` = 1683751 OR `props-main`.`id` = 1651549 OR `props-main`.`id` = 1687081 OR `props-main`.`id` = 1620445 OR `props-main`.`id` = 1684596 OR `props-main`.`id` = 1681675 OR `props-main`.`id` = 1676742 OR `props-main`.`id` = 1683172 OR `props-main`.`id` = 1685513 OR `props-main`.`id` = 1674592 OR `props-main`.`id` = 1684597 OR `props-main`.`id` = 1668381 OR `props-main`.`id` = 1685507 OR `props-main`.`id` = 1683171 OR `props-main`.`id` = 1667577 OR `props-main`.`id` = 1674599 OR `props-main`.`id` = 1683565 OR `props-main`.`id` = 1648310 OR `props-main`.`id` = 1684584 OR `props-main`.`id` = 1678994 OR `props-main`.`id` = 1676794 OR `props-main`.`id` = 1676397 OR `props-main`.`id` = 1671137 OR `props-main`.`id` = 1672885 OR `props-main`.`id` = 1667966 OR `props-main`.`id` = 1667953 OR `props-main`.`id` = 1689277 OR `props-main`.`id` = 1689284)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare230778' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-16' 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:
$441,200
4
3
1,950
0.11
1473 Concord Way #Lot #41
Dinuba, CA 93618
$441,200
4
3
1,950
0.11
1473 Concord Way #LT 41
Dinuba, CA 93618
$431,750
4
3
1,855
0.10
1484 Concord Way #Lot 37
Dinuba, CA 93618
Courtesy of Veronica Torres Luna, Re/Max Gold - Clovis
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.
