Title Page Background
DEBUG FN args: Array ( [0] => 506 [1] => [2] => [3] => agent ) BEFORE: Site: 506 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 506 Igate: njhud LocID: 506 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('gahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 506 [1] => [2] => [3] => lender ) BEFORE: Site: 506 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 506 Igate: njhud LocID: 506 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('gahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 506 [1] => [2] => [3] => other ) BEFORE: Site: 506 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 506 Igate: njhud LocID: 506 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('gahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

34 Hudson Loop Road
Aragon, GA 30104

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $99,900
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Maximum One Realty Greater ATL.

Map Details Show Map | Show StreetView




House Features

Architectural Style: Other

Window Features

Waterfront Features: Waterfront

Neighborhood/Schools

Elementary School/District: Eastside - Polk
Middle/Junior High School/District:
High School/District: Rockmart
Subvidision Name: None

Description/Comments


Lot Size: 5 acre(s)
Property Type: Land-Unimproved Land
Year Built: --
Notes: Welcome to 34 Hudson Loop Road! Check out this 5.17 acre lot for sale located in Polk County and nestled in the heart of Aragon, GA. This property is a rare gem, offering a serene and tranquil lifestyle, away from the hustle and bustle of city life. As you step onto this property, you are greeted by the gentle whisper of the wind rustling through the trees, the chirping of birds and the view of the private lake. This lake, a unique feature of the property, adds an element of tranquility and beauty, making it a perfect spot for fishing, watching wildlife, or simply enjoying a picnic by the water. <br /> <br /> Imagine waking up to the sight of the sun rising over the lake, sipping your morning coffee while enjoying the peacefulness of nature, or spending your evenings stargazing without the interference of city lights. The location of this property is another one of its many advantages. It is situated just minutes away from historic Downtown Rockmart, where you can enjoy a variety of shopping and dining options. The proximity to Hwy 101 and Hwy 278 makes commuting a breeze, and the popular Silver Comet Trail is also nearby, perfect for those who enjoy biking, hiking, or running. <br /> <br /> This property offers a unique blend of tranquility, convenience, and potential. 34 Hudson Loop Road is an opportunity you don't want to miss. Experience the beauty, serenity, and potential of this property for yourself. Your dream of owning a piece of paradise in Aragon, GA could be just a phone call away. Accuracy of all information deemed reliable but not guaranteed and should be verified by interested parties.
MlsNumber: --


Listing Provided By: Maximum One Realty Greater ATL., original listing
Phone: (770) 919-8825
Office Phone: (770) 919-8825
Agent Name: Bill Hornsby
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