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

139 Magnolia Lane
Boone, NC 28607

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,495,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3988 Square Feet
Agency: Rock Real Estate Group
Agency Phone: (828) 773-6455

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1993
Notes: >>LOOKING FOR "MOUNTAIN CHARM"? ---THIS IS IT! ** BUYERS - PUT THIS HOME ON YOUR LIST! ~ Reduced by $155,000... BEST BUY! This is more than ONE Premier Home. >>> SEPARATE GUEST COTTAGE with LIVING AREA over spacious 2 car garage. ***LOCATION & Quality... MAGNIFICENT HOME…. 3988 SQ. FT. HEATED... 2 SEPARATE STRUCTURES... 4 BEDROOMS 4 FULL BATHS / ONE HALF BATHROOM ... TWO OVERSIZED GARAGES FOR "4 CARS". (III) Located in the GATED COMMUNITY of Greystone IV. “This home FEATURES fine details & meticulous craftsmanship were quite evident.” BRIGHT & LIGHT # LARGE WINDOWS... BLINDS & PLANATION SHUTTERS A home that truly needs to be toured to see how many amazing benefits and features there are. Included are the Main Home and a detached GUEST SUITE area with full bathroom and above additional garages. The Main Home: 4 BEDROOMS– 3 FULL BATHROOMS– 1 HALF BATHROOM—Large spacious Great Room with soaring ceilings and a wall of glass windows. Large Kitchen with dining room conveniently adjacent. ~ LARGE MASTER BEDROOM features soaring ceilings, GREAT BATHROOM, AND LOTS OF CLOSETS. Really cool “O round windows” & skylights… Strategically positioned for maximum light. Everything has been well– maintained. Lots of outdoor living space with both stone & wooden decks. Double front door and backdoor FOYERS. An oversized 2 car garage is attached. ~THE detached GUEST SUITE is located over an expansive 2 car garage in detached building. Tons of room– tons of storage. You have to see this home from the inside out. NOTE: HEATED SQ. FT. INCLUDES THE HEATED. 857 SQ. FT. ABOVE DETACHED GARAGE. LARGE 1.07 ACRE flat yard. Great for a gardener. ~ Spacious outdoor decks and porches. Easy access. At the top of this gated subdivision. This home offers so much opportunity as a primary home, second home, or family retreat. Wonderful roads for walking and great common area pond for picnics. Minutes to Boone & Blowing Rock, NC and Blue Ridge Parkway.
MlsNumber: --
ListingId: 246364


Listing Provided By: Rock Real Estate Group, original listing
Phone: (828) 773-6455
Office Phone: (828) 773-6455
Agent Name: Alan Gordon
Disclaimer: Copyright © 2024 High Country 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