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

1745 Alana Drive
Terry, MS 39170
Billy McKee with McKee Realty, Inc., original listing - (601) 992-8141

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,900
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 3388 Square Feet
Agency: McKee Realty, Inc.
Agency Phone: (601) 992-8141

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Welcome to 1745 Alana Dr., a stunning 6.8 +/- estate offering everything you've dreamed of and more! This stunning property features 4 bedrooms, 4 baths, bonus room, media room totaling over 3300 sq ft of thoughtfully designed living space. Step inside to discover an inviting floor plan, with beautiful wood floors that flows throughout the living space, high ceiling with a stone brick fireplace that flows effortlessly into the kitchen. The kitchen offers a keeping room with it's own fireplace, granite top island, granite countertops, gas cook top, a double oven with a built-in warming drawer, stainless appliances, ample pantry space, and extensive cabinetry. The primary suite offers access to the covered back patio with beautiful views of the lake. The additional bedrooms provide ample space for family and guests. On the upper level floor, you will find a bonus room , accompanied with full bath and a media room. Additionally, this home includes a 3- car garage with a storage room providing space for parking and storage. The home is also equipped with a back up Generac generator. Outside amenities include a private pool, an outdoor fireplace, 4 stall barn with loft all overlooking the 3 acre stocked lake. This home will not disappoint!
MlsNumber: --
ListingId: 4105388


Listing Provided By: McKee Realty, Inc., original listing
Phone: (601) 260-2256
Office Phone: (601) 992-8141
Agent Name: Billy McKee
Disclaimer: Copyright © 2025 MLS United. 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