Title Page Background
DEBUG FN args: Array ( [0] => 1466 [1] => [2] => [3] => agent ) BEFORE: Site: 1466 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1466 Igate: njhud LocID: 1466 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('mihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1466 [1] => [2] => [3] => lender ) BEFORE: Site: 1466 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1466 Igate: njhud LocID: 1466 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('mihud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1466 [1] => [2] => [3] => other ) BEFORE: Site: 1466 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1466 Igate: njhud LocID: 1466 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('mihud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

22411 Us-80
Lake, MS 39092
Brad Forsythe with Phillips Appraisal & Realty, original listing - (601) 741-2158

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $985,000
Beds: 3
Baths: Full: 4
Status: Active
SqFt: 7000 Square Feet
Agency: Phillips Appraisal & Realty
Agency Phone: (601) 741-2158

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Property Type: Residential-Multi Family
Year Built: 2015
Notes: Here is your slice of paradise on 40 sprawling acres of picturesque beauty! Nestled within this enchanting property is a stunning venue that has the complete potential to be whatever you can dream it to be (wedding venue, business conference training ground, church camp retreat, restaurant, rv park, etc) it promises to elevate any business idea or maybe even your personal retirement homestead! This beautiful rural location is a vision of elegance and sophistication, meticulously designed to cater to every desire ensuring a flawless meeting or celebration. The main building has a fully loaded commercial kitchen with all commercial equipment that will remain, natural gas commercial stoves/ovens, there is a large banquet room area both upstairs and downstairs that seats 300, two full bathrooms with two stalls and a shower in each, four 5ton central AC /Heat units, 2 upstairs and 2 downstairs, a 3 ton separate auxiliary splitter AC unit in kitchen, upstairs furnished game room, upstairs covered back deck with spectacular view of the 2.5 acre stocked pond and property, two 15x60 outside covered patio wings attached to barn with one as an outdoor fully stocked screened-in kitchen and the other as an outdoor dining area, a massive indoor storage room, the inside of back corral area is an open concrete paved basketball court, a wrap around concrete circle drive around the entire barn for easy drop-off and pick-up, three highway entrances to the property with two entrances serving as a separate private entrance to both the pond and the living quarters from highway. This property also boasts a beautiful 2006 16x80 3 bed 2 bath recently upgraded and remodeled living quarters with 2 new porches, new skirting, and brand new septic and water utilities. Also for your guests seeking more accommodation, the property offers 6 full RV hookups (with plenty of room for more spots to be added), ensuring that everyone can relax and enjoy all the festivities that will take place on these beautiful grounds without a care in the world. There is also a 8ft privacy wood fence equipped with decorative street lamps around the RV area that offers beautiful aesthetics along with complete privacy.The possibilities here are endless! And do not forget the entire property is fenced. Come get swept away by this extraordinary diamond in Central MS on Highway 80 two miles east of Raytheon between Forest and Lake just 4 1/2 miles from Interstate 20 @ Exit 100
MlsNumber: --
ListingId: 4106283


Listing Provided By: Phillips Appraisal & Realty, original listing
Phone: (601) 416-0283
Office Phone: (601) 741-2158
Agent Name: Brad Forsythe
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