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

1216 County Pond Rd
Other, MS 39327

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,495,000
Beds: 4
Baths: Full: 5, ½: 1
Status: Active
SqFt: 4032 Square Feet
Agency: Doug Rushing Realty of McComb
Agency Phone: (601) 249-3400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 844 acre(s)
Property Type: Residential-Farm
Year Built: 2018
Notes: Welcome to Brushy Creek Farms, an extraordinary 844.9 acre Sportsman's Paradise in Decatur, MS. This elite, turn-key property features a breathtaking 4,532 sq ft metal-framed cypress lodge sits high on a hill, offering stunning panoramic sunset views over a private pool and a 27-acre trophy bass fishing lake. The lodge is designed for both comfort and entertainment, comfortably accommodating up to 18 guests. It includes a large 40' x 50' kitchen-living area with granite countertops, Cypress Cabinets, all interior is Cypress, stone wood-burning fireplace, and a separate wet bar all combined makes it perfect for hosting large gatherings.The master suite boasts separate his-and-her closets, an additional owner's closet, and a massive 25'x25' concrete safe room. With five full baths featuring custom tile showers and cypress cabinets, every detail has been thoughtfully crafted for luxury and convenience. The guest wing is equipped with a variety of sleeping arrangements, including four twin beds, two full beds, and two queen beds, along with a utility room for ample storage of guns and gear and has a 832 sq ft shop area with roll-up doors for ATV storage along with a separate mudroom with a utility sink for cleaning fish etc ................ And there is more!!! 3 bedroom/2 bath mobile home serves as an ideal caretaker's residence, a fully equipped She-Shed or office/hobby room with mini-split a/c, half bath and complete with fiber internet connectivity. In addition you will find multiple storage options, including a large 40' x 80' enclosed shop with a truck lift and a 30' x 80' lean-to, totaling 5,600 sq ft under roof, in-ground pool, and Generac backup Generator. The property is loaded with wildlife including deer, ducks, turkey, quail and the Lake is loaded with bass, and bream making it a Hunter's and Fisherman's dream. Some of the best rabbit hunts imaginable along the over 15 miles of well-maintained interior roads equipped with culverts and bridges for easy access, established duck holes and food plots planted with corn and sorghum, complemented by a proven dove field featuring an artificial power line. Can you think of anything else to add? The picturesque 27-acre lake, with areas of standing timber, creates an ideal setting for winter duck hunts and fantastic fishing. Don't miss this once-in-a-lifetime opportunity to own your dream property. Priced at $2,495,000, Brushy Creek Farms is a rare gem that won't last long on the market!
MlsNumber: --
ListingId: 143311


Listing Provided By: Doug Rushing Realty of McComb, original listing
Phone: (601) 249-8436
Office Phone: (601) 249-3400
Agent Name: Alan Bridevaux
Disclaimer: Copyright © 2024 Southwest Mississippi Board of Realtors. 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