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 = 729 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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 = 729 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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 = 729 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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;

176 Champlain Road
Hoschton, GA 30548

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $437,591
Beds: 5
Baths: 3
Status: Pending
SqFt: --
Agency: Crown Realty Professionals

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: This home is a must see in the most gorgeous community in Jackson County***Hurry, up to $7K Closing Costs using DHI Mortgage*** The Hayden floor plan is our most popular 5 bedroom home here at Twin Lakes. Owner's Suite is located on the 2nd floor and there is a guest bedroom and full bath on the main floor. This home is located in the master planned community of TWIN LAKES with AMAZING AMENITIES: RESORT STYLE POOL - CLUBHOUSE - FITNESS CENTER - PLAYGROUND - DOG PARK, LAKESIDE PAVILION - Adirondack CHAIRS and SWINGS. Watch the sunsets over the water and stroll around the serene LAKES and walking trails. Home features granite countertops and stainless steel appliances, hardwood floors on 1st floor except bedrooms & baths. Relax and enjoy your coffee in the morning, or a glass of wine with friends in the evening while grilling under the COVERED BACK PATIO. Total Price includes 2 zone lawn irrigation system, window blinds, 2 ceiling fans, garage door opener, architectural shingles, 4 sides brick water tables, etc. Smart Home connected. Jackson County's newest Premier Master Planned Community. Ask about the FREE 10 year warranty through RWC with this home! Twin Lakes is only 2.2 miles from I-85, 5 minutes to Downtown Hoschton/Braselton with their quaint shops, restaurants and local brewery. Northeast Georgia Medical Center is only 15 minutes away and Chateau Elan Winery and Golf Club is just 10 minutes away! NEW PUBLIX Supermarket is planned at the front entrance to Twin Lakes off Highway 53. Stock Photos used.
MlsNumber: 10252256


Listing Provided By: Crown Realty Professionals, original listing
Name: Crown Realty Professionals
Phone: (678) 509-0560
Office Name: D.R. Horton Realty of GA Inc.
Office Phone: (678) 509-0555
Agent Name: Raynette Harp
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