Title Page Background
DEBUG FN args: Array ( [0] => 555 [1] => [2] => [3] => agent ) BEFORE: Site: 555 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 555 Igate: njhud LocID: 555 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 555 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 555 [1] => [2] => [3] => lender ) BEFORE: Site: 555 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 555 Igate: njhud LocID: 555 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 555 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 555 [1] => [2] => [3] => other ) BEFORE: Site: 555 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 555 Igate: njhud LocID: 555 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 555 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

6821 Highway 5
Douglasville, GA 30135

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,500,000
Beds: 4
Baths:
Status: Active
SqFt: 6200 Square Feet
Agency: EXP Realty, LLC.

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Refrigerator, Oven - Double
Architectural Style: Other
Cooling: Ceiling Fan(s)
Flooring: Tile, Laminate, Tile - Ceramic
Heating: Central Furnace, Fireplace
Interior Features: Wet Bar, High Ceilings, Walk-in Closet(s), Tray Ceiling(s), Double Vanity, High Ceilings 9 Ft Lower, High Ceilings 9 Ft Main, High Ceilings 9 Ft Upper
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bathroom 5, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4

Window Features

Exterior Features: Rear Stairs
Parking Features: Garage
Roof: Composition

Neighborhood/Schools

Elementary School/District: South Douglas
Middle/Junior High School/District:
High School/District: Alexander
Subvidision Name: None

Description/Comments


Lot Size: 6 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: This stunning real estate property offers a luxurious and spacious living experience. Situated on 6.5 acres of land, with 3 acres cleared, this property provides ample space and privacy. The house features a detached garage measuring 51x30 feet, with four 10x10 feet doors, perfect for storing vehicles and equipment. The garage and the house are both constructed with four-sided brick, adding a touch of elegance and durability. As you enter the property, you will be greeted by a beautiful brick fountain in the front yard adding a charming focal point. The house itself spans approx 4400 sq ft (additional heated/cooled approx 1800 sq ft enclosed pool area) and features 4 bedrooms and 6 bathrooms. There are 4 full bathrooms and 2 half bathrooms, all tiled with gold fixtures, adding a touch of luxury to every space. The ceilings throughout the house are 10 1/2 feet high, creating an open and spacious feel. The doors are 8 feet high, adding to the grandeur of the property. The great room boasts a soaring 20-foot ceiling, making it the perfect space for entertaining or relaxing. The master bathroom is a true oasis, featuring his and her bathrooms and a wet room with dual shower heads with jets. The centerpiece of the master bathroom is a 43x72 heated tub with air bubbles, providing the ultimate relaxation experience. Upstairs, you will find a guest room with its own bathroom, offering privacy and comfort for visitors. On the main floor there are also Jack and Jill bedrooms with a bathroom in the middle, complete with dual sinks. For entertainment purposes, there is a spacious 17x33 feet party room with a bar along one wall. The bar is equipped with a full refrigerator, wine cooler, sink, and microwave. The room also features a video wall with four 65-inch TVs, surround sound, and an electric fireplace. The great room offers entertainment options, with an 85-inch TV, surround sound, and a 100-inch electric fireplace. Other notable features of the property include a formal dining room/office with French doors, an 8x6-foot iron pivot front door, a laundry room, and a walk-in pantry. The kitchen is a chef's dream, a 9-foot island with a waterfall edge, double oven, custom hood, 48-inch range top, microwave drawer, and a refrigerator. All appliances are top-of-the-line Zline stainless steel and polished gold. The kitchen also features white quartz counters with gold veins and all-white cabinets with glass doors on top that extend to the ceiling, creating a sleek and modern look. Throughout the entire house, there is luxury vinyl plank flooring, eliminating the need for carpet and providing easy maintenance. Additionally, all closets in the house are custom-designed, offering ample storage space. The backyard boasts a serene pond, creating a peaceful and relaxing atmosphere. Additionally, there is an enclosed 30x16 feet heated fiberglass pool with a hot tub providing year-round enjoyment. The luxurious hot tub, is the perfect spot to unwind and enjoy the soothing jets. Whether you're looking to relax after a long day or entertain guests. The pool itself is spacious and inviting, perfect for swimming laps or simply relaxing in the water. The heated feature ensures that the water is always at a comfortable temperature, regardless of the season. The fully automated system allows for easy control and maintenance of the pool and hot tub. With just a few clicks, you can adjust the temperature, turn on the jets, and even set a schedule for cleaning and maintenance. The heated/cooled patio area is perfect for outdoor gatherings, with a 75-inch TV, surround sound, and a fire pit. The attached glass enclosure surrounding the pool area not only adds a touch of elegance, but it also provides a comfortable environment year-round. Overall, this real estate property offers a combination of luxury, comfort, and entertainment options, making it the perfect place to call home.
MlsNumber: --


Listing Provided By: EXP Realty, LLC., original listing
Phone: (706) 333-1119
Office Phone: (888) 959-9461
Agent Name: Deena Simmons
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => ada [3] => ID [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: ada State: ID Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: ada State: ID Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 555 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
RASHELLE BOYER
ASCIIPremier Group Realty West
Call Today!: (208) 739-2484

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App