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

9119 E 12675
Dustin, OK 74839
William Bellis, Jr. with Arrowhead Land Company, original listing - (833) 873-2452

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,950,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1428 Square Feet
Agency: Arrowhead Land Company
Agency Phone: (833) 873-2452

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Farm-Farm
Year Built: --
Notes: Welcome to the Justamere Ranch located in Hughes County, Oklahoma. This ranch is a stunning 800 +/- acres of premier hunting ground. The Justamere Ranch features a 1,428 sq ft log home with 2 beds and 2 baths. It also has two barns with pens and a fenced area to run a few horses. On the east side of the house, there is a breezeway connecting to a shop, perfect for storing hunting equipment, etc. The power for the house and shops is run off solar and geothermal, making your utility payment very low. The hunting on this ranch is truly excellent, with the option to hunt world-class whitetails, turkeys, hogs, and even the possibility of elk. There are many areas where you can plant big and small food plots to attract those early and late-season whitetails. Additionally, there are many good areas to hang stands on travel corridors, such as Middle Creek, to catch those mature bucks cruising during those crisp November mornings. The turkey hunting on the ranch is excellent, with great areas for birds to strut and great roost trees. Hogs are also on the ranch, so there are already some pens set up with feeders to keep them out! There have also been elk sightings on the ranch! The Justamere Ranch comes with all blinds and feeders throughout the ranch. The ranch also features 3 ponds, one of which is fairly new and is 7 +/- acres! Middle Creek runs through the property and offers excellent bass and catfishing! Don't miss out on owning this premier hunting ranch in Hughes County. Located just 10 +/- mins from Dustin, 30 +/- mins from Henryetta, and 40 +/- mins from McAlester. All showings are by appointment only.
MlsNumber: --
ListingId: 11284669


Listing Provided By: Arrowhead Land Company, original listing
Phone: (833) USE-AHLC
Office Phone: (833) 873-2452
Agent Name: William Bellis, Jr.
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