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

4687 Carpenters Bridge Rd.
Kinder, LA 70648
Oliver Carmichael with Wildlife Land Group, original listing - (337) 345-1797

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,900,000
Beds: 4
Baths: Full: 6
Status: Active
SqFt: 4000 Square Feet
Agency: Wildlife Land Group
Agency Phone: (337) 345-1797

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 820 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: --
Notes: 820-Acre Outdoor Paradise with 3.8 Miles of River Frontage Escape to your own private sanctuary spanning 820 acres of breathtaking land. This one-of-a-kind property offers unparalleled access to nature, with 220 acres of lush pasture and over 3.8 miles of scenic river frontage, bordered by the Bundick River and the Ouiska Chitto Creek. Key Features: Recreational Haven: Over 6 miles of ATV trails, five stocked ponds ideal for fishing and duck hunting, and abundant opportunities for outdoor adventures. Enjoy hunting for ducks, deer, wild hogs, turkey, and even alligators. Luxurious Lodge: A 4,000 sq. ft. lodge with 4 bedrooms and 6 bathrooms, designed for entertaining friends, family, or clients in style. Fully Equipped: Includes an equipment barn stocked with two tractors and a bulldozer, making land maintenance a breeze. Waterfront Activities: The Ouiska Chitto Creek is a Louisiana favorite, renowned for canoeing, kayaking, and tubing along its pristine white sand beaches. This property is a true retreat, teeming with wildlife and offering endless opportunities for recreation and relaxation. Whether you're looking for a private getaway or an exceptional venue for hosting, this is the ultimate destination for outdoor enthusiasts.
MlsNumber: --
ListingId: 11415593


Listing Provided By: Wildlife Land Group, original listing
Phone: (337) 345-1797
Office Phone: (337) 345-1797
Agent Name: Oliver Carmichael
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