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

174 Old Westville Road
Mendenhall, MS 39114

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $750,000
Beds: 4
Baths: 4
Status: Active
SqFt: 5841
Agency: Ward Enterprises Inc dba RE/MAX Connection

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 14 acre(s)
Property Type: Residential
Year Built: 2014
Notes: You must see this Custom Built 4 BR/ 3.5 BTH Home on 14.66 Acres with a Shop and Shed. Drive up to this beautiful home that has a circular drive and the most inviting front porch for rocking and sipping ice tea. You walk through the front door into an open floor plan to enjoy all your family gatherings and entertaining. Hardwood floors throughout the kitchen and living area. The great room features a Norwegian cast iron stove that is a Jotul F500, which is their largest and highest heat producing stove. The chimney is a stainless steel inside and out and rated to 2100 degrees. The stone work is 4'' thick granite laid in high temp mortar. It is designed to reflect the heat back into the room. The kitchen features a massive island and the countertop is a single sheet of granite. Gas cooktop with pot filler and pullout spice racks on either side of the cooktop, as well as double ovens. There is so much storage and a walk in pantry area off the dining room. There is a half bath that is off the living area but can be accessed from the outdoor patio area. The master bedroom is large and spacious and there is a closet that holds a Liberty Gun Safe that is bolted in the closet and will remain with the home. There is access to the outdoor patio area from the master suite. The master bath is large and features His and Her vanities, ceramic tile floors with granite countertops. Jacuzzi Garden tub and a walk in shower with rain head. The walk in closet is off the master bath and also has access to the massive laundry room. There are two other bedrooms downstairs and a full bath that features a soaking tub/shower combo. Upstairs is a extra large bedroom with full bath and closet off the bathroom. There is a bonus area that can be used as a bedroom or play area. This amazing home also features an outdoor kitchen and fireplace. Step out back on the covered fireplace and enjoy this bonus outdoor entertaining area. There is a deck that extends off the patio with stairs going down to the back yard on either side of the deck. There is a 2100 Sq. Ft. Shop that features a lean to and shed on the property. I could go on and on about this property but the best thing is to contact your REALTOR today to set up an appointment to few this fabulous home.
MlsNumber: 4078042


Listing Provided By: Ward Enterprises Inc dba RE/MAX Connection, original listing
Name: Ward Enterprises Inc dba RE/MAX Connection
Phone: (601) 326-3670
Office Name: RE/MAX Connection
Office Phone: (601) 326-3670
Agent Name: Elizabeth Wroten
Disclaimer: Copyright © 2024 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.


Local Real Estate Expert

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 = 1468 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;
Real Estate Expert Photo for Sissye Gory
Sissye Gory
ASCIICRYE-LEIKE Realtors
Call Today!: (601) 260-8656
Office: (601) 939-5160

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App