Title Page Background
DEBUG FN args: Array ( [0] => 454 [1] => [2] => [3] => agent ) BEFORE: Site: 454 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 454 Igate: njhud LocID: 454 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 = 454 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 454 [1] => [2] => [3] => lender ) BEFORE: Site: 454 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 454 Igate: njhud LocID: 454 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 = 454 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 454 [1] => [2] => [3] => other ) BEFORE: Site: 454 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 454 Igate: njhud LocID: 454 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 = 454 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

388 Double Tree Drive Se
Calhoun, GA 30701

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $675,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3892 Square Feet
Agency: Samantha Lusk & Associates Realty, Inc.
Agency Phone: (706) 629-3007

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1997
Notes: ABSOLUTELY STUNNING AND INSIDE THE CITY! This elegant and beautiful home offers comfort with its five bedrooms and 3.5 baths, situated on a large private lot complemented by a stunning Pebble Tec gunite pool! Enter through the front door into a two-story foyer, open and welcoming, with a staircase featuring oak treads. The main level boasts an open floor plan with newly installed flooring. The layout seamlessly connects the foyer, hearth room, living room, kitchen, and breakfast nook. The rear hallway extends from the kitchen to the master suite, linking the master bedroom, master bathroom, master closet, and laundry room. The front hallway proceeds to a half bath featuring a shiplap accent wall, then leads to the laundry room, and master closet. The recently remodeled kitchen boasts granite countertops, stainless steel appliances, custom white cabinets, a three-stool bar, and a walk-in pantry. The master bedroom is highlighted by large bay windows that offer a view of the private, wooded area at the rear. An updated master bath includes a new soaking tub flanked by two separate vanities with granite tops. It also features a custom tile shower, a water closet, and a linen closet. Additionally, there is an extra-large, his and hers master walk-in closet equipped with ample shelving for clothes and linens, as well as a custom desk with white cabinets. Bedroom #2 just off the living room has a front window, private bath & walk-in closet. The main level features 9-foot ceilings. The laundry room features shiplap walls, custom cabinets above the washer and dryer, a bespoke tub sink cabinet, and a built-in ironing center. A door from the rear kitchen hallway leads to a cozy, screened porch. The breakfast nook's door opens onto a large covered porch with views of the terraced backyard and the fenced, custom-designed private pool. The covered porch leads out to a spacious pressure-treated wooden sun deck, which includes stairs that lead down to the backyard.<br /> The upper level features three spacious bedrooms, a bathroom, and a mechanical room. Bedroom #3 boasts a large walk-in closet and a door providing access to the mechanical room and attic. A Jack and Jill bathroom connects to Bedroom #4, which includes a walk-in closet. Bedroom #5, also serving as a bonus room above the garage, offers two smaller walk-in closets and an additional large walk-in closet with a window and ample shelving for clothes. The partially finished walk-out basement exudes a rustic "man cave" feel with its wooden accent walls. It also includes a music room/study complete with a walk-in closet, as well as a spacious media room featuring an alcove ready for a refrigerator, microwave, and pantry area. One end of the man cave provides access to an unfinished workshop through an exterior door, which boasts a garage door, an exit door, and floor drain. A rear vestibule leads to an additional storage room, offering excellent potential for a bathroom conversion. It features an exterior door opening to a concrete grilling and entertaining space beneath the covered porch. A concrete walkway extends from this area to the enclosed, gunite pool, which includes a hot tub with a cascading waterfall. The pool is encircled by an ample concrete deck designed for sunbathing and relaxation, complemented by a curved design and natural stone edging. The property's three upper rear lawn terraces are divided by short rock retaining walls, perfect for seating. Privacy is enhanced by rock retaining walls that enclose two sides of the pool. A concrete pathway from the front driveway provides access to the side basement workshop garage, the rear grilling space, and the pool area. The property is conveniently located near Interstate 75, restaurants, shopping centers, schools, and the town center, yet it resides in a tranquil neighborhood. Seize the chance to make this incredible house your own!
MlsNumber: --
ListingId: 7410050


Listing Provided By: Samantha Lusk & Associates Realty, Inc., original listing
Phone: (404) 906-4872
Office Phone: (706) 629-3007
Agent Name: Sabrina Poole
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] => gordon-county [3] => GA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: gordon-county State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: gordon-county State: GA 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 = 454 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Simone Ford
Simone Ford
ASCIIMaximum One Community - Calhoun
Call Today!: (706) 271-5126

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App