Title Page Background
DEBUG FN args: Array ( [0] => 1430 [1] => [2] => [3] => agent ) BEFORE: Site: 1430 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1430 Igate: njhud LocID: 1430 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 = 1430 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1430 [1] => [2] => [3] => lender ) BEFORE: Site: 1430 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1430 Igate: njhud LocID: 1430 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 = 1430 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1430 [1] => [2] => [3] => other ) BEFORE: Site: 1430 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1430 Igate: njhud LocID: 1430 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 = 1430 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

9053 Castalian Springs Rd
Durant, MS 39063
Samuel D Sample with Tom Smith Land & Homes, original listing - (601) 898-2772

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $425,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2669 Square Feet
Agency: Tom Smith Land & Homes
Agency Phone: (601) 898-2772

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 42 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1997
Notes: This Holmes County home and property offers a unique opportunity to enjoy a modern house in a country setting. As you enter the manicured gated entryway and winding drive, you feel the tensions of the world left on the street. Strategically situated on 41.52+/- surveyed acres, the custom-built home is the focal point, located within a beautiful pasture. Inside, you'll find a sleek, modern design with an open layout and split floor plan. The spacious kitchen features granite countertops, stainless steel appliances, and ample storage, including a pantry built into the cabinetry. The kitchen also features an enamel cast iron sink trash compactor, oven, range top, microwave, dishwasher, refrigerator, and island for prep and seating space. There are both formal and casual dining areas, and the laundry room offers a deep sink with plenty of space for a washer, dryer, and freezer. Additionally, interior and exterior storage space is abundant. Two generously sized guest or children's bedrooms have walk-in cedar closets and share a well-lit full bath with cultured marble surfaces and excellent storage. The primary bedroom is spacious enough for a king-sized bed and a sitting area, with built-in cabinetry for an entertainment center or workspace. This room has double walk-in cedar closets. The primary bath features a jetted tub, a separate cultured marble shower, and beautiful countertops and cabinetry. A large living room with custom cabinets and a fireplace separates the bedrooms. Gas logs offer warmth and ambiance at the flip of a switch. The home offers a stately entrance through the front door and convenient access from the garage. Outside, the property includes a large pond, attractive pasture, a farm barn, a modern metal shed with concrete flooring and gravel apron, and an additional outbuilding for storage. Schedule your appointment today to experience this impressive property for yourself!
MlsNumber: --
ListingId: 4111988


Listing Provided By: Tom Smith Land & Homes, original listing
Phone: (601) 898-2772
Office Phone: (601) 898-2772
Agent Name: Samuel D Sample
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