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

380 Current River Trail
Maynarad, AR 72444

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $540,000
Beds: 5
Baths: 2
Status: Active
SqFt: 3200
Agency: Pocahontas Real Estate Co.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1999
Notes: This stunning riverside home on the Current River is located at 380 Current River Trail in Randolph County, Arkansas. This custom ranch style house has plenty of room with almost 3200 square feet of total living space on 1.5 manicured acres. On the main level, you'll find 2 bedrooms (one could be a bonus room) and one bath, a spacious kitchen and pantry with adjoining dining room that flows into the beautiful living room area overlooking the river. A vaulted pinewood ceiling and custom details highlight the home throughout. From the living room, you can walk outside onto the fully screened-in deck, with Bluetooth speakers installed, to enjoy nature and marvel at the river's beauty that flows along the back yard. Below, you will be amazed at the large entertainment/living room and another full kitchen! Three bedrooms and one master-bath along with a storage room downstairs basically makes this into two homes under one roof and ideal privacy for guests or extended family. This fabulous home itself is very comfortable and spacious with views to the river from most rooms due to the numerous windows allowing the natural light and beauty to be seen. Outside you will find a custom fence around the back yard, perfect for pets, and multiple areas to entertain or cook outside. The golf course like backyard, with huge shade trees, extends to the river and gently slopes into the water, making this the picture-perfect place to unwind and enjoy what Current River has to offer with swimming or fishing from your own property. Another very nice bonus with this property is the 30'x25' Shop with a covered addition. The shop compliments the home and has an overhead door, wired with 220V, along with RV hook-ups just to name a few features. This property is in the Current River Acres subdivision which includes use of a private boat ramp which is really nice and convenient. By boat, you are only about a 30-minute ride to Doniphan, Missouri or spend the day Kayaking downstream to other public take-out points. For the fishing enthusiasts, this river is known for the vast array of different species. This home is not in a flood-zone and doesn't require flood insurance. This amazing riverfront property could also be used as a vacation home, investment property, wedding venue or family retreat. This fabulous custom-built house with shop on the Current River truly has everything you would ever want in a waterfront property to call home!
MlsNumber: 11224417


Listing Provided By: Pocahontas Real Estate Co., original listing
Name: Pocahontas Real Estate Co.
Phone: (870) 892-8542
Office Name: Pocahontas Real Estate Co.
Office Phone: (870) 892-8542
Agent Name: Jade Wells
Disclaimer: Copyright © 2024 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 168 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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;
Real Estate Expert Photo for Sarah Smith
Sarah Smith
ASCIIGeneric Real Estate
Cell: (241) 555-1812
Office: (241) 555-1776

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App