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;

172 S Fork Ranch
Poplarville, MS 39470
Thomas N Smith with Tom Smith Land & Homes, original listing - (601) 898-2772

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $6,975,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Tom Smith Land & Homes
Agency Phone: (601) 898-2772

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 373 acre(s)
Property Type: Land-Other
Year Built: --
Notes: This 373+/- acre Equestrian paradise in Poplarville, Mississippi, is the most breathtaking place imaginable. Upon entering the Honor Hill Farms gates, it is immediately apparent that you have arrived at one of the country's most prestigious estates. Honor Hill, home to award-winning thoroughbreds, sets the standard in the Hunter/Jumper arena of the present day. There is nothing of subpar quality at Honor Hill Farms. The main horse barn features 14 stalls, all rubberized floors and bathroom walls, an air-conditioned lounge and dressing room, a vet room, an office, a full laundry room, tack and feed rooms, and a 900-square-foot covered porch. You may continue your tour of the main complex down the winding asphalt street lined with Priefert fencing throughout the entire property. This custom-built barn is composed entirely of tongue-and-groove using the highest-quality materials available. Next, you will cross over the dam of the 14-acre lake managed by Southeastern Pond Management and stocked with trophy bass and bream. Once you reach the primary residence, you will be awed by the 4,680 square foot, two-story, four-bedroom, three-bathroom, custom-built home that overlooks the lake and delivers breathtaking views of the entire property. Now that you've taken in the awe-inspiring beauty and quality of the location thus far, it's time to appreciate Honor Hill truly! The children's playground and the fully enclosed 38'x18' swimming pool are near the parking area. The 3,621-square-foot garage for your cars, toys, and boats is adjacent to the swimming pool! There are two floors and ample space! You have a 576 SF, professional-grade kitchen for entertaining, complete with all freezers, coolers, ovens, fryers, and cooktops (all commercial grade). Welcome to your very own saloon when you are ready to unwind and enjoy a beverage of your choosing. The beauty and craftsmanship of this facility, which features a 40-foot bar, will leave you speechless. This facility has five bedrooms and 6,233 square feet of rustic beauty and world-class construction. At Honor Hill Farms, there are six large-screen televisions and gathering areas where you can enjoy fellowship or watch your favorite sporting event. Behind the main residence is a Girls' House for your guests' enjoyment. It has four king-size beds and a magnificent bathroom with a four-person custom shower. This venue is ideal for your guests, a girls' night out, and special events such as wedding receptions, etc.! After settling in, you may wish to engage in a little physical activity. Not a worry here! Just enter your very own 1,500-square-foot fitness center, complete with free weights, machines, ellipticals, treadmills, mirrors, and more! The fitness center doubles as a game room with billiards, foosball, shuffleboard, air hockey, etc. In addition, this building has a real jail cell that serves as a gun room or storage space for your valuables! It is an impressive sight! Across from the Saloon is the 2,560 square-foot Saloon Equine Barn, which has four rubberized stalls, tack, hay, feed storage, and a large grooming area. In addition, two loafing sheds and a 200-by-200-foot lighted arena for barrels and jumping are located behind this barn. And for everyone, across from the barn is a 576-square-foot restroom building with fun-to-enter men's and women's facilities. The third equine barn, measuring 1,568 square feet with four stalls and a storage area, is located further down the main street. The dog kennels and run (432 square feet) and the chicken coop are close to this barn. Once you reach the end of the main street, you'll find two 1,500 SF workshops containing all the tools and equipment necessary to maintain Honor Hill Ranch. There are 117+/- acres of beautiful pine saw timber and hardwood bottoms that provide excellent habitat for whitetail deer and turkey for outdoor enthusiasts. In addition, there is a good network of internal roads throughout the the woods.
MlsNumber: --
ListingId: 4032052


Listing Provided By: Tom Smith Land & Homes, original listing
Phone: (601) 454-9397
Office Phone: (601) 898-2772
Agent Name: Thomas N Smith
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App