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;

119 Brookwood Drive
Camden, AL 36726

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Welcome to 119 Brookwood Drive, a picturesque turnkey riverfront property nestled in Millers Ferry, Alabama. This charming abode offers the perfect blend of modern comfort and serene natural beauty, providing an idyllic retreat for those seeking tranquility and relaxation. Boasting three spacious bedrooms and two pristine bathrooms, this home is designed to accommodate both intimate family gatherings and lively social occasions. As you step inside, you'll be greeted by an inviting ambiance, with warm natural light flooding the open-concept living spaces. The well-appointed kitchen features sleek countertops, contemporary appliances, and ample cabinet space, making it a chef's delight. The highlight of this property is undoubtedly its stunning riverfront location. Situated along the tranquil waters of the river, the backyard beckons you to unwind and soak in the breathtaking views. Whether you're enjoying a leisurely morning coffee on the back patioor hosting a barbecue with friends and family, you'll find endless opportunities to savor the beauty of nature right at your doorstep. In addition to its scenic surroundings, 119 Brookwood Drive offers the convenience of being part of a vibrant and welcoming community. With its close-knit atmosphere and friendly neighbors, you'll feel right at home from the moment you arrive. Plus, the property's proximity to local amenities and recreational activities ensures that you'll have everything you need within easy reach, especially with a new Marina soon to open around the corner. Another luxury of this property is an onsite garage, enclosed deer cleaning station AND your ownwalk in cooler. Whether you're seeking a peaceful retreat or a waterfront haven to call your own, 119 Brookwood Drive is a rare opportunity to embrace the joys of riverfront living in style. Don't miss your chance to make this dream home a reality and experience the best that Millers Ferry and the Camden, Alabama, has to offer.
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