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

11281 Highway 21
Forest, MS 39074
Colby Watson with Tom Smith Land & Homes, original listing - (601) 898-2772

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,130,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3500 Square Feet
Agency: Tom Smith Land & Homes
Agency Phone: (601) 898-2772

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 15 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2019
Notes: Upon leaving the highway, a 3/10-mile driveway leads to the stunning house overlooking the pond. The 3,500-square-foot house features a spacious 2,000-square-foot wrap-around porch, offering panoramic views of the picturesque 5-acre stocked pond filled with bass and bream, perfectly situated for sunset admiration. The screened back porch provides an ideal spot for sunrise views and boasts a beautiful wood-burning fireplace. The house is topped with a seamless metal roof. Inside, approximately 80-85% of the house is crafted from wood harvested from the property. With 4 bedrooms and 3 full baths, the house includes a living room with a striking 25-foot vaulted ceiling and a stone fireplace reaching to the ceiling, equipped with gas logs. Upstairs, a balcony with a sitting area provides a serene spot to gaze over the pond. The kitchen is a chef's dream, featuring custom-built cabinets, granite countertops, and a gas stove. A 500-gallon in-ground propane tank powers the on-demand water heater, stove, and gas logs. Climate control is ensured by two four-ton AC/heating units for the bottom floor and two two-ton units for the top floor. Additionally, there's a convenient 2-car open-style carport with a storage shed and a bathroom with a sink. The property also has a spacious 20x40 pole barn, walled on three sides, providing ample storage for equipment. This unique property spans approximately 180 acres, featuring an established road system and multiple sites for food plots. Abundant wildlife signs and frequent deer sightings make it a nature lover's paradise. The property being clear-cut five years ago, now has 5 year regeneration pines growing. This extraordinary house is truly a one-of-a-kind gem.
MlsNumber: --
ListingId: 4083748


Listing Provided By: Tom Smith Land & Homes, original listing
Phone: (601) 668-8096
Office Phone: (601) 898-2772
Agent Name: Colby Watson
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