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

466 S Smith County
Taylorsville, MS 39168
Karen Bryant with Hopper Properties, original listing - (601) 724-1435

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $450,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3125 Square Feet
Agency: Hopper Properties
Agency Phone: (601) 724-1435

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Serene Rural Living. Don't miss this 40 Acres of partially wooded terrain, complete with rolling hills, fenced pasture and a stocked pond with channel catfish, bream and bass located directly behind a country home with scenic views in every direction. A second pond is located on the 25 acre parcel. Although neighbors live within 1/2 mile, there is not a house in sight.The home boasts of 2255 sq ft of living space on the main floor and 840 sq ft of living space in the basement. The main floor has 2 large bedrooms and a large bathroom with separate shower and soaking tub. There is also a half bath and laundry room on the main floor. The large living room, dining room, and kitchen are an open concept design with numerous built ins for storage. The kitchen has a large island with a sink and built in cook top. There is a bar in the island that seats 5. The kitchen has a bay window with a view of the beautiful back yard.A door from the dining room provides access to a huge covered deck that overlooks the beautiful scenery behind the house. Under the deck is a patio with glass doors accessible to the basement apartment.Stairs to the basement bedroom/apartment are located in the front entry foyer. The basement is a large 28 x 30 feet for the total 840 sq ft. It has a bathroom with shower, a full kitchen and is currently being used as a third bedroom. The basement kitchen is complete with cabinets and an island bar. A refrigerator and range are also included in the basement kitchen. This area would be great for a recreation room, mother-in-law suite, or a third bedroom. There is additional storage under the basement staircase.This property provides outdoor living at its best! an orchard outside includes 10 fruit trees: 2 peach trees, 2 plum trees, 2 crabapple trees, 2 apple trees, 2 pear trees, blackberry bushes and blueberry bushes. There is a newly designed raised bed garden and a storage shed. The storage shed boasts a generous 504 sq ft and a carport large enough to park vehicles or outdoor equipment. For those who enjoy fresh eggs, there is a chicken coop that includes a large outdoor run. Several acres are fenced for livestock and there is a pond that covers at least 2 acres. The pond is stocked with fish and can be enjoyed from any location around its perimeter. The remaining acreage is filled with mature pine timber and plenty of room for hunting, ATV riding, horseback riding, and many other recreational activities.If you are looking for a home near town, but in a rural setting, this property is a must see! Call to schedule a tour today!
MlsNumber: --
ListingId: 4113572


Listing Provided By: Hopper Properties, original listing
Phone: (601) 507-4006
Office Phone: (601) 724-1435
Agent Name: Karen Bryant
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