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

7005 Mandevilla Lane
Douglasville, GA 30135

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2623
Agency: Better Homes and Gardens Real Estate Metro Brokers

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2007
Notes: Welcome Home!! Seeking luxury living, privacy and endless space? Well, this exquisite home is waiting on you! You will enjoy all the this breath-taking home has to offer, with wrought-ion spindles greeting you at the staircase, 2-story family room -ideal for entertaining and as you enter the grand foyer, you'll be captivated by the radiant hardwood floors that adorn the main level, also greeted by a formal dining room with custom crown-molding, wainscoting and oil-rubbed bronze center light fixture!<br /> Entertain with class flair in this stunning kitchen, boasting granite countertops, eat-in area, island bar area ideal for bar stool, pantry, undermount stainless sink and greeted by stainless steel appliances, and a side-by-side refrigerator. When the festivities wind down, retreat to the expansive living room, where the warmth of the fireplace and recessed lighting sets the perfect ambiance for cozy conversations. Or you can relax in the cozy screened in sunroom, off of the eat-in area!<br /> Upstairs, tranquility awaits in the serene bedrooms, each adorned with plush new carpeting and offering ample closet space to accommodate your wardrobe needs. One of the guest bedrooms can also serve as an entertainment area, due to the openness and bonus sitting area. The main-level master suite is a sanctuary of its own, featuring a tray-ceiling, an updated ensuite bath, with a large garden tub, double vanity with granite and undermount sinks, custom frameless shower door and a generously sized walk-in closet for added convenience.<br /> With three additional bedrooms on the second level, along with a full bath designed in a jack-and-jill style with separate sinks, this home effortlessly caters to the needs of families of all sizes. And let's not forget the expansive one-acre lot, providing the perfect backdrop for outdoor enjoyment and relaxation. Discover versatility and elegance at every turn in this remarkable home, where luxury living meets the tranquility of nature. Welcome home to your personal oasis of comfort and style.
MlsNumber: 7402211


Listing Provided By: Better Homes and Gardens Real Estate Metro Brokers, original listing
Name: Better Homes and Gardens Real Estate Metro Brokers
Phone: (404) 843-2500
Office Name: BHGRE Metro Brokers
Office Phone: (404) 843-2500
Agent Name: Shannon Byrdsong
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] => douglas-county [3] => GA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: douglas-county State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: douglas-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 = 438 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;
Yolonda Steward
ASCIIHeritage Oaks Realty
Call Today!: (585) 285-9447

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App