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

890 Nexus Drive
East Ellijay, GA 30540
The Holly Nelson Team with Engel & Volkers North Georgia Mountains, original listing - (706) 406-5572

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $485,000
Beds: 2
Baths: Full: 2, ½: 1
Status: Active
SqFt: --
Agency: Engel & Volkers North Georgia Mountains
Agency Phone: (706) 406-5572

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2012
Notes: Escape to your ultimate mountain retreat in this meticulously crafted 2BR/3BA custom home. With 10 FT ceilings, this home welcomes you with an inviting kitchen and an open floorplan ideal for gatherings. Step onto the screened porch to immerse yourself in the tranquil beauty of nature. Outside, the landscaped grounds offer a flagstone patio, plumbed with a gas line for seamless grilling. Gather around the custom designed fire pit area and enjoy evenings under the stars, savoring a glass of wine and creating cherished memories with loved ones. Take advantage of the spacious outbuilding, currently set up as a workshop complete with a variety of tools-it's also ideal for transforming into a charming personal space. Each bedroom is a private sanctuary, complete with its own bathroom. Sold fully furnished, this home radiates comfort throughout. The attic provides ample ROOM FOR EXPANSION to a second level and is already stubbed for a potential bathroom! Situated on 1.65 acres, with an additional adjoining lot totaling 2.22 acres, there's plenty of space to roam and enjoy. Nestled in Coosawattee River Resort, known for its quiet charm and well-maintained amenities, you'll discover a community offering something for everyone. Enjoy 3 pools (including one indoor-heated and two outdoor), basketball, tennis, and pickleball courts, an 18-hole mini golf course, arcade, fitness center, five river parks, a fishing pond, and more—all just a short distance from town. This exceptional home combines the tranquility of a mountain escape with the convenience of resort-style living. Whether you envision it as your own private sanctuary or an investment opportunity for long or short-term rentals, don't miss out. Schedule your private tour today to experience everything this property has to offer.
MlsNumber: --
ListingId: 411339


Listing Provided By: Engel & Volkers North Georgia Mountains, original listing
Phone: (706) 455-7400
Office Phone: (706) 406-5572
Agent Name: The Holly Nelson Team
Disclaimer: Copyright © 2024 Northeast Georgia 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