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 = 1905 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 = 1905 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 = 1905 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;

631 N Broad Street
Edenton, NC 27932

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $725,000
Beds: --
Baths: --
Status: Active
SqFt: 3393
Agency: Savage 2.5

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Other
Year Built: 1950
Notes: Introducing a remarkable commercial property located in the historic town of Edenton, NC. This property boasts eight furnished units, offering a unique opportunity for temporary living arrangements. <br /> <br /> One of the standout features of this property is its prime location, as it is conveniently situated within walking distance to downtown Edenton, parks, and a variety of restaurants. Residents will have easy access to the vibrant atmosphere and amenities that the area has to offer.<br /> <br /> Built in 1950, this property has undergone upgrades in 2017, including a new roof, gutters, and heating and cooling systems in each unit. The units are equipped with energy-efficient LED lights. <br /> <br /> Additionally, the property features a laundry room for the convenience of the residents. Freshly painted interiors provide a modern and inviting atmosphere, while refrigerators are provided in each unit for added convenience.<br /> <br /> This commercial property presents an excellent investment opportunity, combining historical charm with modern amenities. Whether you are looking to generate rental income or provide temporary living arrangements, this property offers immense potential.<br /> <br /> Included in Sale: Property, corporation, name, phone numbers, furnishings and inventory. Property Features: Eight Furnace Units with Temporary Living Option<br /> Proximity: Walking Distance to Downtown, Parks, and Restaurants<br /> Year Built: 1950<br /> 2017 Upgrades: New Roof, Gutters, Heating and Cooling Systems in Each Unit<br /> Additional Features: LED Lights, Video Security System, Laundry Room, Paint, and Refrigerator
MlsNumber: 100427143


Listing Provided By: Savage 2.5, original listing
Name: Savage 2.5
Phone: (757) 645-9700
Office Name: Rene Sawyer Realty, LLC
Office Phone: (252) 312-5704
Agent Name: Rene Sawyer
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