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 = 2915 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 = 2915 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 = 2915 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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;

3091 Robinson Road Ne
Marietta, GA 30068

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,295,000
Beds: 6
Baths: 6
Status: Active
SqFt: 6611
Agency: Realty One Group Edge

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2006
Notes: PRICE IMPROVEMENT!! HURRY TO THIS STUNNING CUSTOM-BUILT HOME on a LARGE, LEVEL, .45 ACRE LOT IN THE HIGHLY SOUGHT-AFTER WALTON HIGHSCHOOL DISTRICT! This beautiful, four-sided brick, English Manor sits back on the lot boasting stately curb appeal and luxury finishes inside and out! The tall wrought-iron double front door leads to a grand, light-filled foyer accenting the gleaming hardwoods and fresh paint throughout. Every detail was considered for this home, including two master ensuites- one on each level, two fireplaces, three laundry rooms, three HVAC units, a three car garage and two full kitchens!! WOW!!! The main level eat-in gourmet kitchen overlooks the family room and features high-end stainless steel appliances, including oven with warming drawer and custom cabinets. This palatial home has a total of 6 bedrooms as well as a private office! Retreat to the main-level Master Bedroom with space for a sitting area, large, custom walk-in closet and private en-suite bath with dual vanities. The second-floor Master Suite features a double-shower and a walk-in closet. The fully finished basement makes an excellent in-law suite, guest room, or teen space with two bedrooms, full kitchen, entertainment space and bathroom. Beautiful French doors open to a private, level backyard adorned with purple and white butterfly bushes, hydrangeas, and honeysuckle! LUXURY LIVING with NO HOA in the heart of EAST COBB! Close to top schools, shopping, restaurants. Walk to Fullers and East Cobb Parks! Fox Hollow Swim and Tennis nearby. THIS GORGEOUS ESTATE CHECKS ALL OF THE BOXES!!
MlsNumber: 7339481


Listing Provided By: Realty One Group Edge, original listing
Name: Realty One Group Edge
Phone: (678) 909-7709
Office Name: Realty One Group Edge
Office Phone: (678) 909-7709
Agent Name: Grace Mcdade
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