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

260 Michigan Circle
Hoschton, GA 30548

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $839,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3282
Agency: Keller Williams Realty Atlanta Partners

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2021
Notes: WALK OUT TO YOUR LAKE LOT AND VACATION IN YOUR OWN BACKYARD! Gorgeous, less than 3 year old home by Fischer Homes, in the beautiful Twin Lakes community, featuring the Leland American Classic plan. This plan offers an amazing amount of amenities & extras. Homeowners added a resort style, in-ground, 15 x 28 salt-water, L-shaped POOL w/ water feature for your summertime needs. One of the few homes to offer a view & access to the serene LAKE flanking it. Covered pergola, tile surround, wrought-iron fencing & professional landscaping package added around the side of the home and pool make this the place you want to relax! Every view from indoors is breathtaking! Venturing inside this custom beauty, you will experience a spotless, professionally decorated home with open concept & primary suite on the main. The elegant foyer greets you & the view of the soaring two-story of windows draws you into the sprawling great room. It has updated chandelier lighting, gas fireplace w/ shiplap surround, sconce lighting on either side of fp, impressive wooden beams on ceiling & 4 oversized, floating shelves. Butler's pantry bar wall & foyer hall to bedroom, both have added shiplap for additional charm.There is a large bright & cheery kitchen w/ a gorgeous granite island, walk-in pantry, upgraded cabinetry, stainless steel appliances, including, gas cooktop w/ decorative ss vent hood & tons of storage. The dining room is adjacent to the kitchen w/ a spectacular view of the outdoor oasis! Primary suite w/ tray ceiling, chandelier, focal wall of shiplap & wood beams add lots of charm & character.The primary bath has decorative tile, shiplap accent wall, a massive, tile shower w/ dual shower heads, dual sink vanities, make-up area, & walk-in closet. There is also a two-piece powder room off the foyer for your guest to use. Mudroom off the garage with added shiplap & a large laundry room complete the main level living. Upstairs there is a large, loft media room, three additional bedrooms & a full bath. Home comes w/ professionally installed custom blinds & rattan shades. Installed Ring security system on all doors & windows, motion sensors & camera sensors in front & backyard. Two car garage w/ opener & additional 4 ft. bump out to accommodate a golf cart. Also, additional parking on the side extension of the garage for all your guests. .Front yard & backyard have extended landscape island and irrigation system installed. Amazing HOA with lots of great amenities, calendar events & a golf cart community! So pack your bathing suit and come see this incredible home! It has everything you could possibly want!
MlsNumber: 10265602


Listing Provided By: Keller Williams Realty Atlanta Partners, original listing
Name: Keller Williams Realty Atlanta Partners
Phone: (678) 808-1300
Office Name: Keller Williams Realty Atl. Partners
Office Phone: (678) 808-1300
Agent Name: Traci Avers
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