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;

1507 Rocky River Drive
Lawrenceville, GA 30045

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $800,000
Beds: 5
Baths: 5
Status: Active
SqFt: 6119
Agency: RE/MAX Center

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2007
Notes: Gorgeous executive home in the Archer High School district. 3 car Side Entry Garage. This immaculate home is situated on a park-like backyard that backs up to a forest. The primary Suite on the main level is oversized with a sitting area. Huge bathroom with double granite vanities, jetted tub, walk-in shower and huge closet. Hardwoods throughout the main except the bedroom and bathroom. Study with French doors, built-in desk and coffered ceilings. The study could be converted to a 2nd bedroom on the main. Vaulted great room with a floor-to-ceiling stack stone fireplace. Custom stained kitchen cabinets, granite counters, double wall ovens, gas cooktop, corner pantry and large breakfast room. Formal dining room with double tray ceiling. Main-level laundry room with laundry sink & space for your 2nd fridge or freezer. Screen porch that you can access from the breakfast room, or the primary suite, has amazing views. Upstairs there are 3 extra- large bedrooms that all feature roomy closets and 2 full bathrooms. You will love the finished basement that has a den, a billiard room with tray ceilings, media room with comfy seating, surround sound, and projector, kitchenette with a microwave, fridge and sink, full bath, large guest bedroom, and a 2-room workshop with 6-foot doors to the side yard. Upgraded trim throughout the house. Large deck for entertaining plus a lower stone patio that features an outdoor kitchen area. Take the stone stairs to the stone fire pit patio. Lush green grass with flowering plants all over the backyard. Brick on all four sides with stone accents and concrete siding. You don't come across a home with these gorgeous finishes and upgrades every day.
MlsNumber: 7371800


Listing Provided By: RE/MAX Center, original listing
Name: RE/MAX Center
Phone: (770) 932-1234
Office Name: RE/MAX Center
Office Phone: (770) 932-1234
Agent Name: Susan Mobbs Kliesen
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App