Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/tulare/239926/1686-E-Foster-Dr-H/Tulare/https://www.londonproperties.com/images/props/tulare/full/239926.jpgLondon Properties Tulare Real Estate | 1686 E Foster Dr #H
1.5 Acres. SE Tulare. Unlimited upside. Opportunities like this don't come around often. Prime Southeast Tulare acreage with city water already in place and an existing home + garage that could potentially be salvaged, taken down to the studs, or completely reimagined. Whether you're a builder looking for your next project, an investor searching for land value, or a buyer wanting space with serious long-term potential, this property delivers flexibility and future upside. Renovate it. Rebuild it. Expand it. Develop it.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1940
Year Built Source
Public Records
Days On London
18
Cumulative Days On London
18
County
Tulare
Property Condition
Fixer
New Construction
No
Stories
1
Directions to Property
Go Down Mooney, heading South around bend. Foster is across the street and to the West a bit from Sunrise Estates. Property towards the end of the dirt road.
Roof
Other
Heating
Other
Cooling
Other
Bathrooms Total (Integer)
1
Full Baths
1.0
Full Baths
1
Fireplace Y/N
No
Spa
No
Utilities
Electricity Connected, Natural Gas Connected, Water Connected
Water Source
Public
Sewer
Septic Tank
Garage
Yes
# of Garage Spaces
1.0
APN
182 100 014 000
Lot Dimensions
Rectangular - Buyer to verify
Zoning Description
Residential
Additional Parcels Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 237500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 262500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' 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` = 1694673 OR `props-main`.`id` = 1713926 OR `props-main`.`id` = 1697281 OR `props-main`.`id` = 1713458 OR `props-main`.`id` = 1697836 OR `props-main`.`id` = 1707210 OR `props-main`.`id` = 1716909 OR `props-main`.`id` = 1716010 OR `props-main`.`id` = 1671752 OR `props-main`.`id` = 1693558 OR `props-main`.`id` = 1693586 OR `props-main`.`id` = 1698936 OR `props-main`.`id` = 1693584 OR `props-main`.`id` = 1685045 OR `props-main`.`id` = 1713901 OR `props-main`.`id` = 1696910 OR `props-main`.`id` = 1715215 OR `props-main`.`id` = 1706056 OR `props-main`.`id` = 1706114 OR `props-main`.`id` = 1703758 OR `props-main`.`id` = 1684212 OR `props-main`.`id` = 1713054 OR `props-main`.`id` = 1702949 OR `props-main`.`id` = 1712799 OR `props-main`.`id` = 1709919 OR `props-main`.`id` = 1657781 OR `props-main`.`id` = 1713023 OR `props-main`.`id` = 1709751 OR `props-main`.`id` = 1709174 OR `props-main`.`id` = 1715198 OR `props-main`.`id` = 1696346 OR `props-main`.`id` = 1706839 OR `props-main`.`id` = 1705988 OR `props-main`.`id` = 1702075 OR `props-main`.`id` = 1702079 OR `props-main`.`id` = 1715325 OR `props-main`.`id` = 1666539 OR `props-main`.`id` = 1713390 OR `props-main`.`id` = 1716772 OR `props-main`.`id` = 1703242 OR `props-main`.`id` = 1716487)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare239926' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-19' 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 Blake Shawn, Real Brokerage Technologies
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.
