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

106 Yellow Hammer Road
Tyner, NC 27980

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $515,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2686
Agency: A Better Way Realty, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 2007
Notes: Welcome to your serene country retreat! This custom-built home, set on a sprawling 2.74 acres, offers the epitome of one-level living. Adorned with charming front and back porches, it invites you to savor countless sunrises and sunsets in peace. As you step inside, you're greeted by gleaming wood floors that lead you through the foyer to a spacious office on one side and a formal dining room on the other. The heart of the home, the great room, boasts an electric fireplace as its focal point and seamlessly flows into the well-appointed kitchen, complete with stainless steel appliances, custom cabinetry, and a convenient breakfast bar. With all essential living spaces on the main floor, including the primary bedroom featuring an ensuite and walk-in closet, comfort and convenience are paramount. In addition to the primary suite, there are three more generously sized bedrooms and two full baths, ensuring ample space for family and guests. Step outside onto the covered rear porch, extending into an inviting concrete patio, perfect for entertaining or simply enjoying the tranquility of the surrounding landscape. Parking is a breeze with the expansive three-car garage, offering space for two vehicles and an additional door for storage or workshop needs. large shed included. Plus, the sizable driveway easily accommodates your RV and boat, making adventures a part of your everyday life. Located just minutes from the charming town of Edenton, NC, and a short drive from Elizabeth City, NC, Virginia, and the pristine beaches of the Outer Banks, this home offers the ideal balance of peaceful country living and easy access to amenities and attractions. Don't miss the opportunity to make this idyllic property yours - call to schedule your showing today!
MlsNumber: 100441934


Listing Provided By: A Better Way Realty, Inc., original listing
Name: A Better Way Realty, Inc.
Phone: (252) 435-6402
Office Name: A Better Way Realty, Inc.
Office Phone: (252) 453-4075
Agent Name: Diana Brink
Disclaimer: Copyright © 2024 NCRMLS/ 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