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

1085 County Road 122
Headland, AL 36345
Carrie Blankenship with Weichert Realtors JBR Legacy Group, original listing - (334) 794-7211

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,000
Beds: 3
Baths: Full: 3, ½: 2
Status: Active
SqFt: 3270 Square Feet
Agency: Weichert Realtors JBR Legacy Group
Agency Phone: (334) 794-7211

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Beautiful private custom home in Headland, AL. with luxury & comfort in mind. 3270 Heated/Cooled SF on 10 acres Split floor plan. Features 3 bedrooms, 3 full bathrooms, 1 half bath on the main floor, and a bonus room upstairs with a half bathroom. Walk in the front door into a big foyer with the library on one side & office on the other. Gourmet kitchen with custom cabinets, big drawers, gas stove w/ pot filler, built-in oven & microwave, farmhouse sink in a large island with plenty of space for bar stools. Walk in pantry & has a safe room. Spacious master bedroom with barn door, trey ceilings, large walk-in closet, and a luxurious bathroom with a walk-in shower that has 2 rain heads, Bluetooth in all 3 full bathrooms, soaking tub with tv, and dual vanities. Brick wood-burning fireplace, motorized TV lift, built-in bookshelves on both sides of the fireplace. Other Features: Quartz countertops through out, antique doors, wrap-around porch on 3 sides perfect for the person who loves relaxation with total privacy, mahogany front door, tankless gas water heater, 2 car garage, custom hall tree with bench as you walk in house from the garage. Laundry room is oversized with cabinets & sink and access to master suite. This home seems perfect for someone who values comfort, style, and functionality. The spacious layout, high-end finishes, and unique features make it a truly special property. Starlink system remains. Survey on file. Headland schools. A MUST SEE IN PERSON!!
MlsNumber: --
ListingId: 201865


Listing Provided By: Weichert Realtors JBR Legacy Group, original listing
Phone: (334) 714-7522
Office Phone: (334) 794-7211
Agent Name: Carrie Blankenship
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App