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

13090 Freemanville Road
Milton, GA 30004

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $8,975,000
Beds: 4
Baths: Full: 4, ½: 4
Status: Active
SqFt: 24888 Square Feet
Agency: Atlanta Fine Homes Sotheby's International
Agency Phone: (770) 442-7300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Back on Market - Buyer Financing Fell Through. Proudly introducing, Milton's most iconic estate. Drive into luxury in this rare, custom-built to commercial-grade specs 24K square foot home situated all on one level. The fully gated property sits at the back of a 9+/- acre parcel less than one mile to the shops and restaurants of downtown Milton and just 30 minutes north of downtown Atlanta. This distinctive, award-winning estate offers a premium opportunity for the discerning buyer or car enthusiast looking for a versatile investment. The home also features a 14+ five bay car garage, an exercise room with a sauna and a steam room, two additional owner's suite sized bedrooms, a manicured and level front yard suitable for helicopter landings or equestrian pursuits, enormous executive office, library, lounge with curved bar for entertaining, and a home theater/media room custom-designed for sound, this home checks every box for quality and luxury. A stunning extended drive leads to a sprawling one level home designed in a neoclassical style where significant value lies beneath the surface. Its complete commercial build includes a steel and concrete structure, a commercial boiler with a cooling tower, 22 separate temperature-controlled HVAC systems with their own thermostats and an artificial rubber-slate roof. Its robust electrical service and generator capacity are enough to support industrial applications and high-power-consuming activities, while a 125KVA emergency generator ensures uninterrupted power during outages or emergencies. Luxurious one-level living awaits beyond the courtyard and porte cochere. Lofty ceilings soar to 25'. Three magnificent domed ceilings, including the towering 27' living room dome, add grandeur. Sunlight spills through floor-to-ceiling windows throughout, highlighting exquisite custom millwork gracing the window and door trim, marbled floors featuring seven unique designs and 153' of groined vault hallway space. Elegant mahogany cabinetry accents the kitchen, the library, the office, the primary bedroom, and the bathroom spaces, adding timeless beauty and functionality. Discover a sprawling, temperature-controlled 14+ car garage equipped with 220-volt wiring and high-voltage hookups, ideal for any automotive enthusiast or hobbyist. Also featuring a complete workshop area with built-in cabinetry and five garage bay openings-including one bay specially designed to accommodate motorhomes or boats-the garage offers versatility and convenience for various vehicle types and projects. A full wing of the home currently houses a 4,400+/- square-foot Old West town replica with working rooms including a saloon/bar and two half baths. The space was meticulously modeled after Tombstone, Arizona, circa 1800s. This wing could be adapted for a variety of lifestyle needs such as additional bedroom suites and living areas, a full-size basketball court or indoor pool - the sky is the limit! The home also features an additional 15K sq ft of unfinished basement space complete with large garage door access. Exceptional in quality, stature and livability, it is a luxury home like no other. Welcome to 13090 Freemanville Road.
MlsNumber: --
ListingId: 7497691


Listing Provided By: Atlanta Fine Homes Sotheby's International, original listing
Phone: (404) 713-7713
Office Phone: (770) 442-7300
Agent Name: Bonnie Smith
Disclaimer: Copyright © 2024 First Multiple Listing Service, Inc. 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 = 3402 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 Forrest Rusca
Forrest Rusca
ASCIIBerkshire Hathaway Home Services, GA
Call Today!: (678) 642-2015

Local Mortgage Pro

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 = 3402 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;
Michael Rishel NMLS#227604
ASCIICTC Funding and Mortgage
Call Today!: (404) 423-6621

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App