Great Opportunity to own almost 2 acres of land between Ivanhoe and Visalia. The property includes 2 APN's all fenced in with a well and electricity in place. It has a 1 bedroom 1 bath home with a big carport, 3 sea trains in the back and fire hydrants all around the property to be able to build another house. It has several oak trees in the property. The property is being sold in ''AS-IS'' condition. The seller will not pay for any repairs/improvements, retrofits or inspections.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2017
Year Built Source
Owner
Days On London
20
Cumulative Days On London
20
County
Tulare
New Construction
No
Stories
1
Directions to Property
From Houston Ave and Lovers Lane go East on Houston Ave it curves into Road 160 towards Ivanhoe to the property on the North side of road.
Foundation Details
Slab
Roof
Composition, Shingle
Heating
Other
Cooling
Other, Wall/Window Unit(s)
Laundry Features
In Kitchen
Bathrooms Total (Integer)
1
Full Baths
1.0
Full Baths
1
Fireplace Y/N
No
Flooring
Bamboo, Ceramic Tile, Laminate
Private Pool
No
Spa
No
Utilities
Electricity Connected
Water Source
Well
Sewer
Septic Tank
Parking Features
Attached
Garage
No
Attached Garage
Yes
# of Carports
2.0
APN
108 080 021 000
Lot Dimensions
549 X 166
Additional Parcels Y/N
Yes
Additional Parcels Description
108080020000
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 380000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 420000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '1' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 710 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1210 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` = 1735428 OR `props-main`.`id` = 1739142 OR `props-main`.`id` = 1739083 OR `props-main`.`id` = 1739073 OR `props-main`.`id` = 1739131 OR `props-main`.`id` = 1741583 OR `props-main`.`id` = 1723299 OR `props-main`.`id` = 1714052 OR `props-main`.`id` = 1714060 OR `props-main`.`id` = 1739252 OR `props-main`.`id` = 1736218)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare242436' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-09' 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 Rosa Jimenez, Melson Realty, Inc.
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.
