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

1635 Sweethome Rd
Grenada, MS 38901
Beth McLellan with National Land Realty, Kosciusko, MS, original listing - (662) 289-5334

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,000,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: --
Agency: National Land Realty, Kosciusko, MS
Agency Phone: (662) 289-5334

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 382 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Escape to your own private paradise nestled within 382 acres of pristine timberland, rolling hills, private lake, and winding driveway leading to a beautiful 2 story lodge. The lodge has 2312 sq ft of living space, with 3 bedrooms, 2.5 baths, and a dream kitchen with a large, granite island that seats 10, and all stainless appliances. The laundry room and pantry is just off the kitchen. The spacious great room overlooks the deck and stocked lake. Delight in the serenity of your own private lake, perfect for fishing, boating, or simply unwinding by the water's edge.  Accommodate guests with ease in the convenient, furnished bunk house, including it’s own kitchen. There is a 4 bay barn with a workroom or office. The property has a 40 kw generator that will run the lodge, bunkhouse, and shop if the power goes out. The land is made up of 100+- acres of 11-12 yr old pine plantation, with the balance in mature hardwood, large food plots, and shooting houses.  Conveniently located within 5 minutes of Grenada, and all the shops and restaurants for you to enjoy. This property offers both seclusion and accessibility, ensuring privacy without sacrificing convenience. Whether you're seeking a weekend retreat, a hunting lodge, or a potential timber investment opportunity, this one checks all the boxes. Don't miss out on this extraordinary offering – schedule your private tour today and discover the endless possibilities awaiting you at this one-of-a-kind timberland retreat.
MlsNumber: --
ListingId: 11253731


Listing Provided By: National Land Realty, Kosciusko, MS, original listing
Phone: (601) 416-8298
Office Phone: (662) 289-5334
Agent Name: Beth McLellan
Disclaimer: Copyright © 2024 My State MLS. 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