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

000 Hwy 2
Clayton, OK 74536
CHUCK CLARK with Red River Realty and Auction, original listing - (580) 924-9595

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $400,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Red River Realty and Auction
Agency Phone: (580) 924-9595

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Garage: Garage
Property Type: Land-Other
Year Built: --
Notes: 40 ACRES ON THE KIAMICHI RIVER !!! Properties like this are a once in a lifetime find! This is a very rare opportunity to own a one of a kind beautiful Kiamichi River property! The river is nice and deep along this awesome property! It is also very good fishing with an abundant of fish and wildlife! Fish ranging from Large Mouth Bass, Spotted Bass, Red Eyed Kentucky Bass, Channel Catfish, Blue Cat, White Cat and the very popular Flathead Catfish, Buffalo, Perch, Gar and more! Wildlife ranging from Whitetail Deer, Wild Boar, Black Bear, Eastern Turkey and Elk! Yes there are Elk on this southeast Oklahoma River property! Because it is located right over the mountain from the Kiamichi Game Refuge and Wildlife Management Area which consists of over 19,000 acres of wilderness all in the Kiamichi Mountains. There has been a lot of state record bucks taken from this area! This amazing oasis on the Kiamichi River even has electric available if you are interested in building your dream get away on the River !!! The Kiamichi River is a major river in Oklahoma and is a navigable river that Kayakers and Canoers love to float and enjoy the beautiful mountainous scenery. The property has various topography with a nice mountain top overlooking the river that would be a great place to build your dream cabin in the mountains with a spectacular view of the river and all of the surrounding mountains it is absolutely PICTUREESQUE ! Talk about peace and tranquility this unique property gives it to you! With all the beautiful pine trees, oaks, and deciduous trees the mountains and the beautiful running river this secluded oasis has it all !!! Don't let this fabulous wonderland get away from you! FOR BEST INFORMATION, CALL LISTING AGENT DIRECTLY.
MlsNumber: --
ListingId: 11081670


Listing Provided By: Red River Realty and Auction, original listing
Phone: (580) 924-9595
Office Phone: (580) 924-9595
Agent Name: CHUCK CLARK
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App