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

500 Floyd
Calhoun, GA 30701
Janice Overbeck with Keller Williams Rlty-Atl.North, original listing - (770) 509-0700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,600,000
Beds: 6
Baths: Full: 8, ½: 1
Status: Active
SqFt: 6674 Square Feet
Agency: Keller Williams Rlty-Atl.North
Agency Phone: (770) 509-0700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1998
Notes: Welcome to your private countryside retreatCothis magnificent 6 bedroom, 8.5 bathroom estate on 20+ acres in stunning Gordon County is a true slice of paradise. The seller has made SIGNIFICANT improvements and upgrades in the past few months! Recent upgrades include luxurious flagstone in the backyard and front porch, newer roofing, interior paint in multiple rooms, updated bathrooms, pool house renovation, and MUCH, MUCH MORE! From the moment you pass through the stately gates and meander down the tree-lined drive, flanked by fenced pastures and a wet-weather pond teeming with local birdlife, youCOll feel the peace and grandeur of this extraordinary property. Step inside the grand two-story foyer, flanked by a banquet-sized dining room and a handsome office, and youCOre immediately greeted with elegance. A double staircase and soaring ceilings lead into the two-story great room, complete with a dramatic wall of windows and cozy fireplaceCoan entertainerCOs dream. The heart of the home is the chefCOs kitchen, featuring a large island with seating, custom cabinetry, double ovens, two dishwashers, a beverage station, and a light-filled breakfast room. The oversized primary suite on the main level is a true sanctuary, offering a sitting area, private rear patio, spa-like ensuite bath with his-and-hers vanities, soaking tub, separate shower, and dual walk-in closets. Upstairs, youCOll find five spacious bedroomsCoeach with its own ensuite bathroom and walk-in closetCoplus a stunning landing with access to the balcony overlooking front pastures. A versatile bonus room is also located on the upper level -- perfect for a game room, play room, or additional family room. Step out back to enjoy the resort-style saltwater gunite pool surrounded by two covered patios and a pool house complete with kitchen, bar, and full bath. A three-car garage includes a finished bonus room and full bathroom above, ready to be transformed into an apartment or studio. For those who dream of farming or simply love animals, this property delivers. A charming barn with power, cross-fenced pastures, a well for livestock and gardens, and county water for the main home make this an ideal setup for horses, cattle, goats, or any livestock. Whether youCOre looking for a multi-generational compound, income potential, or simply a peaceful retreat with room to roam, this estate has it all. Don't miss this rare opportunity to own one of Gordon CountyCOs most beautiful and functional propertiesCoschedule your private tour today!
MlsNumber: --
ListingId: 10503475


Listing Provided By: Keller Williams Rlty-Atl.North, original listing
Phone: (770) 509-0700
Office Phone: (770) 509-0700
Agent Name: Janice Overbeck
Disclaimer: Copyright © 2025 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.


Local Real Estate Expert

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 = 454 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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;
Real Estate Expert Photo for Carla Mahan
Carla Mahan
ASCIIMahan Properties brokered by Northwest Communities Real Estate Group
Call Today!: (678) 521-6108

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App