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

2909 Newton Highway
Newton, GA 39870
Tyler A. Inlow with Premier Group Realty, original listing - (229) 246-9837

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $169,000
Beds: 1
Baths: Full: 1
Status: Pending
SqFt: 562 Square Feet
Agency: Premier Group Realty
Agency Phone: (229) 246-9837

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Cabin
Year Built: 2010
Notes: Additional cabins are available for purchase, though they will need to be relocated from their current location. These stunning cabins are sold as-is and come fully furnished, complete with porches, making them an ideal choice for anyone seeking a cozy retreat. Rocky Bend will cover the takedown costs, while buyers will be responsible for their transportation and setup at the new site. Each cabin is expertly crafted from high-quality materials, including heart pine, cedar, cherry, and cypress sourced directly from the property. Many interior tables are made from recycled wood salvaged from local hurricanes or storms, adding a unique touch of history and sustainability to each piece. To maintain their beautiful appearance and structural integrity, the wood is stained and treated annually. This investment means you're not just buying a cabin, but a durable and lovely living space. Don't miss out on this wonderful opportunity! -Longleaf Cabin $60,000 “Frame” Sq Ft- 480 sq ft Total Length- 34ft Total Width- 18ft 2in Total Height- 15ft 4in Porch Width 16ft 1in -Riverbirch Cabin $60,000 “Frame” Sq Ft- 480 sq ft Total Length- 34ft Total Width- 18ft 2in Total Height- 15ft 4in Porch Width- 16ft 1in -Little Rock Cabin $30,000 “Frame” Sq Ft- 240 sq ft Total Length- 34ft 5in Total Width- 12ft 3.5in Total Height- 12ft 4in Porch Width- 11ft 3.5in -Treehouse Cabin $60,000“Frame” Sq Ft- 488 sq ft Total Length- 44ft 10in Total Width- 32ft 10in Total Height- 12ft 9in -Cypress Knee Cabin $70,000 “Frame” Sq Ft- 560 sq ft Total Length- 37ft 8in Total Width- 23ft 2in Total Height- 14ft 4in -Lighter Knot Cabin $30,000 “Frame” Sq Ft- 240 sq ft Total Length- 31ft Total Width- 14ft Porch Width- 16ft 7in (with walkway, without total width 12ft 6in) Total Height- 12ft 1in Primitive Cabin 1 $10,000 13 ft wide without porch 1ft 8' with porch Cabin 10x10 Inside ***This is a private resort and no through traffic is permitted. Agent must be with you.*
MlsNumber: --
ListingId: 13640


Listing Provided By: Premier Group Realty, original listing
Phone: (229) 726-9680
Office Phone: (229) 246-9837
Agent Name: Tyler A. Inlow
Disclaimer: Copyright © 2024 Southwest Georgia Board of Realtors MLS. 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