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

197 Mill Court
Lucedale, MS 39452

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $289,900
Beds: 4
Baths: 2
Status: Active
SqFt: 2289
Agency: D.R. Horton Homes

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: --
Notes: Step into the Denton at Magnolia Farms, one of our best-selling floorplans. This home features four bedrooms, two bathrooms in over 2,200 square feet of comfortable living space with a two car garage. As you enter the home through the front foyer, you walk past garage access, a short hallway with three bedrooms. These bedrooms have access to a full bathroom with double sink vanity and shower/tub combination. The laundry room is also positioned down this hallway. The well-appointed kitchen overlooks the living area, dining room, and covered porch. Entertaining is a breeze, as this popular single-family home features a spacious granite kitchen island, dining area and a spacious pantry for extra storage. The primary bedroom, located at the back corner of the home for privacy, has an ensuite bathroom with a double vanity, separate shower and garden tub with a spacious walk-in closet providing ample space for storage. Like all homes in Magnolia Farms, the Denton includes a Home is Connected smart home technology package which allows you to control your home with your smart device while near or away. The standard package that includes: a Z-Wave programmable thermostat manufactured by Honeywell; a Homeconnect TM door lock manufactured by Kwikset; Deako Smart Switches; an Qolsys, Inc. touchscreen Smart Home control device; an automation platform from Alarm.com; an Alarm.com video doorbell; an Amazon Echo Pop. This home is also being built to Gold FORTIFIED HomeTM certification so see your Sales Representative for details. The Denton is a must-see floor plan so schedule your tour today! Pictures are of a similar home and not necessarily of the subject property, including interior and exterior colors, options, and finishes. Pictures are representational only. Furnishings, decorative items, and TVs are not included in the home purchase.
MlsNumber: 26653+265-26653-266530000-0059


Listing Provided By: D.R. Horton Homes, original listing
Name: D.R. Horton Homes
Office Name: D.R. Horton - Mississippi
Agent Name: Magnolia Farms Sales Information
Disclaimer: Copyright © 2024 D.R. Horton. 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