Title Page Background
DEBUG FN args: Array ( [0] => 1953 [1] => [2] => [3] => agent ) BEFORE: Site: 1953 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1953 Igate: njhud LocID: 1953 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1953 AND i.igate IN ('cihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1953 [1] => [2] => [3] => lender ) BEFORE: Site: 1953 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1953 Igate: njhud LocID: 1953 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1953 AND i.igate IN ('cihud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1953 [1] => [2] => [3] => other ) BEFORE: Site: 1953 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1953 Igate: njhud LocID: 1953 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1953 AND i.igate IN ('cihud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

301 Hodges Street
Oriental, NC 28571
MARGARET ROSE with NEUSE REALTY, INC, original listing - (252) 633-4888

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,990,000
Beds: --
Baths: --
Status: Active
SqFt: 18289 Square Feet
Agency: NEUSE REALTY, INC
Agency Phone: (252) 633-4888

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Commercial Sale-Other
Year Built: 1986
Notes: Consider two acres of unduplicatable prime waterfront MU-1 property with attached deepwater dockage, nestled in the quaint seaside village of Oriental NC, referred to as the sailing capital of the US East Coast. <br /> <br /> Redevelopment end uses currently contemplated are summarized in the uploaded documents include: 20 seaside condominium units OR an international ECO Hub to showcase emerging products and services in the sustainability space.<br /> <br /> Nearby regional airports, colleges and universities, waterfront which flows to the nearby ICW all support end uses limited only by the vision of the buyer.<br /> <br /> Appraisal, surveys, Phase 1 available for review. Transformative Waterfront Village Center in Historic Carolina<br /> <br /> Discover the potential of this exceptional commercial multi-use development project located in the heart of a historic waterfront village in North Carolina. This unique opportunity aims to revitalize an underutilized commercial building, transforming it into a vibrant village center that will become the hub of waterfront activity. <br /> <br /> KEY FEATURES:<br /> <br /> - Prime Waterfront Location - Situated in a picturesque historic village, this development offers stunning waterfront views and easy access to local attractions. <br /> <br /> - Mixed-Use Development - The project includes a blend of residential, commercial, and recreational spaces, creating a dynamic environment for residents and visitors.<br /> <br /> - Historic Preservation - The development will preserve the building's historic charm while incorporating modern amenities and sustainable design principles. <br /> <br /> - Community Engagement - Extensive community involvement ensures that the project aligns with the needs and desires of local residents, fostering a sense of ownership and pride. <br /> <br /> - Economic Growth - By attracting small businesses, restaurants, and retail shops, the development will stimulate the economy and create jobs. <br /> <br /> - Cultural and Recreational Activities - The village center will feature spaces for cultural events, art galleries, performance venues and outdoor parks, thereby enhancing the quality of life for the community. <br /> <br /> - Sustainable Design - Incorporating energy-efficient systems, green roofs, and water conservation measures, the project aims to minimize its environmental impact and reduce operating costs.<br /> <br /> - Public-Private Partnerships - Collaborations with local businesses, non-profits, and government agencies will provide valuable resources and support for the project's success.<br /> <br /> <br /> This transformative project promises to breathe new life into the historic waterfront village, creating a vibrant and sustainable community space that honors the past while embracing the future. Join us in making this vision a reality and be part of a thriving village center that celebrates the unique charm and heritage of the Carolinas.<br /> <br /> OPEN TO PARCELING OR OTHER POTENTIAL USES<br /> <br /> The property has already been approved for subdivision, subdivided for future development, this includes retail, hospitality, education etc. <br /> <br /> -- Excellent Relationship with Local Officials <br /> <br /> Local leaders are highly supportive of any of the use cases outlined below and are open and flexible on exploring most other use cases for the property. They share our vision for the future of the property. <br /> <br /> -- Development Assistance Post-Sale<br /> <br /> In addition to assisting with the smooth sale and transfer of the property, we have also partnered with a qualified project facilitator in order to provide a number of additional options to any potential buyer post-purchase.<br /> <br /> "BEST USE FOR BEST VALUE"<br /> <br /> Some Potential Uses include, but are not limited to:<br /> <br /> ** Fish Market / Seafood Restaurant <br /> <br /> ** Luxury Condominiums with Private Vessel Docking <br /> <br /> ** Hospitality / Hotel<br /> <br /> ** Marina - Deep Water Docking <br /> <br /> ** Education Lab - Global Eco Hub <br /> <br /> ** 20 Unit Duplex Town Waterfront Village
MlsNumber: --
ListingId: 100386167


Listing Provided By: NEUSE REALTY, INC, original listing
Phone: (252) 633-4888
Office Phone: (252) 633-4888
Agent Name: MARGARET ROSE
Disclaimer: Copyright © 2025 Hive MLS / Neuse River Region 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.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => pamlico [3] => NC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: pamlico State: NC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: pamlico State: NC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1953 AND i.igate IN ('cihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Wayne T. Brazier
Wayne T. Brazier
ASCIIFreedom Real Estate Group
Call Today!: (252) 259-2931

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App