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

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $524,900
Beds: 4
Baths: 3
Status: Active
SqFt: 3363
Agency: Prudential Ann Prewitt Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Property Type: Residential
Year Built: 2014
Notes: HAVE YOU EVER WANTED TO COME HOME TO YOUR VERY OWN PRIVATE COUNTRY RETREAT!!! Look No Further Than This Beautiful Serene Property!! The 4 Bedroom/3 Bath Farmhouse Is Situated On 8.4 Acres With STUNNING VIEWS Of Lavish Hardwoods and Gorgeous 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!!!BREATHTAKING VIEWS OF TRANQUIL OUTDOOR SURROUNDINGS AWAITS YOU 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!! And Did I Mention The HUGE Covered Porch Along With An Extra Sitting Area..Plus Fire Pit That Completes This Entertainment Barn Experience!!!!!!Don't Delay Call Your Realtor Today For A Private Showing!!
MlsNumber: 4057617


Listing Provided By: Prudential Ann Prewitt Realty, original listing
Name: Prudential Ann Prewitt Realty
Phone: (601) 668-6534
Office Name: BHHS Ann Prewitt Realty
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