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 = 14 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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 = 14 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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 = 14 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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;

727 County Road 677
Ranburne, AL 36273
Lindsey Hammond with Triple R Real Estate LLC, original listing - (770) 328-6073

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $300,000
Beds: 1
Baths: Full: 1
Status: Active
SqFt: 500 Square Feet
Agency: Triple R Real Estate LLC
Agency Phone: (770) 328-6073

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 28 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Picture yourself driving down your driveway and it is like you are taken into the mountains. You have a gorgeous creek that runs right beside you as you drive back to your tiny home right in front of a lake! You can have all of that and find it in the highly coveted Ranburne area. This breathtaking 30-acre property is a rare find and is even more beautiful in person! With a gorgeous creek running through the land, a tiny brook on the other side, and a lake on the backside, this property offers the perfect mix of peace and natural beauty. Whether you dream of a weekend getaway or a full-time country escape, this land is full of possibilities. A cozy tiny home is already in place with everything you need for a weekend getaway or to live in while building, along with an older mobile home that could be made extremely nice with a little work. If you're looking to build, there are multiple building spots, including one with stunning lake views. Plus, with underground utilities already in place, getting started is even easier. Whether you want to fish by the creek, relax by the lake, or finally build that dream home, this property has everything you need. Opportunities like this don't come around often in Ranburne-don't miss your chance to own this beautiful piece of land! Seller is open to selling RV and farm equipment for an additional price!
MlsNumber: --
ListingId: 10485207


Listing Provided By: Triple R Real Estate LLC, original listing
Phone: (770) 328-6073
Office Phone: (770) 328-6073
Agent Name: Lindsey Hammond
Disclaimer: Copyright © 2025 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