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

7395 Old Rico Rd.
Chattahoochee Hills, GA 30268

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,395,000
Beds: 6
Baths: 6
Status: Active
SqFt: 6960
Agency: barfield realty, llc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 30 acre(s)
Property Type: Residential
Year Built: 1999
Notes: Come home to this immaculate one-owner custom-built home in pastoral area on 30.5 gently-rolling acres! Relax and enjoy the private, peaceful setting (and the deer) in the heart of Chattahoochee Hills only 5 minutes from Serenbe. Sprawling one level ranch with full finished basement offers nearly 7000 sq. ft. of finished space. BRAND NEW ROOF! Main level features split bedroom plan with huge master with built-ins and a large master bath with jetted tub, separate shower and dual vanities. 3 additional big bedrooms, one with its own bath. Spacious kitchen with oak cabinets, solid surface counters and adjoining breakfast area. Huge vaulted family room with fireplace and built-ins. Separate large den or library, plus a cozy reading nook. Downstairs boasts an enormous open room, a media room, another large room that could be a great exercise gym, office, full kitchen (minus stove) and a jack 'n' jill bedroom arrangement, plus a utility room with boat door. This home oozes Pride of Ownership and high quality construction throughout! 3- car garage plus a large exterior workshop with electricity complete this rare gem! The land is mostly wooded with a lovely creek in the rear of the property. From the moment you begin your drive down the gorgeous, winding driveway, you'll continually see why this is one of the unique and great values in the area! A must see!
MlsNumber: 20175945


Listing Provided By: barfield realty, llc, original listing
Name: barfield realty, llc
Phone: (770) 301-3268
Office Name: Barfield Realty LLC
Office Phone: (770) 301-3268
Agent Name: Bob Barfield
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