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

2606 Old Highway 441 S
Tiger, GA 30576

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,990,000
Beds: 3
Baths: Full: 2, ½: 2
Status: Active
SqFt: 3359 Square Feet
Agency: Atlanta Fine Homes Sotheby's International
Agency Phone: (404) 237-5000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1998
Notes: Stunning! One Of a Kind, contemporary home nestled at the base of Tiger Mountain! Masterfully constructed with oversized glass walls and windows throughout the house, each room is filled with natural light and invites nature inside offering spectacular views of verdant mountains, pastoral vineyards, and lush forests from every room. Located in beautiful Northeast Georgia, just 100 miles from Atlanta, this unique 20-acre property is a mountain paradise. The artistic architecture with its soaring ceilings is punctuated with unique angles that give the house an airy quality, while the open floorplan connects and creates intimacy. Exquisite travertine floors blend with bleached oak floors throughout the main level rooms. The large living room boasts a unique glass sided fireplace which warms the dining room and keeping room as well. The exquisite kitchen is extraordinary! Custom designed cherry cabinetry is more fine furniture than utility. A home office is strategically located next to the kitchen. The primary bedroom on the main level is a sanctuary for serenity with private patio access. The spacious bathroom has beautiful custom cabinetry with a unique glass brick shower as a focal point. The two-car garage has two entry doors for convenient access to the kitchen and laundry room. Upstairs the dramatic Tower Library with its celestial windows offers breathtaking, 180-degree views of mountains, vineyards and the sunrise! Two bright bedrooms and bath complete the second story. When nature beckons, venture down the woodland path to your own private picnic area by the bubbling stream or hike the 20-acre property's old farm road up Tiger Mountain. Outdoor activities for the sports-minded await in Rabun County's abundant resources. Trout fishing, whitewater rafting, boating, biking, hiking are just minutes away. The town of Tiger with its Drive-In Theater, and retail shops is just a short walk, or drive to the city of Clayton in just a few minutes. Water sports on Lake Rabun and Lake Burton are close by, and golfers will find Kingwood Golf Course and others nearby.
MlsNumber: --
ListingId: 7410812


Listing Provided By: Atlanta Fine Homes Sotheby's International, original listing
Phone: (404) 863-2116
Office Phone: (404) 237-5000
Agent Name: Yetty Arp
Disclaimer: Copyright © 2024 First Multiple Listing Service, Inc. 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