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

407 Mill House Road
Sparta, GA 31087
Ginny Vanoostrom with Algin Realty, Inc., original listing - (770) 616-4460

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,499,900
Beds: 7
Baths: Full: 6, ½: 1
Status: Active
SqFt: 8824 Square Feet
Agency: Algin Realty, Inc.
Agency Phone: (770) 616-4460

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 272 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Who said you can not have it all? If you love the outdoors, this is a MUST SEE. It is resort living without ever leaving your home. This gated 277 acre estate greets you at the gate with a winding driveway past the income producing pecan orchard, open pastures filled with cows and horses, and 2 beautiful lakes. As you get closer to the breathtaking main custom home, you will enter through a second gate and it sits atop a hillside. It is a picture of southern splendor, similar to the historic columned homes of the 1900's, but built in 2006, this estate leaves no stone unturned. The heavy trim throughout, soaring ceilings, spiral staircase, custom cabinetry and built ins, and beautiful wood flooring, large rooms, spray foam insulation, custom shutters, and beautiful lighting shows the attention to detail is abundant. This is an amazing full time residence or rent it for weddings or corporate events. It features a parlor entry, gourmet kitchen, formal living and dining room, amazing great room Overlooking the inground pool, fitness center, and 3 oversized bedrooms upstairs, each with their own bath. The River house is located on the Ogeechee river. 3 bedrooms and 2 baths on a full unfinished basement. Fish from your deck and enjoy listening to the water as it passes by. The last house, the cabin, overlooks the upper stocked pond. This quant cabin features one bedroom, 1 bath and would be perfect for Airbnb. Multiple barns and workshops are located throughout the property. This is one amazing piece of property that has many income producing opportunities. How many places can you swim, hunt, hike, ride horses, canoe, ride four wheelers, fish, and hit golf balls all in the same day without leaving the gates of your property. Appointment required and proof of funds or prequal letter prior to showing.
MlsNumber: --
ListingId: 20160765


Listing Provided By: Algin Realty, Inc., original listing
Phone: (770) 616-4460
Office Phone: (770) 616-4460
Agent Name: Ginny Vanoostrom
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App