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

26549 N 3980 Way
Ochelata, OK 74051
Kari Halferty with Keller Williams Realty, original listing - (918) 766-0001

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,300,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 5433 Square Feet
Agency: Keller Williams Realty
Agency Phone: (918) 766-0001

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 173 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Secluded paradise on 173 acres. 5 ponds including approximate 4 acre pond behind the home complete with boat dock & swim deck. Great room with wood burning fireplace, built in book cases, vaulted ceilings and a stunning view of the pond and land. Open kitchen with hickory cabinets with under & over cabinet lighting. Granite countertops, butcher block, pantry with pull out drawers. Top of the line appliances including custom paneled refrigerator. Formal and informal dining areas. Full bar with wine fridge, ice maker, mini fridge, wine storage & sink. Australian cypress wood floors and Anderson windows throughout. 4 bedrooms, each with private full bath. Primary bedroom on main level offers a walk in closet with center island. Luxury primary bath with Jacuzzi tub, separate shower with steam system and double vanity. Dedicated office with French doors & built ins and adjacent half bath. Mother in law suite on main level. Game room upstairs with wall of storage. Mud room plus separate utility room each with sink and storage. Walk out basement with storm shelter. Security system plus separate security cameras. Sprinkler system that pulls water from the pond with new motor to care for the extensive landscaping with beautiful stone accents. Innovative bug spray system around the exterior of home with 83 sprayers. Covered composite deck with vaulted ceiling & Alfresco grill & sink. 42 X 80 Morton building with apartment, workshop & loft storage. Apartment is 777 sqft per appraiser with large living area, kitchen with breakfast bar seating and full bath. HVAC plus separate septic. Producing vineyard with water and full fencing. Located just 10 minutes south of Bartlesville & 30 minutes north of Tulsa.
MlsNumber: --
ListingId: 2420766


Listing Provided By: Keller Williams Realty, original listing
Phone: (918) 914-0235
Office Phone: (918) 766-0001
Agent Name: Kari Halferty
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