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

1125 Cupela Road
Walstonburg, NC 27888
Chase Furlough with Mossy Oak Properties Land and Farms, original listing - (252) 480-5263

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $332,500
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1064 Square Feet
Agency: Mossy Oak Properties Land and Farms
Agency Phone: (252) 480-5263

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 38 acre(s)
Property Type: Residential-Manufactured Home
Year Built: 2020
Notes: Discover your ideal homestead or hunting retreat on this expansive 38 acre property located in the serene countryside near Snow Hill, North Carolina. Nestled amidst the picturesque landscape of Greene County, this property offers a unique blend of residential comfort and outdoor adventure. <br /> <br /> Key Features: <br /> Modern Mobile Home: enjoy the comfort of a spacious 3 bedroom, two-bedroom mobile home, only four years old, providing modern amenities and a cozy atmosphere ideal for relaxation after a day outdoors or after a long day at work. Versatile Land Use: The property features approximately 30 acres of flat fertile agricultural land currently leased for farming, perfect for growing crops or establishing pasture for livestock and plenty of room to build shelters, barns or a nice shop. <br /> <br /> Prime Hunting Opportunities: With agricultural fields typically planted in soybeans or corn and mixed timberlands of oaks and pines, the neighboring property is mostly 5 year cutover which allows great bedding and nesting cover for deer and turkey to thrive providing excellent hunting experiences right out your door step . <br /> <br /> Duck Hunting Paradise: A natural swamp with flooded timber on the south side of the property offers exceptional dunk hunting during winter months, complete with year round water supply that sustains local wildlife populations. <br /> <br /> Convenient Location: Approximately one hour from Raleigh, 20 minutes to Wilson, and 30 minutes to Greenville, enjoy easy access to urban amenities while relishing the tranquility of rural living. <br /> <br /> Additional Details: <br /> Ample room for additional improvements or expansion. <br /> Peaceful rural setting with minimal light pollution, ideal for star gazing and sitting by the fire pit at night. <br /> Nearby access to the town of Snow Hill which offer restaurants, grocery stores and some shopping. <br /> This property presents a rare opportunity to own a versatile piece of land offering both productive agricultural potential and exceptional hunting
MlsNumber: --
ListingId: 100453598


Listing Provided By: Mossy Oak Properties Land and Farms, original listing
Phone: (252) 505-6893
Office Phone: (252) 480-5263
Agent Name: Chase Furlough
Disclaimer: Copyright © 2024 NCRMLS/ Coastal Plains 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