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

6022 Jim Crow Road
Flowery Branch, GA 30542
Jennifer Anderson with Keller Williams Realty Community Partners, original listing - (678) 341-7400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,995,000
Beds: 6
Baths: Full: 5, ½: 1
Status: Active
SqFt: 7220 Square Feet
Agency: Keller Williams Realty Community Partners
Agency Phone: (678) 341-7400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2020
Notes: Resort Living every day at this truly one-of-a-kind property! Designed in three parts – the main house, carriage house and RV/Boat garage with 1,520 sf apartment on 2.24 acres, make this a spectacular estate. Nestled in serene surroundings next to Lake Lanier, the outdoor oasis boasts tons of fun! Play an exciting game of pickleball on your very own court. The cool garage door opens to a “viewing area” complete with half-bath, storage space for your equipment and refreshments. After playing a game, take a dip with family and friends in the beautiful pool/spa that is both heated and cooled. Meal preparation is a breeze with not one, but 2 outdoor kitchens. Equipped with grills, smokers, and beverage coolers, it’s a chef’s paradise for serving meals poolside. The firepit area is a great space to relax in the evening and make s’mores. Slip under the back porch and lower the remote-control screens that offer a four-seasons room complete with ceiling heaters and fireplace, for those cool evenings. Turn a game on TV to cheer on your favorite team or practice your golf game on the putting green. Luxury living like this every day is a vacation! This custom builder’s home inside is just as special with designer finishes throughout. A double door foyer offers a direct view of the outdoor living through a lovely great room with cozy fireplace, bookcases and upscale lighting. The massive kitchen that overlooks the pool deck has seating for 10, an oversized island with prep sink and icemaker, high bar and beverage bar. The white kitchen has a full refrigerator, full freezer, gas range and double oven. Two custom walk-in pantries, one with gourmet coffee maker and refrigerator, make meal prep and entertaining easy. The Owner’s retreat with bed/spa bath and dream closet is conveniently situated on the main level, accompanied by a home office, mudroom with space for your furry pet, laundry/craft room and half-bath. Upstairs has a large family room for watching movies, three bedroom with bath en’suites and fourth bedroom/bunk room. The carriage house has a kitchen/den/bedroom/full bath and walk in closet. Connected to the adorable front porch is the impressive RV/Boat storage garage with workshop area. Old Federal Park is just down the street making it super easy to access the lake and enjoy a day of boating. The charming apartment above the garage has a spacious bedroom/full bath/den/kitchenette and upper covered porch that overlooks the amenities. Two gated entries, three separate garages with parking for seven, fencing around perimeter, gorgeous landscaping, security and technology that operate through an app, three garages and ample additional parking offer everything you need for daily living or for short term rental investment potential. Properties like this are a rare find! Don’t miss this amazing opportunity to enjoy this compound estate.
MlsNumber: --
ListingId: 7497480


Listing Provided By: Keller Williams Realty Community Partners, original listing
Phone: (770) 356-2629
Office Phone: (678) 341-7400
Agent Name: Jennifer Anderson
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 = 459 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 Karen Brown
Karen Brown
ASCIIMaximum One Premier Realtors
Call Today!: (678) 704-1202

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App