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

S 4760 Road
Westville, OK 74965

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,118,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: C21/Wright Real Estate
Agency Phone: (918) 708-1256

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 130 acre(s)
Property Type: Land-Other
Year Built: --
Notes: LIVE WATER! Explore Your Oasis in the Ozarks!<br /> <br /> Discover the epitome of rural bliss on this sprawling 130-acre gem nestled in the picturesque foothills of the Ozarks. Boasting over 85% lush pasture, this haven is perfect for cattle, livestock, or your dream homestead. Fenced and cross-fenced with 6-line wire, enveloped by bermuda grass and studded with majestic walnut trees, this property is a pastoral paradise.<br /> <br /> Water is abundant with three serene ponds and a live spring-fed creek that meanders gracefully through the land. A solar-generated well ensures water access at multiple locations for your livestock, and a gravity flow system adds to the eco-friendly allure. Modern amenities like rural water, natural gas, and fiber optics are conveniently available, making this a seamless blend of rustic charm and modern convenience.<br /> <br /> This haven is a canvas for your dreams, offering numerous stunning building spots with breathtaking vistas. Revel in the freedom, as there are no restrictions – design and develop to your heart's content. Enjoy the creek year-round for crawdad hunting, rock skipping, or simply unwinding to the soothing babble of the water over the large flat rock bottom.<br /> <br /> For the avid adventurer, the property offers more than meets the eye. Explore natural caves and delve into the rich history of the area, including an intriguing "powder hole." Hiking and discovering hidden, historically significant sites will be a delightful part of your everyday life.<br /> <br /> Wildlife thrives on this expanse, with deer gracing the landscape abundantly. Immerse yourself in nature and relish the tranquil beauty that surrounds you. This idyllic acreage beckons – whether you seek a rural retreat, an agricultural enterprise, or a unique development opportunity, this is your chance to embrace the Ozarks lifestyle.<br /> <br /> Claim your slice of paradise today and let your dreams take root in this untouched, natural wonderland. Don't miss this rare chance to own a piece of the Ozarks
MlsNumber: --
ListingId: 2419081


Listing Provided By: C21/Wright Real Estate, original listing
Phone: (918) 708-1256
Office Phone: (918) 708-1256
Agent Name: Edna Kimble
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