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

23546 Meadows Road
Andalusia, AL 36421
Linda Simmons with Team Linda Simmons Real Estate, original listing - (334) 347-8441

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $342,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1620 Square Feet
Agency: Team Linda Simmons Real Estate
Agency Phone: (334) 347-8441

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 18 acre(s)
Property Type: Residential-Manufactured Home
Year Built: 1992
Notes: This property truly has it all! It features a home, hunting opportunities, a spring-fed pond, a creek, and an additional 20 x 40 pad for an RV equipped with hookups, electricity, water, and a self-made septic system. You'll find two large storage containers (one with electricity) and a lean-to for extra storage. Spanning nearly 19 acres, the land is abundant with wildlife. The pond includes a driveable path surrounding it, and there are various trails throughout the property. The backyard is fenced for a dog, complete with a cozy warming area beneath the deck. Three sides of the property are fenced in. A lovely new deck enhances the outdoor space. Everything in this house is brand new, including walls, floors, subfloors, electrical, plumbing, and all fixtures. Inside, you'll find two living areas, a dining room, and a breakfast nook, along with an island in the kitchen and newer appliances. Luxury vinyl plank flooring throughout, except in the bedrooms. The power is via CT's (one meter) from the house to the buildings. The owner is still working on a few details inside the home, including renovations in the main bathroom, which will feature a ceramic tile shower. The split floor plan includes a laundry room. There is foam insulation on the roof and under the mobile home, and the air conditioning system still has about eight years remaining on its warranty. There are some planted pines on the property, which can be kept/removed as they are included. This property is beautiful!
MlsNumber: --
ListingId: 202037


Listing Provided By: Team Linda Simmons Real Estate, original listing
Phone: (334) 300-8441
Office Phone: (334) 347-8441
Agent Name: Linda Simmons
Disclaimer: Copyright © 2025 Dothan Association of Realtors. 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