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

843 Nc Hwy 37
Gatesville, NC 27938
Shane Noblin with EXP Realty, original listing - (888) 584-9431

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $535,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3600 Square Feet
Agency: EXP Realty
Agency Phone: (888) 584-9431

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: Escape to Tranquil Country Living!<br /> <br /> Looking to get away from the hustle and bustle? Here's your chance to own this stunning 4-bedroom, 2.5-bathroom home, offering 3,600 sq ft of living space and 5.72 acres of peaceful countryside. With a convenient 2-car attached garage, this property offers the ideal combination of comfort, space, and rural charm.<br /> <br /> As you step inside, the spacious kitchen greets you with ample cabinet space, countertops, and a large pantry, making it a chef's dream. A cozy breakfast nook sits nearby, perfect for enjoying your morning coffee. The laundry room, conveniently located off the kitchen, adds to the home's practicality.<br /> <br /> The large rear living room is a focal point, featuring wide plank knotty pine flooring and a gas log fireplace, creating a warm and inviting atmosphere. You'll also find a sunroom that brings in an abundance of natural light. The stunning staircase is flanked on the first floor by a formal dining room and a spacious front living room, perfect for hosting family gatherings or relaxing in style.<br /> <br /> The spacious primary bedroom is located on the first floor for added convenience, complete with an en-suite bathroom featuring a walk-in shower. Upstairs, you'll find three additional bedrooms and a large full bathroom with a jetted tub and walk-in shower, perfect for unwinding after a long day.<br /> <br /> Outside, the 3-stall horse barn with a wash stall is ready for your animals, while the converted party room, painted in Harley Davidson colors and equipped with heat and AC, is perfect for entertaining. The property also includes two ponds—one large and 12 feet deep, the other smaller and 5 feet deep—ideal for fishing or just enjoying the view. With partially fenced pasture and room for more, this property is perfect for your four-legged friends.<br /> <br /> Conveniently located near VA and the Outer Banks, this is a property you won't want to miss!
MlsNumber: --
ListingId: 100476347


Listing Provided By: EXP Realty, original listing
Phone: (888) 584-9431
Office Phone: (888) 584-9431
Agent Name: Shane Noblin
Disclaimer: Copyright © 2024 Hive MLS / 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