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

253 Williams Circle
Elko, GA 31025-2017
Kari Pollock with LANDMARK REALTY, original listing - (478) 987-9987

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3086 Square Feet
Agency: LANDMARK REALTY
Agency Phone: (478) 987-9987

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 14 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Welcome your horses to your own personal oasis nestled on a sprawling 14.2 acre property in the desirable 253 Williams Circle neighborhood. This all-brick, 4-bedroom, well-maintained gem offers a generous 3086 square feet of luxurious living space for the discerning homeowner. Priced at $774,900, this property is a treasure trove of amenities that harmoniously blend comfort, luxury, and the serenity of nature. Greet your guests in the formal dining room that boasts of character and is perfect for hosting festive occasions. The heart of the home, the kitchen, is outfitted with granite countertops and an island providing ample counter space, accompanied by plenty of storage and a walk-in pantry. The adjacent keeping room and sunroom overlook the stunning inground pool and jacuzzi, making it a perfect spot to unwind after a long day. The primary bedroom is conveniently located on the main floor, offering privacy and tranquility. The home also features a jack-n-jill bathroom and a jetted tub for that extra touch of luxury. But it's not just the interiors that will leave you enchanted. The property is home to a horse barn featuring 4 stables and turn out. The water is available to all fields, ensuring your horses have all they need. The fenced-in grounds include a well house, a tack/utility building, a pool storage outbuilding, and a three-bay building with power available. For the green thumbs, the driveway lined with crepe myrtles provides a beautiful entrance to the property. The front sprinkler system and gutters ensure your landscaping stays pristine, while the well pump house adds to the property's functionality. A short 10-minute drive from I-75, this peaceful and quiet retreat is a perfect escape from the hustle and bustle yet convenient for those necessary trips into town. So, whether you're a horse lover, an entertainer, or just someone craving tranquility and luxury, this property is perfect for you. Don't wait, schedule a tour today and explore the endless opportunities this property has to offer! This property has two parcels to it totaling the 14.2 acres.
MlsNumber: --
ListingId: 244843


Listing Provided By: LANDMARK REALTY, original listing
Phone: (478) 714-0804
Office Phone: (478) 987-9987
Agent Name: Kari Pollock
Disclaimer: Copyright © 2024 Central Georgia MLS. 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 = 467 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;
Real Estate Expert Photo for Bo Fricks
Bo Fricks
ASCIISouthern Classic Realtors - The Jamie Moorman Team
Call Today!: (478) 225-8815

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App