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;

2665a Old Hwy 49
Bentonia, MS 39040
Shane Saxton with Hopper Properties, original listing - (601) 724-1435

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $921,500
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Hopper Properties
Agency Phone: (601) 724-1435

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 68 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Check out this amazing hunting property with the best lodge you could ever find. This property consists of 68 acres+/- and a stunning customized 7 bed/3.5 bath home that was just built in 2023 and sits overlooking a lake. The home is surrounded by trees and sits out of sight of the road giving you the perfect place for privacy and tranquility. This 3-story home is equipped with many windows and doors allowing you to enjoy stunning views of your property from most anywhere in the home. The spacious living room has tall ceilings and surrounded by large windows where you can relax and enjoy the amazing views of your property. The kitchen is open to the living room making this the perfect space to entertain without missing a moment. The kitchen has a wet bar, plenty of cabinet space for storage as well as a breakfast bar area allowing for additional seating. There is a walk-in pantry available with built-in shelving and cabinets giving you great storage space. Retreat down the hall to privacy to the large primary bedroom where you can also relax and enjoy beautiful views from the comfort of your bed. The primary bathroom is equipped with a soaking tub, separate shower, double vanities as well as two large closets. Step right out onto a balcony patio from the primary bedroom overlooking your property. There is access to this balcony patio from the living room as well. This is a great spot to host and entertain as well as there is plenty of space for a table, swing, chairs and a grill. There are additional bedrooms and bathroom with a sitting room on the third floor. The home is equipped with spiral staircases and an elevator giving you multiple ways to access the multiple levels of the home. The property consists of mostly mature hardwoods that has plenty of trails to access the property. There are multiple areas for food plots. There are multiple access points for hunting your property with any wind. There are other home sites on the property for a family compound if desired. The property in the area is well known for producing trophy deer and turkeys. Properties like this don't come around often. This could be used as your everyday home or a weekend get away. Call today to make this your hunter's paradise.
MlsNumber: --
ListingId: 4097846


Listing Provided By: Hopper Properties, original listing
Phone: (601) 540-5040
Office Phone: (601) 724-1435
Agent Name: Shane Saxton
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App