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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

1513 Battle Brook Ne
Conyers, GA 30012

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $384,930
Beds: 4
Baths: 3
Status: Pending
SqFt: --
Agency: Crown Realty Professionals

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: 2 MILES-TO I-20, LAKE, PLAYGROUND, EXERCISE PAD WALKING AND BIKE TRAIL. UP TO 7K CLOSING COST WITH PREFERRED LENDER. CLOSE TO SHOPS, RESTAURANTS AND HOSPITAL. This incredible floor plan has a brick front and sits on a nice lot. Open the door to a formal dining room that is perfect for entertaining family and friends. The spacious kitchen boasts granite countertops, white cabinets with crown molding, Whirlpool stainless steel appliances, nice walk-in pantry, recessed lighting, and Mohawk Rev wood flooring throughout the entry level. The island opens to a dynamic breakfast area and flows effortlessly into a luxurious family room. Imagine enjoying your morning coffee on your second level deck listening to the birds chirp. Upstairs offers an oversized private owner's suite with trey ceilings, spa-like bath with a double vanity, separate shower / soaker tub, and a HUGE walk-in closet. Large secondary bedrooms have tons of natural light and plentiful closet space. You will never be too far from home with Home Is Connected. Your new home is built with an industry leading suite of smart home products that keep you connected with the people and place you value most. Brookstone Lakes is one of the fastest selling communities in the Conyers, GA area! Call TRACEY JORDAN at 704-968-9590 to schedule your appointment today! Photos used for illustrative purposes and do not depict actual home.
MlsNumber: 10246284


Listing Provided By: Crown Realty Professionals, original listing
Name: Crown Realty Professionals
Phone: (678) 509-0560
Office Name: D.R. Horton Realty of GA Inc.
Office Phone: (678) 509-0555
Agent Name: Tracey Jordan
Disclaimer: Copyright © 2024 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App