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;

601 Scr 64a
Mize, MS 39116
Linda Curlee with Main Street Realty LLC, original listing - (601) 849-3226

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $700,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 6188 Square Feet
Agency: Main Street Realty LLC
Agency Phone: (601) 849-3226

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1993
Notes: This is a traditional home with pond+/- 40 prime acres surrounded by mature shade trees in Smith county, MS. There is additional adjacent acreage suitable for crops, cattle, hunting, fishing or recreation available for purchase with barns, ponds and spring-fed creek. An excellent place to make a compound/retreat for your extended family, or if you are looking for a secluded sanctuary this is it. This nearly 6200 SQ FT home features 5 bedrooms, 4.5 baths; office/nursery; a bookcase lined great room with high beamed ceilings; living and dining rooms; wet bar sun room; and utility room with prep kitchen. Ideal for weddings/special events. Spacious main kitchen has an expansive marble topped island with cooktop; pullout drawers in lower cabinets; built-in double ovens, dishwasher and refrigerator. Four upstairs bedrooms, and a den/game room with balcony, overlook scenic views of yard, pastures and ponds. Other features include a grand entryway from the front circular drive with graceful curving staircase; 3 burning and 2 gas log fireplaces; walk-in closets: plus wide doors and hall ways on main floor. A John Deere diesel generator powers the whole house in a power outage. Ample storage in multiple attics throughout, even more in the attached 3 car garage with a broad bank of built-in cabinets.Included in the 40 acres is a grove of 20 year old new growth pines soon suitable for harvesting (if desired).Property is served by the excellent Mize Attendance Center school, in Smith county.
MlsNumber: --
ListingId: 4080502


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