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 = 1892 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 = 1892 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 = 1892 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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;

1221 Nc Highway 305
Aulander, NC 27805

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $529,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2775 Square Feet
Agency: Mossy Oak Properties Land And Farms Realty
Agency Phone: (844) 480-5263

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1999
Notes: Beautiful turnkey, custom 4-bedroom home on 10 acres. Whether you're seeking space, tranquility, or an equestrian or homesteading lifestyle this may be the perfect home for you!This amazing, spacious home is situated on 10 sprawling acres. in a peaceful and quite country setting. This custom design includes a fireplace, 9-foot ceilings on the ground level, a beautiful office with French doors and a spacious kitchen with a Viking propane stove and butcher block table. Large windows allow you to enjoy the beautiful, natural light which brightens up the home and gives you great views of the turkey and other wildlife walking through the yard. The master bedroom is on the ground level and there are three bedrooms upstairs. At the top of the stairs there is a landing with plenty of space for an entertainment or reading area. All the rooms have large closets, and the home was designed to include plenty of storage including a walk-in pantry. A beautiful front porch is a great place to survey your estate while relaxing in a comfortable rocking chair. A spacious area behind the home has a fire pit and Adirondacks chairs where you can make incredible memories with family and friends. <br /> <br /> This property has no HOA or other restrictions! There is plenty of room for horses and other livestock. A chicken coop is already in place for those looking to have animals. There is a spacious 40'x60' high-quality metal building, perfect for storing your vehicles, boats and other equipment. Need more land? Additional adjoining acreage is available!<br /> <br /> This property has so much to offer! Contact agent for a showing for qualified buyers today.
MlsNumber: --
ListingId: 100477204


Listing Provided By: Mossy Oak Properties Land And Farms Realty, original listing
Phone: (252) 325-4766
Office Phone: (844) 480-5263
Agent Name: John Perez
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