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

398286 W 4100 Rd
Ramona, OK 74061

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,185,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Arrowhead Land Company
Agency Phone: (833) 873-2452

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 78 acre(s)
Garage: Garage
Property Type: Commercial Sale-Other
Year Built: --
Notes: Welcome to the Tallgrass N' Tin Ranch! This ranch offers an extraordinary business and development opportunity in an amazing location! As you travel down the gravel drive of this 78 +/- acre ranch, you are met with a beautiful barn-styled, 100 x 40-foot event hall. This area provides an unlimited amount of potential to hold events, weddings, businesses, or even be turned into luxury stables. The opportunities are endless when it comes to what you can utilize it for! With concrete flooring and air conditioning, you will be able to regulate the temperature with ease. On each end of the barn are two garage doors and sliding barn doors that lead you in and out. Moving through the main hall, you are greeted with a stunning dining area measuring 70 x 40 feet. With plenty of table space and a rustic bar, this is an awesome area to host meals. Connected is a nice large kitchen to prepare any size of meal. There are two spacious rooms that can be used for housing guests, or however you see best fits your business. There are both men's and women's restrooms, perfectly set up for the public. The sky's the limit on what you can do with this space! There is also a great storage area with an outside garage door making it easy to add and remove your belongings. Adjacent to it is a 30 x 40-foot garage with concrete flooring that offers ample space for vehicles and storage, as well as a 20 x 40-foot lean-to. To top it off, there is a 4-stall horse barn! The one-acre gravel parking assures there will be plenty of space for visitors to park while enjoying the beautiful Tallgrass N' Tin Ranch! Looking out the back of the main hall is a beautiful pond stocked full with catfish that provides great fishing. The property is complimented nicely with white-painted pipe fencing. The opportunities don't stop there! The rest of the ranch is covered in thick open pastures along with batches of timber. Having access to several other ponds adds to the fishing potential as well as provides a great water source for livestock and wildlife. If you are looking to primarily use this property for ranching, not only are you set up with amazing facilities, but the ground is exceptional as well. Whether you are looking to graze and take advantage of the cross-fencing or use it for hay production, the rest of this 78 +/- acre ranch is ready for anything you desire. The location could not be any better! Situated on the Tulsa County line, set in Washington County, Oklahoma, and with paved road frontage, you are just 10 +/- minutes from Collinsville and Skiatook, 15 +/- minutes from Owasso, 20 +/- minutes from Tulsa, and 30 +/- minutes from Bartlesville. While it is found right off Highway 75, you still can experience the peacefulness and beauty of Washington County! The caliber of this ranch and the location it is in is truly unmatched! Whether you are wanting to invest in an event center, wedding venue, restaurant, or utilize it for ranching, the business opportunities are endless with the Tallgrass N' Tin Ranch! All showings are by appointment only.
MlsNumber: --
ListingId: 11289481


Listing Provided By: Arrowhead Land Company, original listing
Phone: (918) 859-2412
Office Phone: (833) 873-2452
Agent Name: Charles Bellatti
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