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;

697 Little Big Mound Road
Bentonia, MS 39040
Shane Saxton with Hopper Properties, original listing - (601) 724-1435

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $575,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3222 Square Feet
Agency: Hopper Properties
Agency Phone: (601) 724-1435

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: Welcome home to this cozy 5 bed/4.5 bath home that sits nestled on approximately 5.5 acres+/- and backs up to large landowners. Enjoy wildlife and the peace of country living right from your very own front porch. No need to leave to go hunting when you can hunt right from your very own back door. Natural light filters within the home from the many windows featured throughout. The spacious living room features built-in shelving and cabinet for storage. Enjoy sitting inside your home next to the warm fireplace from the comfort of your living room. The kitchen is equipped with stainless steel appliances as well as many cabinets and drawers for plenty of storage space. There is a kitchen island with breakfast bar area for additional countertop space and seating. Retreat to peace and privacy within the large primary bedroom. The primary bathroom features a sliding barn door entrance, double vanities, soaking tub and walk-in shower with double shower heads. The laundry room features cabinet space for storage as well as a hanging rod. Enjoy grilling and relaxing on your screened back patio. This area is perfect for entertaining company. The property also features a 30x80 shop with an 18 foot lean to which is great to use for storage. There is framework completed for future living space in the shop as well. If you enjoy the peace and tranquility of country life and being able to hunt right from your home, then don't wait to make this house your new home! Call today!
MlsNumber: --
ListingId: 4100361


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