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

5472 Dry Grove Road
Terry, MS 39170
Tiffany V Edinburgh with Mississippi United Realty, original listing - (601) 665-4441

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,900
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3600 Square Feet
Agency: Mississippi United Realty
Agency Phone: (601) 665-4441

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 51 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: Prepare to be amazed by this stunning executive/family style two story home with 3 bedrooms and 3.5 bathrooms nestled on approximately 51+/- acres offering lots of privacy. This home embodies a relaxed and easy living lifestyle. Drive through the easement to be welcomed by an active pond with live bass and bream fish. There are serene areas for relaxation or entertainment all throughout the land. There is ample parking for 2.5 car spaces. This 3600 square foot home offers a massive master bedroom with a brick fireplace overlooking the green acres. The master bathroom beams with natural light and has a panoramic view. It also includes a bidet. The bedrooms are on a split floor plan with the master being downstairs. The other bedroom located upstairs, which could serve as a second master suite, is equipped with a large walk-in closet and a full bathroom.This property has a grand great room with 27 ft floor to ceiling double pane insulated glass windows. The fully equipped kitchen comes with all appliances and a large breakfast bar plus an eat in area. The adjacent dining room can comfortably seat up to 10-12 guests. Overlooking the wrap-around porch, each room projects beautiful calm views of natural nature. There are three A/C units and a back-up generator.For all land and forest lovers, there are open pre-paved trails, vegetation beds/sections for growing crops. This property is perfect for hunting season whereby deer and turkey are active. You will be amazed that this land comes with a couple deer towers/ranges for hunting season. Conveniently located off of I-55 or Hwy 18, just minutes away from schools, restaurants and hospitals, this home has a great layout and land galore, offering endless potential to create your dream space. This is a unique property, and there is more to see! Don't miss out - schedule your viewing today!
MlsNumber: --
ListingId: 4106171


Listing Provided By: Mississippi United Realty, original listing
Phone: (601) 699-6111
Office Phone: (601) 665-4441
Agent Name: Tiffany V Edinburgh
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