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;

1100 Windsor Avenue
Bristol, TN 37620

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $900,000
Beds: --
Baths: --
Status: Active
SqFt: 18304
Agency: Greater Impact Realty Kingsport

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Other
Year Built: 1901
Notes: LET'S TALK ABOUT POTENTIAL! This Beautiful Church was established around 1901. The Sanctuary is still in Prestine Condition, including the 22 Beautiful Stained Glass Windows. The Building is in Great Condition as well. So if you are looking for a Church look no further. If you are looking for an ''Extraordinary'' Church with extra curriculum look no further. With a total of 15000 plus sq. ft. There's more than enough room to add a ''Day-care'' to your Church, There's more than enough room for different types of Venue's: Weddings, (the Ceramony and the Reception), Concerts, Conferences, a Gymnasium, Dance Recitals, There is a Beautiful Stage for performing. Family Reunions, Class Reunions etc.<br /> If a Church is not what you are looking for then LET'S OPEN UP THE BOX! This Amazing Piece of Property is Zoned R-3 which opens it up to so many other possibilities. You could have your own Business Office there. There's 8 Beautiful Renovated Offices and a Conference Room there that could allow you to Rent Offices to other Individuals. Other possibilities are Apartment House, Airbnb, Bed & Breakfast, A very Quaint Restaurant, (which would be so cool) a Christian School. There's endless possibilities.<br /> Since the Current Owner bought this Property, he has made some awesome additions. There's a Recording Room, Kitchenette, New Paint, Wood Flooring has been Refinished, the list goes on and on. This property has 4 Parcels and Parking for 50 cars plus On Street Parking. If you are looking for a Unique Property with the ability to be what you want it to be then You should take time to Walk thru this one.<br /> All information concerning this Property is deemed reliable, information is taken from Tax Records, Past and Current owners and is subject to Buyers Verification. The Zoning Regulations are attached to this listing.
MlsNumber: 9965602


Listing Provided By: Greater Impact Realty Kingsport, original listing
Name: Greater Impact Realty Kingsport
Phone: (423) 530-7185
Office Name: Greater Impact Realty Kingsport
Office Phone: (423) 530-7185
Agent Name: Lori Cross-Hobson
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;
Stephanie & Mike Ransom
ASCIIEpique Realty
Call Today!: (423) 646-7754

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App