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

76 Dream Hill Drive
Poplarville, MS 39470

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,895,000
Beds: 5
Baths: Full: 3, ½: 2
Status: Active
SqFt: 6294 Square Feet
Agency: Berkshire Hathaway HomeServices Preferred, REALTOR
Agency Phone: (985) 951-2324

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 294 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: A family's oasis or hunter's dream, this secluded estate encompasses almost 300 acres including a private 22-acre stocked lake, fishing and boat dock, and many ponds. Beautiful cleared fields are surrounded by plentiful hard woods ideal for deer hunting. You can hunt in the mornings / evenings & fish all day long! There are miles of trails perfect for horseback riding, hiking & four wheeling. There are 2 fenced pastures for your favorite horses or other animals! Just over a 1-hour drive from New Orleans, the Northshore, Gulf Coast, & Hattiesburg, this serene property offers easy accessibility. As you enter the estate, the oak-lined drive brings you by a quaint pond with a lovely gazebo. Leading up to the main home you will notice a guest cottage on the left, & a 2nd cottage on the right. The 3-story main house includes 5 large bedrooms, 3 full baths + 2 half baths with additional bonus rooms throughout. Pine & reclaimed wood flooring (as the story goes, from a barge) throughout the 1st floor. Beautiful views from every window & large front porches on the 1st and 2nd floors. Amenities include an expansive patio overlooking the 40x20 in-ground pool with a stunning view of the lake. The 2-story guest cottage is 1,621 sqft and includes a large living/dining area, kitchen, large bedroom, 2 full baths & an outside deck. The 2nd guest cottage is 1,292 sqft and has a large open floor plan, kitchenette/wet bar & a full bath - ideal for a game room/entertainment + sleeping quarters. Across the lake there is a blueberry orchard with irrigation & pecan orchards around the property. Additional amenities include a hay barn & pole barn with plenty of storage. The property has both community & well water. Extensive wireless video surveillance throughout the grounds. There are 3 tractors available for a separate purchase. (See agent remarks). This uniquely versatile property is ideal as a family home, for raising cows & horses, as a hunting club, or even a bed & breakfast.
MlsNumber: --
ListingId: 2464103


Listing Provided By: Berkshire Hathaway HomeServices Preferred, REALTOR, original listing
Phone: (228) 697-3714
Office Phone: (985) 951-2324
Agent Name: Holly Gibbs
Disclaimer: Copyright © 2024 Gulf South Real Estate Information Network. 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