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

1428 Lem Road
Spearsville, LA 71277
Thomas N Smith with Tom Smith Land & Homes, original listing - (601) 898-2772

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,949,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Tom Smith Land & Homes
Agency Phone: (601) 898-2772

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 910 sqft
Property Type: Land-Other
Year Built: --
Notes: Welcome to a sportsman's paradise in Union Parish, Louisiana! This magnificent property offers 2,290+/- acres, including 910+/- owned acres and 1,380+/- acres leased from Potlatch, Weyhauser, and private landowners. The leases will transfer with the purchase of the owned land, giving you access to managed timber, various-age pine, hardwoods, cutover, bedding areas, and outstanding road systems throughout.The owned land comprises 200+/- acres of 15-year-old pine thinned once, 100+/- acres of 30-year-old saw timber, 300+/- acres of old-growth hardwoods over 80 years old, 20+/- acres of 1-year-old cutover replanted in January 2024, 100+/- acres of duck impoundments and marsh, and 100+/- acres dedicated to food plots, roads, and the main camp area. The main lodge spans 6,000 square feet and includes four bedrooms and four full baths, with two bedrooms and bathrooms recently added. The lodge also features a kitchen, family room, living room, laundry room, workshop, and a covered front porch. The main camp area, approximately 5+/- acres, offers unlimited parking and includes three barns and storage buildings measuring 60x80, 60x60, and 60x40, respectively. Additionally, the lodge has newly installed A/C units and can comfortably sleep 10-14 hunters. Unique features include a shooting house on the second-floor roof, a treatment plant, community water, and service by Claiborne Electric.The property has asphalt road frontage and access to the main lodge from Lem Road, with a privacy gate entry. An outstanding road system extends throughout the 2,290+/- acres, facilitating easy navigation. Wildlife is abundant, with trophy deer, turkey, and small game. The deer management program has been in place for over 20 years, and the area is renowned for its trophy deer. For duck hunting enthusiasts, there is a 30+/- acre duck structure with two control structures, levees, and duck blinds, yielding an average harvest of 200-300 ducks per season. The property also offers excellent fishing for bass and bream and includes ten established food plots, all equipped with shooting houses and currently planted with clay peas and clover. Additional wildlife consists of an average harvest of 100+ squirrels annually and 5-6 turkeys yearly. The property has 25 total deer blinds, all stands and feeders to remain.As a timber investment, the property is outstanding, with well-managed plantations, some stands ready for thinning, and pole timber ready for harvest. The property is conveniently located within 10 miles of a sawmill. This remarkable tract of land is truly one of the finest in this part of Louisiana, offering everything an outdoorsman and their family could ever need. Additional amenities include a campsite site with a small kitchen, full bath, bedroom, power and water, a pole barn, and a tool shed. Priced to sell, this property is a once-in-a-lifetime opportunity!
MlsNumber: --
ListingId: 4085570


Listing Provided By: Tom Smith Land & Homes, original listing
Phone: (601) 454-9397
Office Phone: (601) 898-2772
Agent Name: Thomas N Smith
Disclaimer: Copyright © 2024 MLS United. 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