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 = 2197 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 = 2197 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 = 2197 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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;

405 E Decatur Street
Broken Arrow, OK 74011
Taylor Bay with Chinowth & Cohen, original listing - (918) 943-3009

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,180,000
Beds: 5
Baths: Full: 6, ½: 2
Status: Active
SqFt: 7544 Square Feet
Agency: Chinowth & Cohen
Agency Phone: (918) 943-3009

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2010
Notes: This stunning custom estate, located in a desirable gated neighborhood, is brimming w/ amenities, all perfectly positioned within a skillfully conceptualized floorplan! As you enter through the double wrought iron doors, you are immediately taken by the soaring ceilings, grand staircase, intricate flooring & custom railings! Ideal for seamless entertaining, the expansive living spaces, stunning formal dining room w/ wet bar, theater room & colossal game room provide endless options. Thoughtfully designed w/ functionality & privacy in mind, the 5 spacious bedrooms all boast en-suite baths & walk in closets. The primary suite is a true retreat w/ a sitting area and spa-like en-suite featuring a walk-in shower w/ rain shower head & body jets & his and hers closets w/ built-in cabinetry, all leading to the downstairs laundry room. The 2nd primary suite is perfect for comfortably hosting guests, w/ large walk-in closet & dual sinks. The kitchen is a chef’s dream, w/ Thermador appliances, 4 ovens, built-in fridge/freezer, pot filler, expansive island, ice maker hookup & 2 sinks! The amazing mudroom provides direct access from the pool to a full bath, 5 cubbies for storage & convenience, a desk for the home computer & mail & a wonderful walk-in pantry. The handsome executive office has built-ins & a walk-in closet, making work from home a pleasure. The sparkling salt-water pool & wood-burning outdoor fireplace will be the setting for many amazing summer days & memorable evenings. For enthusiasts or collectors, the 7-car garage is amazing, w/epoxy floors, storm shelter & and dedicated space for a workbench, storage or the golf cart & toys. A full staircase above the detached 3 car garage leads to an unfinished space, which could be finished to provide another home office, mancave, studio, the possibilities are endless! Other amenities are a home generator, 2 staircases, motorized chandelier lifts for cleaning, laundry up&down, powder rooms up&down & tankless water heaters.
MlsNumber: --
ListingId: 2501146


Listing Provided By: Chinowth & Cohen, original listing
Phone: (918) 770-5721
Office Phone: (918) 943-3009
Agent Name: Taylor Bay
Disclaimer: Copyright © 2025 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.


Local Real Estate Expert

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 = 2197 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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;
Real Estate Expert Photo for Kipp Chandler
Kipp Chandler
ASCIIThe Brokerage Tulsa
Call Today!: (918) 616-5477

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App