Title Page Background
DEBUG FN args: Array ( [0] => 65 [1] => [2] => [3] => agent ) BEFORE: Site: 65 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 65 Igate: njhud LocID: 65 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 65 AND i.igate IN ('alhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'alhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 65 [1] => [2] => [3] => lender ) BEFORE: Site: 65 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 65 Igate: njhud LocID: 65 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 65 AND i.igate IN ('alhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'alhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 65 [1] => [2] => [3] => other ) BEFORE: Site: 65 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 65 Igate: njhud LocID: 65 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 65 AND i.igate IN ('alhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'alhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

4013 County Road 43
Camden, AL 36726

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,000
Beds: 4
Baths:
Status: Active
SqFt: --
Agency: United Country-South Land Company, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 16 acre(s)
Garage: Garage
Property Type: Residential-Single Family Attached
Year Built: 2018
Notes: Welcome to your serene oasis nestled near the picturesque Alabama River! This stunning turnkey home at 4013 County Road 43, Camden, AL 36726 offers the perfect blend of modern comfort and rustic charm on 16 acres of pristine land. Boasting exquisite custom wood accents throughout, this home is a true masterpiece of craftsmanship. Step inside to discover a spacious and inviting interior flooded with natural light. The open floor plan seamlessly connects the living, dining, and kitchen areas, creating an ideal space for both relaxation and entertainment. Enjoy the beauty of nature from the comfort of your own home with enchanting front and back porches, perfect for sipping your morning coffee or unwinding after a long day. Whether you're hosting gatherings with friends and family or simply enjoying a quiet evening under the stars, these outdoor spaces provide the perfect backdrop for making memories that will last a lifetime. With 16 acres of land surrounding the property, there's plenty of room to explore and enjoy outdoor activities such as hiking, gardening, or simply taking in the breathtaking scenery. Imagine waking up each day to the sounds of birds chirping and the gentle rustle of the trees, as you breathe in the fresh, crisp air of the countryside. Conveniently located near the Alabama River, this home offers easy access to fishing, boating, and other water activities, allowing you to fully embrace the riverside lifestyle. Whether you're seeking a peaceful retreat or a place to call home, this beautiful property has it all. Don't miss your chance to experience the beauty and tranquility of country living at its finest! This home features two very spacious master bedrooms on the ground floor with spacious and luxurious full-size bathrooms with walk in luxurious showers and closets. Upstairs boast a large, lofted den area full of space with two more bedrooms that also have full size bathrooms and walk in closets. Don't miss the opportunity to own a little piece of paradise in the woods but just minutes from downtown Camden, AL with lots of shopping and entertainment! Almost 5,000 square feet under roof!!!! **Additional land can be purchased with this property if desired.
MlsNumber: --


Listing Provided By: United Country-South Land Company, LLC, original listing
Phone: (334) 357-3694
Office Phone: (334) 872-6484
Agent Name: Stephanie Hines
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