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

105148 S 4500
Vian, OK 74962
Angela Thornton with Tenkiller Lake and Land, original listing - (918) 773-4070

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $706,500
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Tenkiller Lake and Land
Agency Phone: (918) 773-4070

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 157 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Calling all outdoor enthusiasts and nature lovers! This exceptional 157-acre (approximately) property is a true sportsman's paradise, offering the perfect blend of recreational opportunities and income potential. The land features three serene ponds and two meandering creeks, creating an ideal habitat for local wildlife and excellent hunting prospects.<br /> <br /> Currently equipped with deer blinds, feeders, and cameras, this property is ready for your next hunting adventure. A duck slew is under construction, promising even more sporting opportunities. The comfortable hunting cabin comes complete with a full kitchen and bathroom, powered by a reliable 600-foot well, providing all the essentials for your outdoor getaway.<br /> <br /> The property's location couldn't be better - it borders Interstate 40 with convenient access, while still maintaining its peaceful, natural setting. You're just minutes away from premier outdoor destinations including the Arkansas River, Lake Tenkiller, and Sequoyah Refuge.<br /> <br /> For the practical-minded investor, the land currently generates revenue from hay production, yielding 60-80 bales annually. The entire property is fully fenced, offering excellent security and property management.<br /> <br /> Located in the respected Vian School District, this property combines the best of rural living with convenient access to local amenities. Whether you're seeking a recreational retreat, an investment opportunity, or both, this versatile property delivers on all fronts. Don't miss the chance to own this slice of Oklahoma paradise where adventure and opportunity meet.
MlsNumber: --
ListingId: 2504898


Listing Provided By: Tenkiller Lake and Land, original listing
Phone: (918) 315-2486
Office Phone: (918) 773-4070
Agent Name: Angela Thornton
Disclaimer: Copyright © 2025 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