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 = 1486 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 = 1486 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 = 1486 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;

16487 Ms-3
Yazoo City, MS 39194
Lee Garland with Epique, original listing - (601) 983-1130

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,300,000
Beds: 8
Baths: Full: 8, ½: 1
Status: Active
SqFt: 10175 Square Feet
Agency: Epique
Agency Phone: (601) 983-1130

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 19 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1979
Notes: Life in a manor? The possibilities are endless! With 8 bedrooms, 8.5 baths, formal living room, formal dining room, parlor, library, 2 enclosed porches, 2 kitchens, mudroom, den, keeping room off the kitchen, walk-in pantry, dual bathrooms in the primary bedroom, a huge walk-up/floored attic and basement. All five HVAC units are less than 3 years old. Appliances are all less than five years old. Three dishwashers, ice machine, warmer drawer, two stoves, three ovens. Upstairs and downstairs laundry rooms. Outdoors there is 20 acres, a pool, double tennis court and plenty of parking. The owner is willing to leave 2 large outdoor custom animal enclosures.*****That's the physical details, now for the possibilities! ***** Bed and breakfast, Air BnB, perfect for a multi-generational family, retreats, wedding venues and more! Or simply enjoy the manor for yourself. Located between Satartia MS and Yazoo City, 13 minutes from a Walmart. It is surrounded by over 10,000 acres of farmland. Panther Swamp Wildlife Management area is just a couple of miles behind the home. Black squirrel, bald eagles, and tons of beautiful wildlife all around. Check out the property on FB at the Ever After Manor (wedding venue). Such a beautiful property and an easy drive from Vicksburg, Madison Co, Jackson is under an hours drive and even Natchez is an easy 2 hr dr for a weekend get-away. Call your favorite Realtor today for your private showing, you won't be disappointed!
MlsNumber: --
ListingId: 4100581


Listing Provided By: Epique, original listing
Phone: (601) 983-1130
Office Phone: (601) 983-1130
Agent Name: Lee Garland
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