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

33856 Highway 32
Oakland, MS 38948
Jason Burch with Burch Realty Group, original listing - (662) 893-1700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $479,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1740 Square Feet
Agency: Burch Realty Group
Agency Phone: (662) 893-1700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 47 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: 47+/- acres with 2 homes, 1 apartment and 3 barns/outbuildings located on Highway 32 in Tallahatchie County, MS. The main home is 1759 sf with 3 bedrooms and 2 bathrooms. The home will sell partially furnished including dishes, utensils, pans, flatware and appliances. Split floor plan with each bedroom having a large walk in closet. Huge family room at the front entry and great room with kitchen view located at the rear entry. Vaulted ceilings in the family room. Primary bathroom features a walk in shower. Covered front porch and covered back patio area great for entertaining and features a propane heater. 20X20 attached carport, 12X20 work shed and 8X18 detached carport. The second home is approximately 1,400 sf, 3 bedrooms, 2 bathrooms and will be selling partially furnished including dishes, glasses, pans and appliances. Large covered front porch, 20X20 detached carport. This home is in need of work but would make a great rental. The detached apartment is approximately 600 sf, 1 bedroom, 1 bath and will sell partially furnished with appliances which include washer and dryer. This structure features a 24X24 attached covered carport. Apartment is in need of repairs. Great rental potential. All 3 residential structures have their own separate meter. The 3 outbuildings included with the property are a 1300 sf fully enclosed motor home bay with attached storage/work space and wash bay. The 2nd is an 18X30 barn that is need of repairs. The 3rd is a 20X20 horse ban with 2 fully covered stalls inside of 2 fenced acres of land. The 47 acres of land consist of approximately 35 acres of 40 year old pine, scattered hardwoods and 3 ponds. Internal roads through the property great for horse back riding or 4 wheeler riding. This will make the perfect homestead with plenty of land for hunting.
MlsNumber: --
ListingId: 4103590


Listing Provided By: Burch Realty Group, original listing
Phone: (662) 274-4935
Office Phone: (662) 893-1700
Agent Name: Jason Burch
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