Quiet and peaceful unique property, 4 bedrooms, 2 bathrooms, patio, small olive orchard and fruit trees on 2.057 acres. House needs work selling in its AS IS present condition.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1930
Year Built Source
Public Records
Days On Market
96
Cumulative Days On Market
96
County
Tulare
Property Condition
Fixer
New Construction
No
Stories
1
Directions to Property
Hwy 65 left on Ave. 216, left on Road 252.
Foundation Details
Raised
Roof
Composition
Heating
Propane, Wall Furnace
Cooling
Evaporative Cooling
Laundry Features
Electric Dryer Hookup
Bathrooms Total (Integer)
2
Full Baths
1.5
Three Quarter Baths
2
Appliances
Gas Range, Water Heater
Fireplace Y/N
No
Flooring
Combination, Hardwood
Spa
No
Patio and Porch Features
Patio
Utilities
Electricity Connected, Propane
Water Source
Well
Sewer
Septic Tank
Parking Features
Carport, Concrete
Garage
No
Attached Garage
No
APN
210 160 010 000
Lot Dimensions
2.057
Additional Parcels Y/N
No
View
Hills
Road Surface Type
Asphalt
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 312550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 345450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1294 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1794 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` = 1642950 OR `props-main`.`id` = 1679381 OR `props-main`.`id` = 1662264 OR `props-main`.`id` = 1690633)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare236967' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-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();
0
Courtesy of Margarita Mota, Century 21 Jordan-Link & Company
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.
