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

1622 Main Street
Daleville, AL 36322
Teresa Conte-Rodriguez with Berkshire Hathaway HomeServices Showcase Properties, original listing - (334) 792-7474

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $435,000
Beds: 1
Baths: Full: 1
Status: Active
SqFt: 1241 Square Feet
Agency: Berkshire Hathaway HomeServices Showcase Properties
Agency Phone: (334) 792-7474

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 28 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1983
Notes: HUNTERS PARADISE in the country on 28-acres. This wooded estate includes 2 dwellings (1.) Beautiful custom build log cabin with rocking chair Ft & Bk porch & wood burning stove, 1232sf w/ 2 BR & 1BTH. Tile flooring throughout. Kitchen has stainless steel appliances, granite counter tops and custom-built cabinetry. Space blanket in attic. Septic for main cabin installed 2023. Metal roof w/new gutters, recently cleaned, 4 bay Pole barn w/ new roof, metal RV carport, 4 car freestanding carport, new pavilion with gutters one year old, greenhouse, & chicken coop. Well house has water soft at pump, gets maintained every three years, serviced by “Rain Soft”. Smoke alarms in every room and attic. Posted wire fence runs property line of 28 acres. In ground dog fence surrounds cabin, electronics not included. Attic fan operated by solar. 3 wet springs that run the property. For those avid hunters, your very own gun range. You will really enjoy the small pavilion that is set up for target practicing & archery. (#2.) 2022 Mobile home like brand new w/ 2BR & 2BTH. Mobile home does not have Internet, local channels only, wheels & axle have been removed, exterior vinyl siding, no carpet, all vinyl plank, 2 car carports with additional storage, septic for mobile home installed 2022. Both Ft & Bk doors have wooden decks. Bk deck has a handicap accessible ramp.
MlsNumber: --
ListingId: 203677


Listing Provided By: Berkshire Hathaway HomeServices Showcase Properties, original listing
Phone: (334) 790-4353
Office Phone: (334) 792-7474
Agent Name: Teresa Conte-Rodriguez
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