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

2568 Highway 481
Raleigh, MS 39153
Debbie Jones with BHHS Ann Prewitt Realty, original listing - (601) 898-0663

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $524,500
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 3363 Square Feet
Agency: BHHS Ann Prewitt Realty
Agency Phone: (601) 898-0663

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2014
Notes: BEAUTIFUL SERENE SURROUNDINGS AWAITS YOU WITH THIS EXTROIDINARY PROPERTY!!!! The 4 Bedroom/3 Bath Farmhouse Is Situated On OVER 7 Acres With GORGEOUS VIEWS Of Lavish Hardwoods and Pond!! Inside On The First Floor You Will Find An Open Floor Plan With A Screened Back Porch Off The Living Area Overlooking The Property!! Features Of This Home Include Granite Countertops, Huge Pantry, Huge Laundry Room, Lots Of Storage, 36'' Accessible Door Openings, Attached Air Conditioned Workshop, And Energy Efficient Icynene Insulation. The Master Suite Has Barn Door Windows And Bathroom Includes A Huge Shower And Large Walk In Closet!! A Second Bedroom And Full Bathroom Complete The First Floor. Second Floor Includes a BONUS ROOM, Third And Fourth Bedroom, Sitting Area, And Beautiful Bathroom With Double Sinks!!!RETREAT STYLE LIVING AT ITS BEST WITHBREATHTAKING VIEWS OF OUTDOOR SURROUNDINGS ARE SEEN THROUGHOUT THIS HOME!!!!!!!!!!!!!!AS IF THIS WASN'T ENOUGH, THE PROPERTY Also Accompanies An 80X40 ENTERTAINMENT BARN!! COMPLETE WITH Rustic Style Kitchen, Full bathroom (Including A Separate Urinal), Workshop with Loft Area, And Bay Door. Barn Also Has An Additional Separate Covered Area For Your Tractor!!.. Oh!! Did I Mention The HUGE Covered Porch Along With An Extra Sitting Area AND Fire Pit Which Completes This Entertainment Barn Experience!!!!!!Don't Delay Call Your Realtor Today For A Private Showing!!
MlsNumber: --
ListingId: 4094582


Listing Provided By: BHHS Ann Prewitt Realty, original listing
Phone: (601) 672-9372
Office Phone: (601) 898-0663
Agent Name: Debbie Jones
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