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;

26755 N 3980 Way
Ochelata, OK 74051
Amy Lindsey with Hayden Outdoors Real Estate, original listing - (970) 674-1990

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,650,000
Beds: 3
Baths: Full: 3, ½: 2
Status: Active
SqFt: 2697 Square Feet
Agency: Hayden Outdoors Real Estate
Agency Phone: (970) 674-1990

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 73 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2015
Notes: Enjoy remarkable sunsets overlooking the 5+ acre clear pond. This 2015 custom built home by Dan Hough, offers beautiful 360 degree views and is hidden from view of the surrounding neighbors. Perched atop the hill at the end of a winding driveway, the pond wraps around 3 sides of the home, providing a secluded feel, while being close to the convenience of Bartlesville and Tulsa. The home lies at the end of a 3/4 mile private driveway off of 2700 Rd. The entrance is gated and shared by the three adjoining property owners. This impressive home was designed with large windows for natural lighting and to showcase the views from any room. The 2,697 square foot home features wood and stone siding to seamlessly blend with the surrounding 73 acres. Upon entering the home you are greeted by floor-to-ceiling windows and a beautiful rock fireplace as a focal point. The open concept kitchen, dining and living room is great for entertaining. The interior of the home combines LED lighting, black granite countertops, stainless steel appliances and hickory cabinets with dark hardwood and light stone flooring for a modern rustic feel. The kitchen has a Wolf 6 burner gas stove, oven, wine fridge, icemaker and Electrolux refrigerator. The wood burning fireplace has a gas start for those cold winter nights. The primary suite is conveniently located on the main level and features a gas fireplace and sliding doors to the patio. The two remaining bedrooms are located on the second floor, each with a full bath. One bedroom upstairs has a patio overlooking the pool and pond. Enjoy outdoor entertainment and fun with the saltwater, gunite heated pool. Additional features include Low E Anderson windows, solid knotty alder doors, an outside half bath, above-ground safe room in the 3-car climate controlled garage, whole house air purification system, and Generac generator. There are two AC units and a 1,000 gallon buried propane tank. This immaculate custom home build has been crafted with attention to detail and functionality making it a legacy home you can be proud to call yours. The pond is great for paddleboarding and fishing for large mouth bass or ziplining for the more adventurous. The acreage has been managed for deer and quail and serves as a natural corridor for deer to the Caney River. The pond serves as a winter layover for migrating waterfowl. The landscaping includes mature trees and shrubs and the center island bed is planted with wildflowers for pollinators and butterflies.   The home and pond are fenced. There is no fence on the east or south boundary. There is a small pipe corral with automatic waterer with an additional water trough and water hydrant located near the corrals. ** Additional Acreage Available ** This property is located in a highly desirable area between Bartlesville and Tulsa and close to several lakes. 20 minutes to Downtown Bartlesville 35 minutes to Downtown Tulsa 35 minutes to Tulsa Airport 40 minutes to Oologah Lake 40 minutes to Skiatook Lake 1 hour to Keystone Lake  
MlsNumber: --
ListingId: 11292554


Listing Provided By: Hayden Outdoors Real Estate, original listing
Phone: (970) 674-1990
Office Phone: (970) 674-1990
Agent Name: Amy Lindsey
Disclaimer: Copyright © 2024 My State MLS. 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