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

343 Jerusalem Rd
Clio, AL 36017
Averi Whitfield with National Land Realty, Southeast Alabama, original listing - (855) 384-5263

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $859,500
Beds: 3
Baths: Full: 2
Status: Active
SqFt: --
Agency: National Land Realty, Southeast Alabama
Agency Phone: (855) 384-5263

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 182 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Imagine starting a crisp spring morning, listening to turkeys gobble from the hardwood bottom behind your home as the sun rises to the east. That’s just one of the many experiences this one-of-a-kind property has to offer. This turnkey 182±-acre cattle farm is fully equipped for your dream homestead.  It features 60± acres of fenced pastureland, with quality fencing, a well-designed catch pen with heavy-duty metal panels, and multiple cattle troughs; this property is perfectly set up for livestock. Included in the purchase is a cow/calf operation with 23 head of cows and one bull, making it a true turnkey operation. A 2022 single-wide home with farmhouse-style finishes and sheetrock walls offers modern comfort, while additional structures, including a storage shed, custom swing set, and a 32’ x 84’ equipment barn, provide ample space for all your needs. The home has beautiful views from the front porch. It’s nestled among mature pecan trees, which produce a bounty of pecans each year—perfect for summer shade and seasonal beauty. A couple of creek branches run through the property, and it has a spring-fed water source that flows year-round, offering excellent potential for a large pond. The land also features 117± acres of clear-cut that could be converted into additional pastureland, expanding your possibilities for farming and grazing. For the outdoor enthusiast, this property also boasts exceptional deer and turkey hunting. With a mix of pasture, clear-cut, hardwoods, and natural water sources, it's the perfect habitat for abundant wildlife. Located in a Pea River Fiber service area, this farm offers the best of rural living with modern connectivity. Don't miss out on this rare opportunity!
MlsNumber: --
ListingId: 11445103


Listing Provided By: National Land Realty, Southeast Alabama, original listing
Phone: (855) 384-5263
Office Phone: (855) 384-5263
Agent Name: Averi Whitfield
Disclaimer: Copyright © 2025 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