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;

5 Oak Street
Aragon, GA 30104
Susan Haddock with Keller Williams Realty Signature Partners, original listing - (678) 631-1700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $275,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1523 Square Feet
Agency: Keller Williams Realty Signature Partners
Agency Phone: (678) 631-1700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1900
Notes: Impeccably Renovated Ranch in the Heart of Aragon<br /> Step into your dream home! This beautiful recently (2020) renovated single-story ranch rests on a spacious lot with a fully fenced backyard, offering both privacy and charm in downtown Aragon. From the ground up, every inch of this home has been thoughtfully upgraded including the HVAC, electrical, plumbing, and roof, balancing modern sophistication with timeless design elements. Welcome guests on the oversized rocking chair front porch, leading into an open-concept floor plan with soaring 10-foot ceilings. Meticulously crafted baseboards, elegant crown molding, and luxurious LVP flooring flow throughout, creating a perfect space for entertaining or unwinding after a long day. At the heart of the home lies a chic, modern kitchen, featuring pristine white cabinetry, stunning stone countertops, a sleek glass tile backsplash, and stainless-steel appliances. Whether you're a seasoned chef or love hosting gatherings, this kitchen promises both functionality and style. The kitchen opens to the dining area, ideal for family dinners, game nights, or holiday celebrations, which then leads seamlessly into the cozy family room. The primary suite is an oasis of elegance, boasting a shiplap accent wall, ceiling fan, and a walk-in closet with ample storage. The spa-inspired ensuite bath elevates the experience with thoughtful touches, ensuring comfort and relaxation. Two additional bedrooms with spacious closets share a large bathroom featuring upgraded cabinetry and marble countertops. Practicality meets convenience with a well-appointed laundry closet, complete with shelving to keep everything organized. Step outside into the expansive backyard, enclosed by a brand-new privacy fence, offering the ideal setting for outdoor entertaining, gardening, or simply enjoying some peaceful downtime. This exceptional home is a rare find, blending luxury, comfort, and modern convenience. Don’t miss your chance to call this exquisite house your forever home! Schedule a tour today.
MlsNumber: --
ListingId: 7476348


Listing Provided By: Keller Williams Realty Signature Partners, original listing
Phone: (678) 232-2300
Office Phone: (678) 631-1700
Agent Name: Susan Haddock
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