Welcome to this beautiful and inviting 3 bedroom, 2 bathroom home offering a wonderful blend of comfort, style and functionality. This spacious layout provides plenty of room for every day living, entertaining, and relaxing. The open and practical floor plan creates a warm atmosphere that feels like home from the moment you walk in.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1988
Year Built Source
Public Records
Days On London
6
Cumulative Days On London
6
County
Tulare
New Construction
No
Stories
1
Directions to Property
Take CA-198 E Towards Exeter then to Waldo Ave
Roof
Composition
Heating
Central
Cooling
Central Air
Bathrooms Total (Integer)
2
Full Baths
2.0
Full Baths
2
Fireplace Y/N
Yes
Fireplace Features
Electric
Private Pool
No
Spa
No
Utilities
Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Garage
Yes
# of Garage Spaces
2.0
APN
135 024 022 000
Lot Dimensions
150.02 X 61
Additional Parcels Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 346655 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 383145 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) >= 898 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1398 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` = 1753296 OR `props-main`.`id` = 1753888 OR `props-main`.`id` = 1779930 OR `props-main`.`id` = 1779847 OR `props-main`.`id` = 1763578 OR `props-main`.`id` = 1788678 OR `props-main`.`id` = 1755408 OR `props-main`.`id` = 1725590 OR `props-main`.`id` = 1785803 OR `props-main`.`id` = 1691916 OR `props-main`.`id` = 1782920 OR `props-main`.`id` = 1691895 OR `props-main`.`id` = 1780425 OR `props-main`.`id` = 1788670 OR `props-main`.`id` = 1771109 OR `props-main`.`id` = 1773827 OR `props-main`.`id` = 1772193 OR `props-main`.`id` = 1773809 OR `props-main`.`id` = 1733082 OR `props-main`.`id` = 1773223 OR `props-main`.`id` = 1728036 OR `props-main`.`id` = 1737835 OR `props-main`.`id` = 1725067 OR `props-main`.`id` = 1755482 OR `props-main`.`id` = 1724161 OR `props-main`.`id` = 1755443 OR `props-main`.`id` = 1764838 OR `props-main`.`id` = 1770369 OR `props-main`.`id` = 1764501 OR `props-main`.`id` = 1781343 OR `props-main`.`id` = 1738478 OR `props-main`.`id` = 1767330 OR `props-main`.`id` = 1786160 OR `props-main`.`id` = 1784293 OR `props-main`.`id` = 1786039 OR `props-main`.`id` = 1783139 OR `props-main`.`id` = 1630494 OR `props-main`.`id` = 1783365 OR `props-main`.`id` = 1787139 OR `props-main`.`id` = 1773996)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare244457' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-08' 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();
0
Courtesy of Susana Valencia, Five Star Realty
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.
