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

3057 County Road 56
Beatrice, AL 36425
Darren McGilberry with United Country-South Land Company, LLC, original listing - (334) 872-6484

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $349,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1140 Square Feet
Agency: United Country-South Land Company, LLC
Agency Phone: (334) 872-6484

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Garage: Garage
Property Type: Residential-Cabin
Year Built: 2019
Notes: Stunning 8-Acre Property with a Rustic Log Cabin and Pond Discover the charm of yesteryear at this gorgeous 8-acre property, where history meets modern comfort. As you enter through the gate, a long, crushed asphalt driveway leads you to a covered bridge, complete with power and lights, evoking the character of a bygone era. The property features a picturesque pond with a fountain and automatic fish feeder, ensuring a serene and vibrant environment. As you ascend the hill, you'll find a rustic log cabin and a versatile metal barn. The well house, designed to resemble an old outhouse, adds a nostalgic touch. This property is well-equipped with two four-inch wells, one reaching 450 feet to the cabin and the other 750 feet to the cabin and pond, making it easy to keep the pond full. The metal barn includes two roll-up doors, an open end, and a skinning shed, providing ample space for various activities. Built in 2019, the log cabin blends modern amenities with a timeless aesthetic. It features two bedrooms, two bathrooms, a real wood-burning fireplace, wide wood plank floors, a custom wood front door, and an open floor plan. The cabin is insulated with foam under the floors and has an attic fan in the gable, along with a new HVAC system for year-round comfort. The kitchen boasts stainless steel appliances, quartz countertops, and painted white cabinets, combining functionality with style. Whether you're seeking a recreational hunting camp, a homestead, a vacation rental or potential wedding venue this property offers endless possibilities. Don't miss out on this unique opportunity! The property includes Parcel ID 51-09-02-040-000-004.001. -20 miles to Camden -25 miles to Monroeville -116 miles to Pensacola -112 miles to Mobile
MlsNumber: --
ListingId: 11382232


Listing Provided By: United Country-South Land Company, LLC, original listing
Phone: (334) 608-3456
Office Phone: (334) 872-6484
Agent Name: Darren McGilberry
Disclaimer: Copyright © 2024 My State 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