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

39101 264 Us
Belhaven, NC 27810

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,500,000
Beds: 3
Baths: 2
Status: Active
SqFt: 2069
Agency: PEARL R WEST

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 22 acre(s)
Property Type: Residential
Year Built: 2010
Notes: A rare opportunity to own a 22-acre waterfront compound that has so many amenities to enjoy. There are 3 dwellings, each distinctively built that could be used as personal residence, vacation, recreational getaway, or corporate retreat. The large 40' x 50' red barn has 2 beds, 2 full baths, den/kitchen area, 18' x 23' screened in porch, shelter all the way down one side, roll-up door for drive in convivence, heated workshop. Perfect for hanging waders, decoy storage, fishing/hunting equipment, side wall workbench, and permanent ice machine. The main house is tastefully done in unpainted cypress lumber, both interior and exterior. The floors are all heart pine, old handmade brick for the large wood burning fireplace. It has 3 bedrooms, 2 full baths, open den kitchen dining area. Thermador stove and vent system, commercial stainless sink. The screened in porch is full width of house. The third dwelling or guest house also boosts heart pine flooring and unpainted cypress with 2 bedrooms, 2 baths. The dock has a cleaning station, covered sitting area, and a large shelter with a boat lift. Beautiful cypress trees along the walkway. Dock was built out of cypress and treated lumber, plumbing and electricity. Large shelter to store boats, ATV's, yard equipment, whatever. Other additional structures include a smoke house, 2-man skeet shooting stand, and two grilling shelters. <br /> The grounds are well landscaped with azaleas, hardwoods, and pines. Most of the property undergrowth has been removed, opening the property. Turkeys, bears, and deer frequently seen. Largest flock of hummingbirds ever seen on feeders. <br /> The tract is situated on Mill Creek, right off the Pungo River. Enjoy inshore fishing year-round, duck hunting and boat riding. The Intracoastal Waterway is just a short distance. Belhaven is approximately 7 miles by auto or take the boat and have lunch or dinner at several of the fine restaurants. <br /> Please call for a more detail list of features and amenities. Show by appointment only. Offering a $1,125,000
MlsNumber: 100339961


Listing Provided By: PEARL R WEST, original listing
Name: PEARL R WEST
Phone: (910) 293-4156
Office Name: West Agency LLC
Office Phone: (910) 293-4156
Agent Name: Norwood West
Disclaimer: Copyright © 2024 NCRMLS/ Cape Fear Realtors MLS, Inc. 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 = 1891 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;
Real Estate Expert Photo for Lisa Cartwright
Lisa Cartwright
ASCIIThe Cartwright Team
Call Today!: (252) 944-3180

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App