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

Foreclosure: 105 Sidetrack Circle
Comer, GA 30629

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $368,000
Beds: 4
Baths: 3
Status: Active
SqFt: 1839
Agency: Athens Partners Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2023
Notes: Move in Ready. Certificate of occupancy in Hand. 4 large bedroom 2-1/2 Bath with Owner Suite on Main Level. Home features 2 car garage Open Living/dining floor plan on over a half acre lot. Home features custom made cabinets, spray foam insulation and encapsulated crawlspace with dehumidifier. Two hvac systems (One for main level and one for upper level.). Owners suite has oversized closet, bathroom features two his/her separate vanities, 48" shower and 60" soaking tub, Separate toilet room is off the bathroom area. The owner suite overlooks the private view from the covered deck. Upstairs features three spacious bedrooms. Bathroom is located in hallway at top of stairs and features double vanity and tub shower combo. Hardi board siding. Home features extra large oversized covered back porch with three ceiling fans. (approximately 33 ftx 11 ft) Great for entertaining. A plug in will be placed on wall for a tv if new owner wants to install one. There is a five ft walkway and steps from front of house to the back porch. There is a poured patio/storage/sitting area under part of the back porch. There is also a standard 3 ft exterior door going into the crawl space. The area is approximately 12x14 thats level for extra storage. Additional lot and plans are available in the neighborhood. Dont delay make your offer today. Available to close as quick as 8 days when using sellers preferred lender and closing attorney. Builder is owner and Listing Agent.
MlsNumber: 10280444


Listing Provided By: Athens Partners Realty LLC, original listing
Name: Athens Partners Realty LLC
Phone: (706) 316-2900
Office Name: Keller Williams Greater Athens
Office Phone: (706) 316-2900
Agent Name: Daniel Campbell
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