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;

2422 Blackstone Court
Bartlesville, OK 74006

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,050,000
Beds: 8
Baths: 7
Status: Active
SqFt: 6521
Agency: Berkshire Hathaway HomeServices Anderson Propertie

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2006
Notes: BACK ON THE MARKET with MASSIVE REDUCTION IN PRICE! This impressive home blends mid-century & contemporary design with modern functionality. It spans 3 levels, ~ 6500 SF, 8 BR & 6.5 baths. Entering the home, be dazzled by the formal dining room to your left w/coffered ceiling and 4 massive hand crafted wooden columns, then straight ahead to the formal LR with lofty ceiling & wall of windows allowing natural light to beam in. The view of the lake and private bridge to your own private island is stunning. There's also an oversized stately fire place in the LR flanked by built-in shelves and cabinets. Also on this floor is the PBR with a screened in balcony, bathroom with double sinks, his & her closets and whirlpool tub w/separate shower. A second BR/office is also on this main floor with it's own bathroom & walk-in closet. Also on this main floor is a state-of-the-art main kitchen & a separate sous chef kitchen which includes an oven, warming tray & microwave. Upstairs is replete with a mezzanine overlooking the formal LR w/lots of natural light making it perfect for use as an office or library, 3 BR each with a pullman bath & walk-in closets. The stair rail is hand crafted wood & very beautiful. The basement has a large living area w/fireplace. Also a full kitchen, 3 BRs all with pullman bath & walk-in closets. One of these BRs is in the back of the home and has windows on 2 sides. It's perfect for use as an office. The view of the lake is beautiful. This ~2 acre property has an expansive yard that gives way to a gently sloping lawn in back, 2 sprinklers, extensive boulder/rock work, and a bridge to your own private island. All of this in full view from the expansive deck on the back of the home. Quality is seen throughout this unique home as it was constructed by a builder for himself using detailed finishes with the highest quality materials. Truly a one-of-a-kind home. Hanging TVs remain with home. Agent related to seller.
MlsNumber: 2409208


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: Janat Jalili
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