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 = 1458 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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 = 1458 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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 = 1458 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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;

978 Walnut Road
Sardis, MS 38666
Krista Golightly with Local Agency Realty Group, original listing - (662) 253-0808

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $413,000
Beds: 4
Baths: Full: 3
Status: Active Under Contract
SqFt: 3871 Square Feet
Agency: Local Agency Realty Group
Agency Phone: (662) 253-0808

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1981
Notes: Escape to Your Private Country Oasis!Discover timeless charm and modern amenities in this stunning mid-century modern style home, set on 7 breathtaking acres in the countryside. Built in 1981, this 4-bedroom, 3-bathroom retreat offers the perfect blend of style, comfort, and functionality.Step inside to find vaulted ceilings that create an airy, welcoming atmosphere and a gorgeous kitchen with custom cabinetry. The main floor features 3 bedrooms, 2 bathrooms, living room, sitting room, and a cozy wood-burning fireplace to keep you warm on those cold winter nights. Upstairs, the primary suite awaits with an en-suite bathroom & spacious walk-in closet. Right outside the primary is a loft area perfect for an office, reading nook, or sitting area. Enjoy the outdoors and beautiful views from the expansive deck outside the primary or just below on the covered patio, or while lounging by the in-ground pool. The ''pool house kitchen''makes entertaining a breeze, and the surrounding mature trees provide shade and tranquility. For hobbyists or entrepreneurs, the 1080 sq. ft. workshop offers ample space to create, store, or build. As well as the separate craft room that's above the workshop. This property is a rare gem, offering both privacy and plenty of room to roam and explore. Don't miss the opportunity to make this countryside retreat your forever home. Schedule your showing today.
MlsNumber: --
ListingId: 4101449


Listing Provided By: Local Agency Realty Group, original listing
Phone: (901) 461-3712
Office Phone: (662) 253-0808
Agent Name: Krista Golightly
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