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

16945 Ms 315
Sardis, MS 38666
Jack Gabriel with Southeastern Land Group, original listing - (866) 751-5263

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,970,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 7000 Square Feet
Agency: Southeastern Land Group
Agency Phone: (866) 751-5263

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 96 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: --
Notes: In the heart of the countryside lies the Jordan Estate boasting a main residence, three stocked ponds, a cozy guest house, a versatile shop with living quarters, and an outdoor amphitheater. If you're looking for a turn-key family estate, entertainment venue, or quiet retreat; look no further than the Jordan Estate. Home: The 7,000 sq ft custom home is located in the heart of the property and overlooks the largest of the three stocked ponds, making for fantastic views of deer, turkey and waterfowl. The 4-bedroom, 4-bathroom home was built for entertaining while also allowing for privacy of guest and owners alike. The massive master suite is accompanied with a large bathroom featuring his and hers vanity's, walk-in closets, and private commodes. All 3 guest bedrooms are complete with walk-in closets and the 2 bedrooms down stairs have their own bathrooms. The living room is spacious with lots of windows allowing natural light and views of the infinity pool and pond. In the kitchen you will find all stainless steel appliances, a gas stove, double oven, granite countertops, and custom cabinetry and tile. Coming out of the kitchen you will find stairs leading up to a movie theater room complete with a snack bar. Down the stairs there is a fraidy room with a wine cellar. The two double garages on either side of the home also have room for storage with the largest garage having a mudroom/pet cleaning bay. This home was well thought out and includes so many more amenities that one must see to appreciate! Guest Home: The guest home on the property is affectionately referred to as the "writers cabin." This 2 bedroom, 1 bath residence is located overlooking the second largest pond on the property. A wrap-around porch with rocking chairs welcomes all guest to relax! Current owners have used this space as a guest home and also rented it out for Ole Miss game days and other events around the area. Barndominium: The barndominium on the property has been used to host weddings, concerts, reunions, and benefit dinners. Located inside is a professionally lit stage with an incredible sound system. The venue has supported up to 200 people for concerts/shows and has accommodated 160 people for dinner. In addition to the stage, the barndo also has a commercial kitchen, 4 bathrooms, and a nice 2-bedroom, 2-bathroom apartment. Outdoor Amphitheater: The amphitheater on the property is one more space available for entertaining! Amphitheater includes a covered stage and water, and power for venders and buses (30 and 50 amp.) This portion of the property is full of potential and possibilities with room for over 3000 people to attend events. Grounds: As soon as you enter the gates to the Jordan Estate you are greeted with a concrete drive through an open field that leads to the main residence. The property itself is a mixture of open fields with mature hardwoods. There are currently two golf greens with multiple tee boxes that can be set up to play as 11 different hole configurations. Outside of the open areas around the ponds and golf area, there is also one wildlife food plot. Conveniently located just 30 minutes from Oxford and 40 minutes from Memphis, with easy access to Sardis Lake and the Mississippi Delta, this retreat promises the perfect blend of tranquility and convenience. Keep watch over deer and turkey as they roam the yard, and cast your line for crappie, catfish, and bass in the ponds. If you are sporting clays enthusiast, the Winchester McIvor Shooting Facility is only a few miles away.
MlsNumber: --
ListingId: 11288277


Listing Provided By: Southeastern Land Group, original listing
Phone: (866) 751-5263
Office Phone: (866) 751-5263
Agent Name: Jack Gabriel
Disclaimer: Copyright © 2024 My State MLS. 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