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

222 Valley View Drive
Rockmart, GA 30153
Ross Doyle with Harry Norman Realtors, original listing - (770) 422-6005

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,495,000
Beds: 6
Baths: Full: 5, ½: 1
Status: Active
SqFt: 6200 Square Feet
Agency: Harry Norman Realtors
Agency Phone: (770) 422-6005

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: Welcome to Valley View. Over 8 acres of secluded, fully fenced grounds; a delightful mix of pasture and hardwoods, yet only an hour from Atlanta, the property epitomizes all that is relaxed country living. The current owners spared no expense, transforming what was once a dated estate into the contemporary retreat it is today. Beyond the front porch, a spacious foyer offers a place to welcome guests. To one side is a keeping with built-ins and a beautiful, coffered ceiling. To the other side is a dining room spacious enough to seat 10. The foyer also offers views to the Great Room with its beamed cathedral ceilings, arched windows, and double height masonry fireplace. The primary suite is on main with a bathroom so expansive and well appointed, it's more akin to a spa. The farmhouse kitchen comes well equipped with custom cabinetry, Moroccan tile backsplash, leathered marble counters, and top of the line appliances. Its sprawling center island and adjacent dining area make it the heart of the home; offering a place for friends and family to congregate. A terrace flanks the back of the house; directly off the kitchen and great room, it serves as a convenient place for alfresco dining. On the second floor are three generously sized bedrooms all with their own ensuite baths, and 2 large flex spaces. Choose to use one as a media room, and the other as an in-house gym, or an office. Given its expansive footprint, the 2nd level with minimal improvements, could also function as its own independent in-law suite. The grounds are beautiful; kept lush and green by a newly installed 20-zone irrigation system. The current owners also added a 2300sf outbuilding replete with water and electrical. And 2 gates secure the property and provide both a main entrance and service entrance. The surroundings are private and park-like and just a stone's throw from Historic Rockmart: a small and quintessentially southern town. It is quaint and friendly and offers everything essential to convenient country living: hardware store, coffee shop, bank, and farmer's market. Come see for yourself: drive through the front gate and immediately you get the sense it offers something special. It's luxurious but un-fussy; a stately family retreat, relaxed enough to be enjoyed. Schedule your tour, today.
MlsNumber: --
ListingId: 7476663


Listing Provided By: Harry Norman Realtors, original listing
Phone: (770) 422-6005
Office Phone: (770) 422-6005
Agent Name: Ross Doyle
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