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;

65311 Hwy 59
Watts, OK 74964
Jacob Barnes with Keller Williams Advantage, original listing - (918) 712-2252

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,499,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2621 Square Feet
Agency: Keller Williams Advantage
Agency Phone: (918) 712-2252

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 127 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2009
Notes: Welcome to your dream retreat! This stunning property offers a perfect blend of comfort, luxury, and the serenity of nature. Accompanied by 127.5 acres, the main home is a masterpiece of design with its custom brick exterior and thoughtful details throughout. Upon entering, you'll be greeted by an open floor plan that seamlessly connects the living, dining, and kitchen areas. The interior of the home features hardwood and tile floors, creating a warm and inviting atmosphere. Crown molding adds a touch of elegance, while hickory cabinets in the kitchen provide style, durability, and functionality.<br /> <br /> The three bedrooms are generously sized, with large closets featuring built-in shelving for optimal organization. Imagine waking up to the tranquil views outside your window and enjoying the natural beauty that surrounds you.<br /> <br /> Step outside onto the expansive deck overlooking the deep swimming holes and crystal-clear waters of Ballard Creek which holds exception smallmouth and largemouth bass fishing. The deck provides the perfect space for entertaining or simply unwinding with a good book or warm cup of coffee.<br /> <br /> The charm doesn't stop at the main residence – this property also features two additional homes, offering endless possibilities for guests or rental income.<br /> <br /> For the outdoor enthusiast, the land is diverse, offering fenced and cross-fenced pastures for grazing and an abundance of timber, creating an ideal environment for hunting and exploration.<br /> <br /> The functional outbuildings add to the allure, including a 60x60 red iron equipment barn, a 30x60 workshop, and a 40x48 horse stable designed for 7 stalls along with a feed and tack room, and a covered 25x90 Storage Building. <br /> <br /> This property is a rare gem, combining comfort, functionality, and the natural beauty of the great outdoors.<br /> <br /> Sellers offering $5,000 credit at closing for Rate Buy Down. <br /> <br /> Home is located within the FEMA mapped 100 year floodplain. Sellers have had no issues with flooding.
MlsNumber: --
ListingId: 2438492


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