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

2387 Battle Drive
Villa Rica, GA 30180
Linde Moore with Keller Williams Rlty, First Atlanta, original listing - (404) 531-5700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,300,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 3531 Square Feet
Agency: Keller Williams Rlty, First Atlanta
Agency Phone: (404) 531-5700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: Your Lakeside Dream Awaits! Wake up to breathtaking, panoramic lake views in this extraordinary lakeside retreat in the sought-after Fairfield Plantation gated community. Perfectly positioned on one of the best homesites in the neighborhood—boasting over half an acre and 200 feet of pristine lake frontage—this home offers an unparalleled waterfront lifestyle. Meticulously redesigned in 2023, every inch of this home was thoughtfully renovated down to the studs, ensuring no detail was overlooked. Step inside, and the serene, open water views through the Andersen windows will take your breath away, greeting you from nearly every room. The open-concept design and soaring vaulted ceilings create a light, airy ambiance, seamlessly blending indoor comfort with outdoor beauty. At the heart of the home, the chef-inspired kitchen is a true masterpiece, featuring custom cabinetry wrapping around the entire space, an oversized island with seating for six, and top-of-the-line finishes designed for both function and style. Whether you're entertaining guests or preparing a quiet meal, this kitchen will elevate every experience. Retreat to the luxurious primary suite, where the lake becomes an extension of your bedroom. Vaulted ceilings and stunning water views make this a true sanctuary. The spa-like ensuite bath is designed for ultimate relaxation; featuring heated floors, a double vanity, a jetted and heated soaking tub, and a walk-in shower—a place where every day feels like a getaway. Three additional bedrooms on the main level offer comfort and flexibility, including a secondary ensuite with its own private deck access and lake views. The fully finished basement is an entertainer’s dream, complete with a wet bar, rec room, full bath, and sliding door access to the lake—the perfect space for hosting or unwinding after a day on the water. Step outside and embrace lake life to the fullest! The expansive rear deck spans the entire width of the home, offering the perfect setting for morning coffee, sunset cocktails, or stargazing over the water. A sunroom provides year-round enjoyment, while your private dock with an electric boat lift ensures you're always just moments away from an adventure on the lake. Beyond your doorstep, Fairfield Plantation offers a resort-style experience with three fishing and ski lakes, an 18-hole golf course and country club, an Olympic-size pool with a splash pad, pickleball and basketball courts, a playground, a game room, scenic nature trails, a full-service marina with slips and dry storage, and year-round community events. With 24-hour onsite security and a dedicated fire department, peace of mind is built into the lifestyle. This isn’t just a home—it’s an experience, a retreat, a dream come true. Schedule your private tour today and prepare to fall in love with lakefront living like never before!
MlsNumber: --
ListingId: 7533776


Listing Provided By: Keller Williams Rlty, First Atlanta, original listing
Phone: (404) 991-6529
Office Phone: (404) 531-5700
Agent Name: Linde Moore
Disclaimer: Copyright © 2025 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

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 = 412 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;
Real Estate Expert Photo for Rett Harmon - Rettro Group
Rett Harmon - Rettro Group
ASCIICentury 21 Novus
Call Today!: (678) 699-4505

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App