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

263 High Peak Trail
Broken Bow, OK 74728

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,251,250
Beds: 5
Baths: 6
Status: Active
SqFt: --
Agency: Leadership Real Estate Investments, Inc dba Keller

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2013
Notes: Discover the epitome of rustic luxury at Yellowstone Lodge – a sprawling 5-bedroom retreat perched atop a hill, inviting you into a world of comfort and natural elegance. The majestic Yellow Stone Lodge, accessed by an asphalt driveway, beckons with its oversized bunk room, aptly named Yellowstone's Bunkhouse. 18 guests can comfortably slumber in this fabulous lodge. With 5.5 bathrooms and hardwood floors throughout, this haven seamlessly combines charm and convenience. Embrace the warmth of the high vaulted ceilings and the allure of rustic furnishings, creating an ambiance that pays homage to the Yellowstone theme, from cowhides to leather. Enjoy the wood burning fireplace in the living area on those chilly nights. The kitchen, adorned with granite countertops, a spacious island, stainless steel appliances, and a gas stove caters to culinary enthusiasts. Engage in friendly competition in the game room, featuring a pool table and shuffleboard, or unwind on the expansive back deck with a gazebo area. Beyond the cabin's walls, the allure of Broken Bow Lake and Hochatown's attractions awaits, making this an ideal location for those seeking a perfect blend of tranquility and adventure. From the Treefrog play scape to horseshoes and a firepit that accommodates many, Yellow Stone Lodge offers a myriad of outdoor delights. This is not just a cabin; it's a sanctuary where memories are woven surrounded by nature's embrace. Yellowstone Lodge is located in Timber Creek Trails. Call for a tour now!
MlsNumber: 1095807


Listing Provided By: Leadership Real Estate Investments, Inc dba Keller, original listing
Name: Leadership Real Estate Investments, Inc dba Keller
Phone: (405) 748-8500
Office Name: Keller-Williams Platinum B.B.
Office Phone: (580) 494-3466
Agent Name: Paula Beauchamp
Disclaimer: Copyright © 2024 MLSOK, 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