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 = 1978 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 = 1978 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 = 1978 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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;

108 E Water Street Street
Plymouth, NC 27962

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $395,900
Beds: --
Baths: --
Status: Active
SqFt: 3300
Agency: Lakeside Realty of Eastern NC, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Other
Year Built: 1905
Notes: What an amazing opportunity to own a prime piece of real estate in the heart of historic, downtown Plymouth on the beautiful Roanoke River. Single story brick building with over 3300 sq. ft plus an additional approximately 1800 sq, ft. of usable storage on the bottom level, river side. The first level extends from the sidewalk to a wall of windows to view the Roanoke River. As you enter there is an Artisans' Market with craft vendors who rent the spaces to market their wares. Then down a hallway with 2 bathrooms. Building is handicapped accessible from Water Street; bathrooms are also handicapped accessible. Next is the Cafe with seating for over 50 people. This includes what the owners refer to as the living room, a comfortable, casual, conversation area. Breakfast and lunch are served six days a week. There are fresh homebaked goods available daily. Also available are all kinds of coffee drinks, both hot and cold, as well as fresh fruit smoothies, tea and soft drinks. Gourmet sandwiches and daily specials are featured. There is a main kitchen with updated appliances as well as a baker's kitchen. All mechanicals including HVAC, plumbing & electrical were installed new in 2019. The Cafe has become central to the downtown community and the owners are hosts to private events as well as public meetings. Also to be conveyed is a 5 KW generator that will power all freezers and refrigerators; has a manual transfer switch.
MlsNumber: 100422322


Listing Provided By: Lakeside Realty of Eastern NC, LLC, original listing
Name: Lakeside Realty of Eastern NC, LLC
Phone: (252) 394-6100
Office Name: Lakeside Realty Of Eastern Nc, Llc
Office Phone: (252) 394-6100
Agent Name: Kathy Waters
Disclaimer: Copyright © 2024 NCRMLS/ Albemarle Area Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App