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

5460 Union Rd
Hahira, GA 31632
Nathan Smith with THE HERNDON COMPANY, original listing - (229) 244-1992

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,500
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2671 Square Feet
Agency: THE HERNDON COMPANY
Agency Phone: (229) 244-1992

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2010
Notes: CHECK OUT this BEAUTIFUL PROPERTY located in HAHIRA GA (NORTH LOWNDES COUNTY). (2) HOMES (MAIN HOUSE 4292 Ft under Roof) , Mobile Home (2080 ft Under Roof), POLE BARN (1280 Ft), TOOL SHED (500 Ft) ALL ON 6.79 ACRES of HIGH & DRY LAND. You will LOVE the SPACE in the PRIMARY HOME with LARGE LIVING or FAMILY ROOM with LVP FLOORING, HIGH VAULTED CEILING and BRICK REAL WOOD BURNING FIREPLACE. The KITCHEN FEATURES PLENTY of CUSTOM CABINETS, JENN-AIR STOVE TOP & GRILL, REFRIGERATOR, DISHWASHER, Double Sinks, WALL OVEN & MICROWAVE , LARGE ISLAND BAR, and a HUGE LAUNDRY & PANTRY ROOM with SINK , CABINETS and FOLDING Counter. The MASTER SUITE FEATURES a TREY CEILING, (2) WALK-IN CLOSETS, DOUBLE VANITIES, LARGE TUB and VERY SPACIOUS WALK-IN TILE SHOWER. The Other 2 Bedrooms are also very SPACIOUS with CARPET and WALK-IN CLOSETS. This BEAUTIFUL HOME also includes a Small OFFICE ROOM with Pocket Door, WIDE FRONT PORCH and LARGE BACK SCREEN PORCH COMPLETE with ANOTHER REAL BRICK FIREPLACE and HOT TUB for your ENJOYMENT and an OVERSIZED GARAGE with TWO Doors and Utility Room. The 2ND HOME is a VERY NICE and WELL KEPT 1680 FT Heated Mobile Home with METAL ROOF, TWO-CAR CARPORT with a Large SCREEN PORCH. It FEATURES 3 BR'S, 2 Full BA'S , Dining Room, Living Room Area with WOOD BURNING Heater, and a Space for a Home Office. The Primary Bedroom comes with a Walk-in closet and Tub/Shower Combo making this a GREAT HOME for OLDER PARENTS or ADULT CHILDREN. The Main HOME also comes with a TERMITE BOND and SECURITY SYSTEM. PLENTY of LAND (6.79 ACRES), TWO HOMES, POLE BARN, TOOL SHED in a GREAT LOCATION. Do NOT MISS THIS OPPORTUNITY !!! CALL TODAY for AN APPOINTMENT !!!
MlsNumber: --
ListingId: 143593


Listing Provided By: THE HERNDON COMPANY, original listing
Phone: (229) 244-1992
Office Phone: (229) 244-1992
Agent Name: Nathan Smith
Disclaimer: Copyright © 2025 South Georgia MLS (Valdosta). 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