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

1728 Scr 86
Mize, MS 39116

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $275,000
Beds: 4
Baths: 2
Status: Active
SqFt: 1860
Agency: Main Street Realty (MSR)

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Property Type: Residential
Year Built: 1972
Notes: Introducing your Dream Country Estate on 8 Acres in the mize school district.Escape to the tranquility of this remarkable country estate, located at 1728 SCR 86 in beautiful Mize, Mississippi. Set on a sprawling 8-acre lot, this property offers the perfect blend of privacy, space, and rustic charm.This enchanting home features 4 spacious bedrooms and 2 beautifully appointed bathrooms. Inside, you'll be welcomed by the warmth of stained wood walls that add a touch of character and elegance to every room. The open layout creates a seamless flow, making it easy to entertain friends and family or simply relax in the comfort of your own home.As you approach the property, you'll notice the charming wood fence that graces the front yard, adding a touch of charm and enhancing the curb appeal. Additionally, the house is surrounded by a barbed wire fence, ensuring your privacy and peace of mind.Stepping outside, you'll be greeted by the breathtaking natural beauty that surrounds you. The expansive 8-acre lot offers ample space for your outdoor dreams to come true - whether it's creating your own mini-farm, enjoying recreational activities, or simply basking in the serenity of nature.Conveniently located in Mize, you'll enjoy the benefits of a peaceful rural lifestyle while still being within easy reach of local amenities, schools, and shops.Don't miss your chance to own this exceptional country estate. Contact us today to arrange a private tour and discover the endless possibilities that await you at 1728 SCR 86. Your dream home in the countryside awaits! Call your favorite local hometown realtor today for your private showing!
MlsNumber: 4058010


Listing Provided By: Main Street Realty (MSR), original listing
Name: Main Street Realty (MSR)
Phone: (601) 849-3226
Office Name: Main Street Realty LLC
Office Phone: (601) 849-3226
Agent Name: Tiffany Kinslow
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