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;
<< Go Back | All Foreclosures | | | All Cities

511 Neuse Village Road
Arapahoe, NC 28510
The Beth Frazer Real Estate Team with Beth Frazer & Associates, original listing - (973) 222-8374
« Prev
Next »
Currently Displayed Property Photo


Property Details

List Price: $439,000
Beds: 2
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1615 Square Feet
Agency: Beth Frazer & Associates
Agency Phone: (252) 249-1001

Map Details Show Map | Show StreetView



Description/Comments

Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Offered Fully furnished! Come experience your inner peace on the Inner Banks. This beautiful home is one of eight cottages nestled on eight acres in a secluded area of NC's coastal Inner Banks. Take in the serenity of the spectacular Neuse River as it flows into the Pamlico Sound while watching the sunset. This delightful find boasts a community dock, grill, and pool. The homes are located only a few miles outside of the Village of Oriental and minutes away from renowned summer camps and quiet sailing communities. Come fish and crab from the dock or kayak, swim, canoe at your leisure. This 2 bedroom, 2.5 bath cottage The reversed floor plan with the bedrooms downstairs including laundry room. The primary bedroom is spacious and has en-suite bath with shower and private porch overlooking the water. The front bedroom shares a full bath connecting to the office. Upstairs is an open floor plan with kitchen, dining room, living room and guest bathroom. Enjoy the vaulted ceilings with exposed beams, heart pine floors, gas fireplace, mahogany counters, and spectacular water views! The upstairs balcony overlooks the Neuse River and is the perfect place to relax, catch up on your reading or just sip your morning coffee as you watch the dolphins play. A perfect retreat. The nearest boat ramp is located 2.5 miles away on Dawson Creek. There is plenty of room to park your vehicle and boat/trailer. Come experience your inner peace on the Inner Banks. This beautiful home is one of eight cottages nestled on eight acres in a secluded area of NC's coastal Inner Banks. Covered under HOA: Water, Sewer (septic), waste removal, pest treatment, road maint, landscaping as well as community amenities: pool, grilling area, shared pier, beach, detached shed storage. Turn-key and ready for private retreat or as an investment property, Take in the serenity of the spectacular Neuse River as it flows into the Pamlico Sound while drinking a glass of wine and watching the sunset
MlsNumber: --
ListingId: 100450819


Listing Provided By: Beth Frazer & Associates, original listing
Phone: (252) 249-1001
Office Phone: (973) 222-8374
Agent Name: The Beth Frazer Real Estate Team
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

Contact Me

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App