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

100 East 1890
Rattan, OK 74562
Ashley Smith-Cooper with Babcock Real Estate, original listing - (580) 317-3790

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $14,000,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Babcock Real Estate
Agency Phone: (580) 317-3790

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1,455 sqft
Garage: Garage
Property Type: Land-Other
Year Built: --
Notes: Imagine a once in a lifetime opportunity giving you a chance to claim your own slice of paradise, to secure a piece of land that promises endless possibilities and unparalleled beauty. Nestled within a sprawling 1,455 acre expanse of pristine wilderness lies a haven for outdoor enthusiasts and nature lovers alike. This picturesque landscape, adorned with lush forests, meandering creeks, and rugged terrain, offers an unparalleled escape from the hustle and bustle of everyday life. At the heart of this natural sanctuary are its ATV trails, winding their way through the diverse terrain, from dense woodlands to open meadows and rocky slopes. These trails beckon adventure seekers to explore the beauty of the land on their all-terrain vehicles, providing exhilarating rides and breathtaking vistas at every turn. The waterways offer opportunities for fishing, wading, and wildlife observation. The property has four cozy cabins, nestled amidst the trees and offering a perfect blend of rustic charm and modern comfort. Whether seeking a peaceful retreat for two or accommodations for a group getaway, these cabins provide a welcoming sanctuary after a day of exploration and adventure. RV enthusiasts will find 24 dedicated RV hook-up sites, strategically positioned to offer both convenience and immersion in nature. Each site is equipped with all essential hook-ups, ensuring a hassle-free stay while allowing guests to fully embrace the rugged beauty of the landscape. A spacious shop, serving as a hub for gear storage, repairs, and maintenance. This facility provides a convenient resource for adventurers preparing to explore the vast wilderness beyond. For those seeking respite after a day of outdoor exploration, a well-appointed bathhouse awaits. This facility offers modern amenities amidst the rustic charm of the wilderness. Hot showers and ample space ensure that guests can refresh and rejuvenate in comfort, ready to embark on their next adventure.
MlsNumber: --
ListingId: 11329304


Listing Provided By: Babcock Real Estate, original listing
Phone: (580) 317-3790
Office Phone: (580) 317-3790
Agent Name: Ashley Smith-Cooper
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