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

1620 River Cove Road
Social Circle, GA 30025
Tiffney Riffle with Keller Williams Premier, original listing - (678) 487-1600

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3657 Square Feet
Agency: Keller Williams Premier
Agency Phone: (678) 487-1600

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1994
Notes: Exquisite 3-Story Home on Almost 5 Acres with Luxurious Upgrades, Finished Basement, and Outdoor Retreat<br /> <br /> Welcome to your dream home! This 5-bedroom, 3.5-bathroom masterpiece, set on nearly 5 private acres, offers the perfect blend of elegance, functionality, and outdoor charm. Spanning three stories, this home boasts a thoughtfully updated interior and exterior features designed to impress.<br /> <br /> Step into the updated kitchen, a chef’s paradise featuring stainless steel appliances, including a trash compactor and a wine/drink fridge. The kitchen also offers a separate pantry for additional storage. All bathrooms have been beautifully updated with new fixtures, showers, and tile work, providing a spa-like experience in the comfort of your own home.<br /> <br /> The master bedroom is a true retreat, complete with a private balcony, perfect for your morning coffee or evening relaxation. The finished basement is an entertainer’s dream, offering a second partially completed kitchen, ideal for hosting guests or creating a separate living space. The basement also features a second laundry area and a third garage, perfect for storing lawn equipment or additional vehicles.<br /> <br /> Step onto the two-tiered back deck, perfect for entertaining or unwinding while overlooking the meticulously landscaped backyard. The property features multi-level retaining walls that add dimension and beauty to the outdoor spaces. Enjoy tending to the herb gardens, which include organic blueberry bushes, oregano, and jasmine, providing fresh produce and fragrant blooms right outside your door. The backyard is also adorned with lush Zoysia grass and a charming gazebo, offering plenty of space for relaxation and gatherings.<br /> <br /> The property includes a 40x60 workshop with a concrete floor, ideal for projects, hobbies, or additional storage, as well as a 24x12 wood shop for added functionality. A second driveway provides direct access from the main road to the workshop, ensuring seamless accessibility.<br /> <br /> For equestrian enthusiasts or those seeking additional outdoor options, approximately 3 acres of fenced pasture make this property suitable for horses or other livestock, adding a unique and versatile feature to this already stunning home.<br /> <br /> Situated in a desirable subdivision, this home offers access to an optional HOA that includes amenities such as a community pool, enhancing the neighborhood’s appeal and your lifestyle.<br /> <br /> This extraordinary property offers more than just beauty—it’s a lifestyle. Don’t miss your chance to own this remarkable home and acreage. Schedule your private tour today!
MlsNumber: --
ListingId: 7490202


Listing Provided By: Keller Williams Premier, original listing
Phone: (470) 286-2912
Office Phone: (678) 487-1600
Agent Name: Tiffney Riffle
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.


Local Real Estate Expert

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 = 538 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;
Real Estate Expert Photo for Gayla Cagle
Gayla Cagle
ASCIISettin' Roots Realty
Call Today!: (706) 972-7299

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App