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

1590 Epping Forest Drive
Southaven, MS 38671

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $724,900
Beds: 6
Baths: 6
Status: Active
SqFt: 6273
Agency: Remax Real Estate Experts

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1990
Notes: Recent price reduction!! *Video Tour: https://player.vimeo.com/video/932690574 * This is your chance to make this custom home in Southaven in the prestigious Stonehedge neighborhood yours! Major renovation of over $150,000 was just completed for the new buyer to enjoy! Sitting on over an acre lot this 6,300 sq/ft home is one of a kind Six Bedrooms (2 Primary suites)-5.5 Bathrooms-Formal dining room with China closet-Private office/study with built-ins-Huge play room with wet bar-Private baths for five of the six bedrooms-Dynamite kitchen that includes tons of cabinets with pull outs, 2 cooking areas (New JennAir Gas cooktop on island and new JennAir electric down-draft range in brick alcove), 2 sinks, both with touch less faucets, 2 pantries, gorgeous quartz counter tops, built in ice-maker, hot water dispenser and more-Hearth Room/Breakfast Area with a wall of windows over-looking a 5 level tiered deck-Great Room with fireplace, wood ceiling beams and gorgeous built-in storage cabinets-Downstairs Master Suite with raised fireplace and a salon bath that has his & hers sides that include a separate shower & jetted tub, a toilet room that includes a bidet, 3 walk-in closets, 2 linen closets, great lighting, pocket doors, and a door that leads to the back deck-Laundry room with closet, desk, cabinets and shelving, sink and folding area. Other interior features include a bead board ceiling in kitchen and hearth room; new hardwood flooring in hall, dining, office and every bedroom; new plank style, polished porcelain tile in laundry, kitchen/hearth room, utility room, upstairs playroom and upstairs master suite (Bedroom 5); fresh paint; 23 closets for storage; 4 HVAC units; two stairwells; two front entrances and more. Outside you will find the phenomenal 5 tier deck that is perfect for entertaining, a basement that may be used as a storm shelter, a solarium/detached sunroom, 4 attics, wonderful shade from the hardwood trees scattered in the back and side yards, an over-sized 2 car garage with new epoxy floor and additional parking for 4-5 more vehicles, and brick lined flowerbeds that extend on each side of the circle driveway and along front of property.
MlsNumber: 4076078


Listing Provided By: Remax Real Estate Experts, original listing
Name: Remax Real Estate Experts
Phone: (901) 685-6000
Office Name: Re/Max Experts
Office Phone: (901) 685-6000
Agent Name: Eric C Bell
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 = 1421 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 Melanie Henderson
Melanie Henderson
ASCIIBurch Realty Group
Call Today!: (770) 289-3130

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App