Title Page Background
DEBUG FN args: Array ( [0] => 3283 [1] => [2] => [3] => agent ) BEFORE: Site: 3283 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3283 Igate: njhud LocID: 3283 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3283 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3283 [1] => [2] => [3] => lender ) BEFORE: Site: 3283 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3283 Igate: njhud LocID: 3283 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3283 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3283 [1] => [2] => [3] => other ) BEFORE: Site: 3283 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3283 Igate: njhud LocID: 3283 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3283 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1005 Bailey Road
Woodstock, GA 30188

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,750,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 3642 Square Feet
Agency: Keller Williams North Atlanta
Agency Phone: (770) 663-7291

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1983
Notes: Looking for One of the Most Unique Properties on the Market? You have found it with this “One-of-a-Kind” 7.5 acre Gated Lake Estate Oasis built to maximize the Lake views throughout this amazing property which includes the Main residence, a Custom pool house and Resort Style Pool with Spa and 4-tiered Waterfall, a Detached 1300 sq ft 3 bay Air-Conditioned garage, and a Bonus Recreational Garage for all the extra Toys! The 4/3 Home features a Gorgeous Vaulted Family Room with Floor to Ceiling Windows to enhance the Lake Views, a Stacked Stone Double Sided Fireplace and Opens to the large Trex Deck. The Gourmet Kitchen was remodeled with top-of-the-line 6 burner Wolfe gas range, an oversized Sub-Zero Fridge with Fridge and Freezer Drawers and Custom Cabinetry that includes Pull-out shelving. The Owner’s Suite has been expanded to include a Custom Closet System, His and Hers Vanities, Double Shower heads and a Soaking Tub with Fireplace. The Main level of the home is rounded out by a Comfortable Sunroom off the Kitchen, additional Full Bathroom for guests and Hardwood Floors throughout! Head downstairs to the Terrace Level to find 3 additional bedrooms and a full bathroom, plus a Full Bar and Recreation Game room opening out to Patio area that features many areas to Relax and Entertain under the Finished Underdeck while overlooking the Lake! The home also has an attached 2 car Garage, Copper Gutters, Plantation Shutters, a Full property Audio Speaker app integration and much more. Designed by Well-known Architect Tim Bryan, the Pool house and Detached garage are built to Impress! Invite all your Friends over to the 1300 sq ft Pool House featuring a full Commercial Kitchen with Blue Star Gas Oven and Range with Griddle , Vulcan Deep Fryer, Grill, Full sized Sub Zero Refrigerator, Sub-Zero Wine and Beverage Fridge , Two Keg Fridge 4 Tap Kegerator. There is a Large Vaulted Billiard Room, Multiple TV’s, Built-in Speakers throughout the Interior and Exterior, Full Bathroom, tinted windows and even a Beer Brewing Room with Sink and Hood! The extensive Stonework is a Showstopper throughout the Covered and Uncovered areas surrounding the Saltwater Pool and Spa! The Icing on Top is the Unparalleled 4-tiered Waterfall Feature and Stone Fireplace that could rival that of any resort! Every detail has been thought of including Landscape Lighting and Hidden Speakers with individual sound controls to help control the vibe! Head over to the Garage (if you can call it that) that every Car Aficionado DREAMS of! This air conditioned 3 bay garage has been outfitted with a Atlas 9,000 lbs , 2 Post Hydraulic Lift, 4 compressed air stations, Wall to Wall built in Storage, a fridge, TV and Built in Speakers. You pretty much could live in there! There is an additional Storage area behind and also a Bonus Garage that can store additional equipment or Toys! The main compound is on 5.5 acres and the lot to the west which is 2 acres could be developed as a completely separate home if you desired or kept to maintain the privacy. This Wonderful Estate is completely Private, Gated, Fenced and Professionally Landscaped by Gibbs Landscaping. Located in the Best Part of Cherokee County only 2 miles to Alpharetta and Milton, you will feel like you are so far removed from the hustle of Atlanta but so close to every amenity you need!
MlsNumber: --
ListingId: 7460701


Listing Provided By: Keller Williams North Atlanta, original listing
Phone: (678) 283-7001
Office Phone: (770) 663-7291
Agent Name: V Team Realty
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => cherokee-south [3] => GA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: cherokee-south State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: cherokee-south State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3283 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Zach Yoder
Zach Yoder
ASCII1Look Real Estate
Call Today!: (678) 353-4018

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App