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

27473 Ms Hwy 82
Mccarley, MS 38943
Snooky Hill with Hopper Properties, original listing - (601) 724-1435

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,000
Beds: 11
Baths: Full: 11
Status: Active
SqFt: 9710 Square Feet
Agency: Hopper Properties
Agency Phone: (601) 724-1435

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 57 acre(s)
Property Type: Commercial Sale-Mixed Use
Year Built: 2010
Notes: The possibilities on this property, because of the platform and infrastructure already done, will allow amazing flexibility for someone to make this a incredible income generating property. The highlights and details are far too many to list. This property includes a 9,710 sq. ft. living facility which contains a living/dining area, furnished kitchen, activity room, conference room, office, beauty shop, and 11 bedrooms (4 double bedrooms, 7 single with 1 being handicap accessible). Each room has a bathroom, living/bedroom area, closets, compact refrigeration units, split ductless heat pump systems, and wall safes. The 16 space concrete parking lot, MS Hwy 82 road frontage, and is only 2 miles to I-55 near Winona making it a great centrally located facility in our state. Uses for a facility like this include a training facility, children's or youth retreat, assisted living center, nursing home, rehab facility, or even a hunting lodge or create a RV park. A mobile home park would be high on the list of options as well. On the 58 acre property, you can find plenty of white-tailed deer, and a 5 acre fishing lake is loaded with bream and bass. Owner indicates that the property is fenced with cyclone fencing. There is a mobile home currently returning a rent to owner but would make a very easy office or keep as is. Give Chad or Snooky a call today for more information and to schedule a tour of this property!
MlsNumber: --
ListingId: 4106262


Listing Provided By: Hopper Properties, original listing
Phone: (601) 906-1913
Office Phone: (601) 724-1435
Agent Name: Snooky Hill
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