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

001 Greens Crossing Road
Ridgeland, MS 39157
Chad Segrest with Hopper Properties, original listing - (601) 724-1435

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,660,490
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Hopper Properties
Agency Phone: (601) 724-1435

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 241 acre(s)
Property Type: Land-Other
Year Built: --
Notes: The Main Farm as the family called it, is located on Greens Crossing Road in Southwest Madison County and consists of 241 +/- of primarily hardwood timber with scattered Pine and selective open canopy growth. Two farm ponds are located with an emphasis on wildlife use but can be recreationally fished. Multiple whitetail sightings observed during trail marking and on property visits. An approximate 30'x70' Metal pole barn for tractors and equipment is on the SW of the property and hidden amongst the oaks. 5 large food plots are established, multiple feed sites and mineral stations located throughout. Terrain in slightly rolling with hill top views and 2 easily navigated low water crossings. The main bridge is solid as a rock made from an 18 wheeler chassis. It easily holds recreational vehicles and a tractor but will need new decking. It is safely crossable now. The roads are clear and cut back only requiring clipper maintenance. The deer habitat is what makes this property so desirable and why it holds such a healthy herd. Transition edges, grass fields, open hardwoods, thick bedding, vantage points, and creek bottoms offer year round safety and food for deer. Hunting pressure throughout the years has been responsible and light. One very large land owner borders the North and the other 3 land owners are like minded. This track boasts very healthy aged buck populations, strong turkey history, and small game. Multiple species of oak noted, and very little pine damage due to drought isolated to small pockets an individual trees. The Main Farm has been in the family for many years. Overall the property has what could be described as good accessibility and multiple interior roads with one main entrance and one secondary entrance both off Greens Crossing road. Property lines are delineated by older fencing and an observed newly surveyed line by the neighbor along the East line. Much value lies in proximity to Madison and the metro area as it takes as little as 10 minutes from Bridgewater or 15 minutes from Ridgeland and Madison to arrive on site. The property is purely recreational in its current state and impressive at that, but the future of this area is becoming clearer by the month as south Madison county and North Hinds county is extremely bright. To put it lightly the investment potential is very high. For those wanting to build a cabin, just take your pick of sites as there are many. I would not call this a refined property yet, but it boasts all the hallmarks of being one. A little effort and personal touch coupled with basic knowledge of refining undeveloped land can be done in short amount of time. The Main Farm at Greens Crossing is exactly what you are looking for in central MS hunting: proximity, deer size, timber, Flora and Fauna, accessibility, surrounding land owners, privacy, and investment!
MlsNumber: --
ListingId: 4085917


Listing Provided By: Hopper Properties, original listing
Phone: (601) 624-6624
Office Phone: (601) 724-1435
Agent Name: Chad Segrest
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.


Local Real Estate Expert

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 = 1449 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;
Real Estate Expert Photo for Camryn Greer
Camryn Greer
ASCIIMcCool Thorpe Real Estate
Call Today!: (662) 739-7661

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App