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/244643/52617-Redwood-Dr/Springville/https://www.londonproperties.com/images/props/tulare/full/244643.jpgLondon Properties Springville Real Estate | 52617 Redwood Dr
Bring your vision to the Alpiner-a place remembered for its magic and mountain charm back in the day! Set among tall trees with mountain views at 52617 Redwood Drive, this distinctive property offers the opportunity to imagine its next chapter. A steeply pitched roofline, large windows, and a loft area add character. The interior is extensively unfinished, with exposed framing, broken windows, and significant repair needs throughout. A substantial renovation project in a scenic setting. Buyer to verify square footage, permits, zoning, allowable uses, and overall property condition. Also refer to MLS# 244639
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1000
Year Built Source
Estimated
Days On London
7
Cumulative Days On London
7
County
Tulare
Property Condition
Fixer
New Construction
No
Stories
3
Directions to Property
Eagle Feather Trading Post #1 31267 CA-190, Porterville, CA 93257 Head northeast on CA-190 E 24.0 mi Turn left onto Redwood Dr Destination will be on the left
Roof
Shingle
Heating
None
Cooling
None
# of Main Level Bathrooms
3
Bathrooms Total (Integer)
3
Full Baths
3.0
Full Baths
3
Fireplace Y/N
No
Private Pool
No
Spa
No
Utilities
None
Water Source
Public
Sewer
Septic Tank
Garage
No
APN
220 285 007 000
Lot Dimensions
''irregulare''
Zoning Description
Commercial / Recreational (Nec)
Additional Parcels Y/N
No
View
Mountain(s)
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 203300 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 224700 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1250 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1750 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` = 1785409 OR `props-main`.`id` = 1725051 OR `props-main`.`id` = 1736327 OR `props-main`.`id` = 1719574 OR `props-main`.`id` = 1733167 OR `props-main`.`id` = 1783289 OR `props-main`.`id` = 1717612 OR `props-main`.`id` = 1751586 OR `props-main`.`id` = 1731272 OR `props-main`.`id` = 1735183 OR `props-main`.`id` = 1690472 OR `props-main`.`id` = 1771564 OR `props-main`.`id` = 1731074 OR `props-main`.`id` = 1769131 OR `props-main`.`id` = 1683954 OR `props-main`.`id` = 1752892 OR `props-main`.`id` = 1785022 OR `props-main`.`id` = 1718800 OR `props-main`.`id` = 1717519 OR `props-main`.`id` = 1736330 OR `props-main`.`id` = 1738482 OR `props-main`.`id` = 1733165 OR `props-main`.`id` = 1698214 OR `props-main`.`id` = 1744851 OR `props-main`.`id` = 1721417 OR `props-main`.`id` = 1774025 OR `props-main`.`id` = 1783338 OR `props-main`.`id` = 1783026 OR `props-main`.`id` = 1782962 OR `props-main`.`id` = 1792680 OR `props-main`.`id` = 1793969 OR `props-main`.`id` = 1783332 OR `props-main`.`id` = 1783155 OR `props-main`.`id` = 1783221 OR `props-main`.`id` = 1767328 OR `props-main`.`id` = 1785080)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare244643' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-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();
0
Courtesy of Lynette Thomas, Sousa 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.
