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

115 Old Stewart
Forsyth, GA 31029
Robert Uzar with HomeSmart, original listing - (404) 876-4901

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 5070 Square Feet
Agency: HomeSmart
Agency Phone: (404) 876-4901

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 56 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: A Countryside Haven on 56 Acres for Generations to Enjoy. Don't miss out on this private estate with lake and 56 acres to call your own. It's a magnificent opportunity to get away from it all. Nestled on a sprawling estate, this custom-built home is a sanctuary of peace, comfort, and timeless craftsmanship. Designed with structural integrity and energy efficiency at its core, this solid concrete property offers a lifestyle of serenity and security. The 10-foot wrap-around porches invite you to unwind as you take in breathtaking views of your private lake. Each day here feels like a retreat into nature. Built to endure, the main level and basement utilize ICF (Insulated Concrete Forms), a cutting-edge construction method that withstands tornado-force winds while significantly reducing energy costs. Savings of 20% or more on your utility bills while living in a home that exudes warmth and stability. Step through the glass doors from the porch and discover a thoughtfully designed open floor plan. The living and dining areas flow seamlessly, providing the perfect gathering setting. Two spacious main level owner's suites, each with a private bath, ensure comfort and privacy for you and your loved ones. A large walk-in pantry and a versatile office or third bedroom complete the main level. The charm deepens as you descend the handcrafted wood spiral staircase to a fully finished basement. Here, you'll find a second full kitchen, an additional bedroom and bath, and a safe room. Ascending outside on the staircase you'll come to the unfinished upper level which offers boundless potential-imagine it as a guest suite, rental unit, or private living space for extended family. This home is equipped with radiant floor heating, Pella double-pane windows, a Westinghouse tankless water system, and a 20KW automatic standby generator for ultimate peace of mind. Beyond the main home, the property includes multiple sheds, a pole barn, and even an onsite mobile home, ideal for rental income or extended family use. Whether you're looking to create a multigenerational retreat, a hobby farm, or simply enjoy the tranquility of countryside living, this property offers limitless possibilities. Schedule your private tour today and envision the legacy you can build here.
MlsNumber: --
ListingId: 10430787


Listing Provided By: HomeSmart, original listing
Phone: (404) 876-4901
Office Phone: (404) 876-4901
Agent Name: Robert Uzar
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.


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 = 493 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 Darvin Ebanks
Darvin Ebanks
ASCIIFickling & Company Inc.
Call Today!: (478) 444-3928

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App