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;

36 Blackthorn Lane
Colbert, GA 30628
Virginia Beavers with Direct Market Realty, original listing - (706) 202-9650

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,900
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: --
Agency: Direct Market Realty
Agency Phone: (706) 202-9650

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: **Charming Cape Cod Home in a Serene Cul-de-Sac Setting** Welcome to your dream home! This delightful Cape Cod-style residence, built in 2004, offers an ideal blend of classic charm and a tranquil lifestyle, though it awaits your personal touch and updates to make it shine once again. With its spacious layout, this home features three generous bedrooms and 2.5 baths, providing ample room for both relaxation and entertainment. Step inside to discover a formal dining room adorned with lovely heavy trim and wainscoting, perfect for hosting family gatherings. The well-designed kitchen boasts an abundance of beautiful wood cabinetry, ensuring plenty of storage space for all your culinary needs. One of the standout features of this property is the large unfinished bonus room, ready for your creative vision. With wiring and HVAC already in place, it offers endless possibilities for an office, playroom, or additional living space. The practical laundry/mud room is equipped with a raised pet bath tub and heavy cabinetry, making it easy to keep your home organized and clean. Nestled in a great, quiet neighborhood, this home sits on a picturesque pond with a dock, providing a serene backdrop for evening strolls or peaceful mornings by the water. The backyard is fully fenced, ideal for pets and loved ones to play freely among the blooming trees that enhance the outdoor beauty and ambiance. Don't miss this opportunity to invest in a charming home with great potential in a wonderful setting! Schedule your visit today and explore the endless possibilities this Cape Cod gem has to offer!<br /> Private Remarks
MlsNumber: --
ListingId: CM1024437


Listing Provided By: Direct Market Realty, original listing
Phone: (706) 202-9650
Office Phone: (706) 202-9650
Agent Name: Virginia Beavers
Disclaimer: Copyright © 2025 Savannah Multi-List Corporation. 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