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

5223 Ga Highway 135
Uvalda, GA 30473
J. Andrew Sleeth with HRP Realty, original listing - (478) 901-2091

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $280,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 2555 Square Feet
Agency: HRP Realty
Agency Phone: (478) 901-2091

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1966
Notes: Charming Cabin-Style Retreat on 1.62 Acres in Uvalda! Discover this enchanting 5-bedroom, 3-bathroom home, situated on a picturesque 1.62-acre lot surrounded by serene pine trees. Outside, this unique home seamlessly blends Spanish-inspired architecture with cozy cabin comforts, creating a tranquil and private haven. Step inside to find a spacious layout designed for relaxation and entertaining. The main level features a formal living room, dining area, and a generous kitchen with space for casual dining near the fireplace ideal for gatherings. A large family/game room and a sunroom provide additional space for leisure and enjoyment. The main floor also includes the primary bedroom, two additional bedrooms, and two full baths. Upstairs, you'll find two more spacious bedrooms, a full bath, and walk-in attic storage. The interior exudes warmth and charm, including areas with redwood beams across the ceilings and diamond grid windows with wood shutters. Whether you're unwinding in the comfortable living spaces or preparing meals in the kitchen, the character of this home shines throughout. Outside, the expansive lot offers endless possibilities. With the surrounding landscape ensuring privacy and a peaceful ambiance, making it an ideal escape from the hustle and bustle of city life. Don't miss the chance to make this charming retreat your own. Schedule a viewing today and embrace the serene lifestyle that awaits!
MlsNumber: --
ListingId: 10378178


Listing Provided By: HRP Realty, original listing
Phone: (478) 901-2091
Office Phone: (478) 901-2091
Agent Name: J. Andrew Sleeth
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