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

9364 Ew 26 Road
Nowata, OK 74048

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,000
Beds: 3
Baths: 4
Status: Active
SqFt: 3640
Agency: Shelley Koster Real Estate Inc., dba Keller Willia

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 35 acre(s)
Property Type: Residential
Year Built: 2022
Notes: Nestled on a sprawling 35 acres, this modern country home is a harmonious blend of luxury and natural beauty. Approaching the property, the long driveway leads to the grand entrance of the residence, where a combination of brick and wood accents seamlessly integrates the home into its picturesque surroundings. Upon entering the home, you are greeted by an open-concept living space flooded with natural light. The interior design features clean lines, high ceilings, wood beams, and a neutral color palette, creating an atmosphere of sophistication and serenity. The gourmet kitchen is a culinary enthusiast's dream. The large island, gleaming stainless steel appliances, and butler's pantry make entertaining effortless. The kitchen seamlessly flows into the living area, where a floor to ceiling stone fireplace anchors the space. The home also features an office with tons of storage, a mudroom with cabinetry and large upstairs bonus room! The master suite is a sanctuary of comfort and elegance, boasting a spacious bedroom with fireplace, a spa-like ensuite bathroom, and a walk-in closet which is also an indoor safe room. Additional bedrooms with ensuite bathrooms provide ample space for family and guests. The expansive outdoor living space is designed for relaxation and entertainment. A covered patio with surround sound overlooks the land creating the perfect setting for gatherings or quiet moments. The 40'x60' shop has electric (separate from home) and roughed in plumbing. One pond on the property is full and the other pond is being bermed.
MlsNumber: 2341780


Listing Provided By: Shelley Koster Real Estate Inc., dba Keller Willia, original listing
Name: Shelley Koster Real Estate Inc., dba Keller Willia
Phone: (918) 766-0001
Office Name: Keller Williams Realty
Office Phone: (918) 766-0001
Agent Name: Shelley Koster
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