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','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 = 22 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 = 22 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;

611 Charlston Mills
Midland City, AL 36350
Gail Strickland with Full Circle Realty, original listing - (334) 489-3299

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $552,900
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4291 Square Feet
Agency: Full Circle Realty
Agency Phone: (334) 489-3299

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Discover the perfect blend of sophistication and modern comfort in this exquisite 5 br, 3.5 ba home, built in 2022 with 4,291 sq. ft. of living space. As you step inside, you'll be welcomed by rich hardwood floors complemented by refined wainscoting in the foyer and formal dining room. The space is further enhanced by a stunning coffered ceiling, adding a touch of timeless grace. The grand living room features a cozy gas fireplace and intricate, extra-wide crown molding. For the culinary enthusiast, the gourmet kitchen is a dream come true. With luxurious granite countertops, a striking exposed brick backsplash, and an abundance of custom cabinetry, this kitchen is both functional and beautiful. Equipped with a 5-burner gas cooktop with griddle and pot filler, a high-end oven/microwave combination, and a refrigerator with custom door panels, it's designed to inspire. A large pantry and Bluetooth-enabled stovetop and dishwasher. Adjacent to the kitchen, a spacious laundry room with build-in cabinetry and a sink. The master suite is a private retreat, featuring a serene sitting area and a spa-like bathroom with a soaking tub and separate shower. Upstairs, four generously sized bedrooms and 2 full baths. Outdoors, unwind in your screened-in porch. The backyard has ample space for a future pool. Energy-efficient spray foam insulation, HVAC system with dehumidifier, 2 car garage, fully irrigated front and side yard, ADT alarm. Community offers sidewalks, dog park and pool.
MlsNumber: --
ListingId: 200084


Listing Provided By: Full Circle Realty, original listing
Phone: (334) 791-1604
Office Phone: (334) 489-3299
Agent Name: Gail Strickland
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