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;

1115 Hudson Lake Road
Bartlesville, OK 74003

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $775,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3795
Agency: Berkshire Hathaway HomeServices Anderson Propertie

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 2007
Notes: A slice of paradise only minutes from Bartlesville. This four bedroom, three bath home is nestled on 5.24 acres of peaceful bliss. Large master suite with French doors overlooking covered patio and gorgeous view of Butler Creek, trees, fields and abundant wildlife.<br /> <br /> Guest bedroom and bath downstairs with two additional bedrooms and third full bath upstairs. Eat-in kitchen, with custom cabinets and granite counters, which opens to family room with vaulted ceiling, wood burning fireplace with insert and large windows providing a view of covered patio and views below. Second living area or office off of stately entry. Bonus room upstairs can be a game room, play room or additional video room.<br /> <br /> Home includes oversized two car garage, large floored attic with easy access from upstairs hall and phenomenal Koi pond.<br /> <br /> The property includes a 50’ x 100’ metal building constructed of 26 gauge steel with 13 foot sidewalls rising to a 16 foot center. Built in 2012 it was constructed on a 6 inch concrete slab over sand base and has both iron rebar and wire mesh reinforcing in the slab. It was built by Lucas Metal Works in Ochelata, Oklahoma. The interior has a second level of wood construction of approximately 4,000 square feet. Combined with the lower level of 5,000 square feet for a total area of 9,000 square feet. There is a 10 by 12 foot tall overhead door with opener and an 8 by 9 foot overhead door as well as pedestrian doors. The building includes a full bath, a kitchenette area and an office and the building is heated and cooled. This is a first-class facility with a multitude of potential uses.
MlsNumber: 2408272


Listing Provided By: Berkshire Hathaway HomeServices Anderson Propertie, original listing
Name: Berkshire Hathaway HomeServices Anderson Propertie
Phone: (918) 337-0711
Office Name: McGraw, REALTORS
Office Phone: (918) 337-0711
Agent Name: Howard Thill
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