Title Page Background
DEBUG FN args: Array ( [0] => 30 [1] => [2] => [3] => agent ) BEFORE: Site: 30 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 30 Igate: njhud LocID: 30 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 = 30 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 30 [1] => [2] => [3] => lender ) BEFORE: Site: 30 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 30 Igate: njhud LocID: 30 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 = 30 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 30 [1] => [2] => [3] => other ) BEFORE: Site: 30 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 30 Igate: njhud LocID: 30 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 = 30 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back | All Foreclosures | | | All Cities

13321 State Highway 52
Hartford, AL 36344
Diane Alpeter with COLDWELL BANKER PRESTIGE HOMES & REAL ESTATE, original listing - (334) 347-7971
« Prev
Next »
Currently Displayed Property Photo


Property Details

List Price: $338,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2482 Square Feet
Agency: COLDWELL BANKER PRESTIGE HOMES & REAL ESTATE
Agency Phone: (334) 347-7971

Map Details Show Map | Show StreetView



Description/Comments

Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1976
Notes: LOOK at this all brick 3 (large) bedroom/ 2 full bathroom home with SO MUCH SPACE and storage. As you enter the long driveway, you can park in the front, or drive around back to a second long driveway, parking pad, and 2 car (insulated) garage. Further back is a concrete block single car garage with full workshop. A large storage shed is also present. Exit your car to the screen porch! Thru this entertainment area, enter a small room with can be used as an office, play area, or workout room. Walk into a cozy family room accented with a fireplace and bay window. The bright, airy kitchen boasts an updated backsplash, granite countertops, and large eating area. An upgraded refrigerator and stainless steel appliances are included as well as a walk-in pantry! A covered porch adds more charm! The spacious grand room is currently being used as a living/ dining area. Down the hall to the right is a bedroom, large enough for a double bed, dresser, and desk. A second bedroom, large enough for a king bed, large dresser and more is up next. The master is across the hall, complete with its own mini-split and bathroom. The home boasts additional closet space, LVP and tile floors, and more. Wiring and electrical have been updated. Shop building (approx. 900 sq. ft.) has electric and ducted for AC. There's more! A complete dog-run pen is located in the back of the property. The State of Alabama has made an offer to purchase .17 acres of easement, which is included in the 1.2 acres.
MlsNumber: --
ListingId: 199552


Listing Provided By: COLDWELL BANKER PRESTIGE HOMES & REAL ESTATE, original listing
Phone: (334) 389-6137
Office Phone: (334) 347-7971
Agent Name: Diane Alpeter
Disclaimer: Copyright © 2024 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.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => geneva [3] => AL [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: geneva State: AL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: geneva State: AL 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 = 30 AND i.igate IN ('azhud','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 = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Ashley Dean
Ashley Dean
ASCIIKeller Williams SE Alabama
Call Today!: (334) 406-9928

Contact Me

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App