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','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 = 486 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 = 486 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;

276 Kincaid Cemetery Road
Colbert, GA 30628

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $534,000
Beds: 4
Baths: 4
Status: Active
SqFt: 3736
Agency: Chastain, Jenkins & Leathers, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 1999
Notes: Spacious Brick Home over Basement with Detached Shop in Brush Creek! This 4 bedroom, 2.5 bath home with attached 2 car garage on 5.52 acres is a gem with flex space to make it what you need. A wide covered front porch greets you as you enter the property and leads you into the living room with fireplace and dining room. Flowing into the kitchen at the rear, you find space for a bistro table or eating space while looking out the French doors to the expansive back yard. The main floor is completed by the laundry area, a half bath, a back staircase, and the primary bedroom suite. The primary suite is on the front of the house and has a large bathroom with a seated vanity space along with a walk-in closet. Upstairs, there are 2 generously sized bedrooms with ample closets, a flex room/storage space which leads into a larger flex room that can be a bedroom, playroom, office space, craft room, you name it! This flex room goes to the rear staircase. In the basement, there is a fully functional wood stove that will heat the whole place! Very large spaces are ready for you to define them. There is a plumbed toilet in place and just needs the rest of the bathroom to create an easy living space. Double French doors open to the side patio which leads you easily around the front of the house. A major benefit of this property is the 30'x40' detached workshop with power and roll up door. There is a lean-to on one side and a smaller storage shed on the other. Additional driveway and parking space is available for the shop and house to share. A large part of the rear and side yard is fenced with a separate smaller fenced area for the pool off of the back deck. The sellers have lovingly worked on improvements during their ownership and have removed all popcorn ceilings, painted all cabinetry, replaced most lighting fixtures, replaced the carpet upstairs, installed new laminate flooring throughout the main floor, and more. Come see how this property can work for you!
MlsNumber: 1018596


Listing Provided By: Chastain, Jenkins & Leathers, LLC, original listing
Name: Chastain, Jenkins & Leathers, LLC
Phone: (706) 559-4520
Office Name: Corcoran Classic Living
Office Phone: (706) 559-4520
Agent Name: Christina LaFontaine
Disclaimer: Copyright © 2024 Athens Area Association of Realtors. 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