Cable Connected, Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Green Energy Efficient
Appliances, Construction, HVAC, Incentives, Insulation, Lighting, Roof, Thermostat, Water Heater, Windows
Garage
Yes
# of Garage Spaces
2.0
APN
168 520 083
Lot Dimensions
50 X 120
Additional Parcels Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 432805.75 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 478364.25 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1972 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2472 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` = 1732255 OR `props-main`.`id` = 1739054 OR `props-main`.`id` = 1737694 OR `props-main`.`id` = 1739530 OR `props-main`.`id` = 1738390 OR `props-main`.`id` = 1732851 OR `props-main`.`id` = 1732871 OR `props-main`.`id` = 1729003 OR `props-main`.`id` = 1736559 OR `props-main`.`id` = 1735486 OR `props-main`.`id` = 1731093 OR `props-main`.`id` = 1704488 OR `props-main`.`id` = 1720471 OR `props-main`.`id` = 1726526 OR `props-main`.`id` = 1726533 OR `props-main`.`id` = 1726534 OR `props-main`.`id` = 1735825 OR `props-main`.`id` = 1735827 OR `props-main`.`id` = 1735828 OR `props-main`.`id` = 1735829 OR `props-main`.`id` = 1715542 OR `props-main`.`id` = 1715539 OR `props-main`.`id` = 1729292 OR `props-main`.`id` = 1731907 OR `props-main`.`id` = 1731070 OR `props-main`.`id` = 1725695 OR `props-main`.`id` = 1737952 OR `props-main`.`id` = 1719587 OR `props-main`.`id` = 1737687 OR `props-main`.`id` = 1731295 OR `props-main`.`id` = 1737659 OR `props-main`.`id` = 1737691 OR `props-main`.`id` = 1701738 OR `props-main`.`id` = 1737656 OR `props-main`.`id` = 1717106 OR `props-main`.`id` = 1720520 OR `props-main`.`id` = 1737642 OR `props-main`.`id` = 1737672 OR `props-main`.`id` = 1737640 OR `props-main`.`id` = 1728113 OR `props-main`.`id` = 1726487 OR `props-main`.`id` = 1725561 OR `props-main`.`id` = 1732592 OR `props-main`.`id` = 1733382 OR `props-main`.`id` = 1733342 OR `props-main`.`id` = 1733388 OR `props-main`.`id` = 1735820 OR `props-main`.`id` = 1722748 OR `props-main`.`id` = 1734796 OR `props-main`.`id` = 1723940 OR `props-main`.`id` = 1736244)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare241642' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-21' 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();
1
Similar Properties
$444,465
5
3
2,096
0.14
1522 Glory Ave
Tulare, CA 93274
Courtesy of Wesley Bennett, BMC Realty Advisors
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.
