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

251 Quail Cove Lane
Brasstown, NC 28902
Poltrock Team with ReMax Mountain Properties, original listing - (828) 837-3002

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $769,800
Beds: 4
Baths: Full: 3, ½: 3
Status: Active
SqFt: 3236 Square Feet
Agency: ReMax Mountain Properties
Agency Phone: (828) 837-3002

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1997
Notes: Travel back in time to experience Olde World English charm in this stunning Tudor-style home. Situated on two lots totaling over 3 acres, this partially furnished 4 bed, 3 full, and 3 half bath home radiates classic elegance. As you approach the home via the long paved driveway through beautifully landscaped grounds with mature trees and flowering shrubs, you'll pass by an outbuilding for storage on the way to your spacious parking area. From there, a rock pathway leads to the quaint front porch lined with iron railings forged by a local blacksmith, and inside to your grand foyer showcasing a classic open staircase and rich dark wood floors and trim that feature throughout the home, giving it a warm and stately feel. With two living spaces on the main level, the living room and family room both offer space for relaxation, with the family room featuring a gas log fireplace and access to a large screened porch and a luxurious saltwater hot tub on the deck. The kitchen has stainless steel appliances, elegant quartzite counters, and a breakfast area that opens to a pergola-covered patio and an impressive tiered garden awaiting the touch of a green thumb to ready it for Spring. Completing the main floor are a butler's pantry, formal dining room, two half bathrooms, and access to your 24' x 22' garage. Ascend the staircase to the upper level and you'll find three large bedrooms, including one with an attached bath, a bonus room, and the Master Suite with a spa-like en suite bathroom, a huge walk-in closet, and laundry room. A second staircase leads to the unfinished attic, a blank canvas full of potential. The lower level offers a large bonus room with a wet bar, a partially completed kitchen, a one-third bathroom, and unfinished storage space. With Fiber Optic internet, a radon mitigation system, a geothermal heat pump, and a freshly painted exterior in 2022, this home is as practical as it is beautiful. And conveniently close to the Folk School and downtown Murphy!
MlsNumber: --
ListingId: 151432


Listing Provided By: ReMax Mountain Properties, original listing
Phone: (828) 837-6400
Office Phone: (828) 837-3002
Agent Name: Poltrock Team
Disclaimer: Copyright © 2024 Mountain Lakes Board 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