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

4945 Heirloom Overlook
Cumming, GA 30040

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $787,408
Beds: 4
Baths: 4
Status: Active
SqFt: 3200
Agency: EA Brokerage LLC.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: Welcome to your sanctuary at Heirloom, where every day feels like a retreat in the lap of luxury living! Nestled in the breathtaking embrace of Sawnee Mountain preserve, this dream community invites you to immerse yourself in the beauty of nature, with trails, biking, and hiking just moments away.<br /> <br /> Step inside the exquisite Alexander plan, a masterpiece of design and functionality. The open floor plan seamlessly blends elegance and practicality, creating a space that is as inviting as it is sophisticated. With three spacious bedrooms on the main floor, each accompanied by a luxurious full bath, this home promises comfort and convenience at every turn.<br /> <br /> Indulge your senses in the carefully curated upgrades, meticulously chosen by our award-winning design studio.<br /> <br /> Picture yourself sipping your morning coffee on the charming front porch, where the sun rises over Sawnee Mountain, casting a warm glow on the tranquil surroundings. Your gaze will be drawn to the serene views, creating a perfect backdrop for your daily moments of reflection.<br /> <br /> Step outside to your large covered patio in the back, a private oasis where you can unwind and entertain guests, surrounded by the beauty of nature. As the day unfolds, retreat to the bonus area upstairs, complete with an additional bedroom and bath, providing a versatile space for work, play, or relaxation.<br /> <br /> Heirloom is not just a place to call home; it's a highly sought-after community known for its incredible amenities and the effortless connections it fosters among new friends and neighbors. Experience the epitome of modern living, where every detail has been thoughtfully considered to enhance your lifestyle.<br /> <br /> Don't miss the opportunity to make Heirloom your forever home, where luxury, nature, and community converge to create an unparalleled living experience. Your dream home awaits – come and claim it!
MlsNumber: 7368429


Listing Provided By: EA Brokerage LLC., original listing
Name: EA Brokerage LLC.
Phone: (770) 541-5250
Office Name: EAH Brokerage, LP
Office Phone: (770) 541-5250
Agent Name: Kristen Triplett Gideon
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] => cape-may [3] => NJ [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: cape-may State: NJ Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: cape-may State: NJ 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 = 1772 AND i.igate IN ('nvhud','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 = 'nvhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Angela DiAntonio
Angela DiAntonio
ASCIIPlatinum Real Estate
Call Today!: (609) 741-1021

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App