Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2508 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2508 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2508 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

Tbd Shipp Springs Road
Kingsport, TN 37660
Ed Mahaffey with TCI Group - Jerry Petzoldt Agency, LLC, original listing - (423) 230-0255

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,990,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: TCI Group - Jerry Petzoldt Agency, LLC
Agency Phone: (423) 230-0255

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 48 acre(s)
Property Type: Land-Other
Year Built: --
Notes: DEVELOPERS - Mixed Use Development Opportunity with Survey, Engineering and Permitting Approval Already in Place. READY TO DIG.<br /> <br /> Unlock the potential of prime real estate with this unparalleled opportunity on Shipp Springs Rd. Spanning approximately 73 acres, this mixed-use development site is a visionary's dream, boasting a coveted land disturbance/grading permit already in place.<br /> <br /> Situated within the City Limits of Kingsport, this property has seamlessly integrated into the urban landscape, offering a strategic location for transformative growth. The stamp of approval from the Kingsport City Council for high-density residential development sets the stage for immediate action, signaling a green light for progress.<br /> <br /> With the flexibility to accommodate 15 units per acre, the canvas is vast and the possibilities endless. From modern apartments to single-family attached and detached homes, the potential for crafting diverse living spaces is boundless. Whether catering to buyers or renters, the opportunity to shape vibrant communities is at your fingertips.<br /> <br /> Embark on this journey of development with confidence, knowing that the City of Kingsport is committed to supporting your vision. Significant off-site improvements, totaling upwards of $1 million, will be covered by the city, further enhancing the appeal and feasibility of this project.<br /> <br /> Delve into the details outlined in the attached Offering Memorandum and seize the chance to redefine urban living in Kingsport. Contact us today to capitalize on this rare opportunity and become a catalyst for positive change on Shipp Springs Rd. The future awaits, and it begins here.
MlsNumber: --
ListingId: 9967282


Listing Provided By: TCI Group - Jerry Petzoldt Agency, LLC, original listing
Phone: (423) 430-4215
Office Phone: (423) 230-0255
Agent Name: Ed Mahaffey
Disclaimer: Copyright © 2024 Tennessee Virginia Regional Multiple Listing Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2508 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Ronnie (Doc) Manis
Ronnie (Doc) Manis
ASCIIWeichert Realty Saxon Clark
Call Today!: (210) 380-1892

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App