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

369 River Road Drive, Se
Bogue Chitto, MS 39629
Stephany Smith with Betsy Smith Properties, original listing - (601) 833-6305

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $395,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 3450 Square Feet
Agency: Betsy Smith Properties
Agency Phone: (601) 833-6305

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Are you in the market for peace and tranquility just off the cusp of town? This manicured property and home tucked off Highway 84 onto Hog Chain Drive and down the quiet winding River Road Drive to a gorgeous and serene setting which could become your homestead. The scattered pine tree cover, long winding asphalt circular drive which reveals flowered landscaping as you approach the home set nicely off the road is a curb appeal not many can duplicate. And the view from the wrap around porch looking over the 4.37 acres is just as breathtaking. Something I know I could appreciate and enjoy every morning to start my day and each evening as the sun goes down. If you can drag yourself beyond the views from the front porch and into the home, your eyes move immediately upward to the magnificent beadboard cathedral ceiling and over to a roof-line peaked wall of windows most often found at mountain retreats. With an open concept floorplan of the living spaces and a granite countered bar that sprawls along as a kitchen divider for what seems an eternity and provides an opportunity for many family gatherings and the hosting of the friendly game nights and ever popular supper clubs. This home also offers three bedrooms and three full baths with one of each tucked up a wooden stairway on a second level. An additional space of multiple opportunity serves as a transition from the living areas out to the back of the property which could serve as an office, sunroom, or second den.....you decide. Located just out back is a workshop and more of nature's beauty. A second storage building located just off the driveway around the corner provides ample space for those "workshop" like tools and yard equipment if you prefer the previously mentioned space to serve for entertaining by way of mancave, or teenage hangout. Also on the property is a two-car detached garage with a roof pitch that allows for additional storage having a ladder accessible loft-like setup.
MlsNumber: --
ListingId: 143150


Listing Provided By: Betsy Smith Properties, original listing
Phone: (601) 757-2027
Office Phone: (601) 833-6305
Agent Name: Stephany Smith
Disclaimer: Copyright © 2024 Southwest Mississippi Board of Realtors. 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