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','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 = 2173 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 = 2173 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;

19 Alamo Rd
Broken Bow, OK 74728
Shavone Whipple with HST & Co LLC, original listing - (870) 478-7653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,200,000
Beds: 8
Baths: Full: 4
Status: Active
SqFt: 3704 Square Feet
Agency: HST & Co LLC
Agency Phone: (870) 478-7653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Garage: Garage
Property Type: Residential-Cabin
Year Built: 1974
Notes: Discover an exceptional investment opportunity in the heart of Broken Bow, featuring three beautifully remodeled cabins nestled on 8.13 pristine acres. The centerpiece, "Casa Grande," offers six bedrooms and two bathrooms, accommodating up to 14 guests in comfort. This spacious retreat boasts an inviting open floor plan, a pool table for entertainment, and a relaxing hot tub for the perfect evening wind-down. Two additional intimate cabins, "The Hideout" and "La Casita," each feature one bedroom and one bathroom, complete with their own hot tubs and thoughtfully designed open floor plans. All three cabins come fully furnished, allowing for immediate rental potential. The property's true value lies in its future development potential, with recent approval for city water connection and re-platting for nine additional cabins. This expansion opportunity could significantly enhance the already successful income-generating operation. Located in a prime tourist destination, the property sits minutes away from popular attractions including Beavers Bend State Park, Broken Bow Lake, and the vibrant Hochatown area. Guests can easily access local restaurants, shopping, and entertainment options, making this an ideal vacation rental investment. The surrounding natural beauty of Oklahoma's countryside provides a peaceful backdrop while offering endless outdoor recreation opportunities. Whether you're seeking a turnkey rental business or planning to expand, this property combines current income potential with significant growth opportunities in one of Oklahoma's most sought-after vacation destinations.
MlsNumber: --
ListingId: 11436508


Listing Provided By: HST & Co LLC, original listing
Phone: (405) 375-4004
Office Phone: (870) 478-7653
Agent Name: Shavone Whipple
Disclaimer: Copyright © 2025 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