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

879 Big Horn Hollow
Suwanee, GA 30024

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,425,000
Beds: 6
Baths: 8
Status: Active
SqFt: 10904
Agency: RE/MAX Center

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2008
Notes: Welcome to this impeccably updated custom home, nestled alongside the 6th fairway within The River Club, a gated community. This residence, a creation of Storey Custom Homes, stands as a testament to architectural excellence, having earned the prestigious 2008 Home Builder OBIE Award. Its exterior has a blend of brick, stone, & cedar shake, complemented by the glow of gas lanterns, a welcoming porch, and a 4-car garage with 2 additional parking spaces. Once you step through the grand front door, a world of elegance & sophistication awaits you. Pennsylvania Blue Stone floors extend a gracious welcome, along with expansive windows that allow natural light to flood in. The two-story ceilings are adorned with wooden beams, creating a dramatic and inviting ambiance. The large great room boasts an oversized stone fireplace and offers seamless access to the covered patio. Nearby, an elegant library features built-in cabinets and rich wood paneling. Continuing your journey, you'll discover a charming & intimate formal dining room, complete with floor-to-ceiling windows & a coffered ceiling. The heart of this home is the expansive chef's kitchen, with dual islands, one hosting a prep sink, top-tier appliances, a pot filler, a beverage bar with a two-zone wine fridge, & a hidden walk-in pantry. The kitchen overlooks an eat-in breakfast area & a cozy keeping room with another captivating stone fireplace & opens onto a spacious screened porch. On the main floor, the owner's suite offers serenity & convenience, featuring access to the screened porch, an expansive bathroom with separate vanities, & a custom walk-in closet. Completing the main level are a large laundry room, a well-appointed home office, a convenient drop zone, & an elevator-ready shaft. Venturing upstairs, a substantial landing guides you to four generously sized bedrooms, each boasting its own en-suite bathroom and walk-in closet. A built-in study area provides hidden stair access to full attic space, while a dual laundry room simplifies daily tasks with two sets of washers & dryers. The terrace level is an entertainer's paradise, characterized by soaring ceilings, Tennessee stone columns, & architecturally stunning ceilings. Here, you'll find a custom wet bar equipped with a True refrigerator, microwave, dishwasher, & ice maker, as well as a billiard/gaming area, a home theater complete with seating for eight, & a great room featuring a stone fireplace & double sliding glass doors leading to the covered veranda. Adding to the allure, a Junior Master Guest en-suite includes a cabana bathroom with a spacious walk-in shower & sauna, with a convenient door leading to the pool area. Outside, a newly landscaped outdoor oasis awaits, complete with a covered veranda, heated saltwater pool & spa, and a tranquil Koi Pond with a cascading waterfall & seating area. Adjacent to the pool, an entertaining patio beckons, featuring a stone fireplace, trellis, & a built-in grilling area equipped with two Green Egg grills. The River Club, distinguished for its Greg Norman-designed private championship golf course, offers a wealth of amenities, including a Family Lakeside Sports Center, Fitness Center, and restaurants, enriching the already lavish lifestyle provided by this remarkable residence.
MlsNumber: 7346149


Listing Provided By: RE/MAX Center, original listing
Name: RE/MAX Center
Phone: (770) 932-1234
Office Name: RE/MAX Center
Office Phone: (770) 932-1234
Agent Name: Mary Grace Deas
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.


Local Real Estate Expert

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 = 3412 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;
Real Estate Expert Photo for Anne Carpenter
Anne Carpenter
ASCIIBerkshire Hathaway HomeServices Georgia
Call Today!: (770) 318-0032

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App