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

22900 W Skelly Road
Haskell, OK 74436
Jacob Barnes with Keller Williams Advantage, original listing - (918) 712-2252

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,850,000
Beds: --
Baths: --
Status: Active
SqFt: 16562 Square Feet
Agency: Keller Williams Advantage
Agency Phone: (918) 712-2252

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 41 acre(s)
Property Type: Commercial Sale-Mixed Use
Year Built: 2021
Notes: Located outside of City Limits on paved road with quick access Hwy 64 this property holds Over 38,000sqft of multi-use warehouse space sitting on 41 Acres accompanied by a +/- 1,000 Sqft 2 Bedroom 2 Bathroom Home and a 30x50 Storage Building with a 10x50 Lean To. Features of the commercial/warehouse space includes: 2,000 total Amps with 3 Phase Available, Full Security System with Alarms and Cameras, 2 Generac Generators (350 KW and 650 KW), 6- 20 Ton A/C Units, 2- 10 Ton A/C Units, 2 Separate Vaults, Metal Structures are spray foamed with 2" closed cell, there is 5,000 Sqft of Office Space with 7 Private Offices in Total, The commercial/warehouse space has 5 Total Bathrooms with 1 having a Shower, there are 6 - 1,000 Gallon Propane Tanks on site, and many more features. The interior of the commercial space has been built out with "false walls" allowing for them to be removed for future customization to meet your desires and needs. This is an excellent opportunity to expand your business in a rural area with quick and easy access to Tulsa, Muskogee, Ft. Smith AR, OKC, Joplin MO, etc.
MlsNumber: --
ListingId: 2436414


Listing Provided By: Keller Williams Advantage, original listing
Phone: (417) 389-7780
Office Phone: (918) 712-2252
Agent Name: Jacob Barnes
Disclaimer: Copyright © 2024 MLS Technology, Inc. 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