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

490 Birkdale
Fayetteville, GA 30215
Mechelle Bowser with Virtual Properties Realty.com, original listing - (770) 495-5050

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,450,000
Beds: 4
Baths: Full: 3, ½: 2
Status: Active
SqFt: 5054 Square Feet
Agency: Virtual Properties Realty.com
Agency Phone: (770) 495-5050

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1993
Notes: Gorgeous modern estate on amazing private lot with incredible views of the 4th green golf course in well sought after Whitewater Creek Gated Golf Course Community. This luxurious retreat meets elegance and comfort. A grand half circle driveway welcomes you to this modern breathtaking estate. Step into the grandeur of this home through a two-story foyer with a magnificent 80 bulb $20,000 dollar chandelier, this foyer leads you to a sunlit wall of windows living room and an inviting view of the pool and golf course. With two separate entertaining spaces and access to one of two outdoor leisure area, this home is perfect for family gatherings. The main floor includes a formal open dining room, creative office space, open kitchen with bar, private guest suite, gym and much more. Upstairs you will discover a primary suite with fireplace and balcony that overlooks the pool and golf course - a perfect blend for morning coffee. The primary suite was thoughtfully designed with a to die for spa like bathroom and super primary closet! Also, upstairs you have a sunlit dressing room made for a fashionista, the space is incredible, and this room too has a balcony that overlooks the pool, what a way to start your day. There is also a huge bedroom retreat, that is large enough to be used as a media room or create your own creative space. As we visit the exterior you have the sounds of the waterfall saltwater pool and hot tub. For the nights that are chilly, there is also a fireplace and a cabana to entertain guests. You and your guests will never want to leave this resort style estate. Located in award winning Starrs Mill school district, residents enjoy direct access to Peachtree City multi use golf course paths. And we have the golf cart parked in the garage for your convenience. Cloe proximity to entertainment venues, shopping, schools, Trilith Studios and the upcoming US Soccer Federation Headquarters adds to the appeal of this exceptional property. Please schedule a viewing , this property will not last long .
MlsNumber: --
ListingId: 10438791


Listing Provided By: Virtual Properties Realty.com, original listing
Phone: (770) 495-5050
Office Phone: (770) 495-5050
Agent Name: Mechelle Bowser
Disclaimer: Copyright © 2025 Georgia Multiple Listing Service. 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 = 3273 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;
Jerri Sims
ASCIIFirst Choice Realty Group
Call Today!: (770) 634-1892

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App