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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

2310 Muskogee Lane
Braselton, GA 30517

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $725,000
Beds: 4
Baths: 3
Status: Pending
SqFt: 4160
Agency: REMAX Center

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2004
Notes: INTERIOR REPAINTED AND NEW CARPET! Welcome home to this gorgeous craftsman-style home in the highly sought-after Village section of Chateau Elan. Feel secure 24/7 with staffed security gate access into Chateau Elan. Tired of maintaining your yard? This home includes lawn maintenance, so sell all of your yard tools! Spend your extra time sipping your favorite drink on your large front porch, viewing the huge green space across the street and the beautiful tree-lined streets. This stunning 4-bedroom, 3-bathroom home has a large open kitchen with views to the great room and keeping room. Get cozy in both rooms, as they each have their own fireplace. The kitchen offers granite countertops, a gas range, and plenty of storage. The main floor has a large primary suite with his/her closets as well as separate vanities. Relax in your soaking tub after a long day on the golf course. Two additional bedrooms are on the main floor. The front stairs lead to an additional bedroom or large living space with a full bathroom as well as extra attic storage. The back stairs lead to a large, unfinished space that could be great for an office or an additional bedroom. Tub already installed in the bathroom area. Don't miss out on the chance to live in this gated community surrounded by Chateau Elan hotels, restaurants, a spa, and a winery just a golf cart ride away! There are 3 golf courses along with a three-par course among the community. After a round, enjoy a glass of wine and dinner at Sarazen's, located at the golf club! This golf cart community stretches beyond this neighborhood with the Braselton Life Path to local restaurants, grocery stores, and everything happening in the growing city of Braselton! Easy access to Hwy. 85 and minutes from the Northeast Georgia Medical Center Braselton campus.
MlsNumber: 10235727


Listing Provided By: REMAX Center, original listing
Name: REMAX Center
Phone: (770) 932-1234
Office Name: RE/MAX Center
Office Phone: (770) 932-1234
Agent Name: Robin Trammell
Disclaimer: Copyright © 2024 Georgia Multiple Listing Service. 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