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 = 2175 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 = 2175 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 = 2175 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;

4908 Hickory Hill
Sulphur, OK 73086
Liz Dilbeck with Pebbles Real Estate, original listing - (580) 369-3500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $389,000
Beds: 2
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1382 Square Feet
Agency: Pebbles Real Estate
Agency Phone: (580) 369-3500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1980
Notes: Escape to your own slice of paradise with this fully furnished, charming split-level cabin—perfect for a peaceful retreat or a highly desirable Airbnb property. Upstairs, you'll find two bright and spacious bedrooms, one bathroom with custom shower, a convenient laundry room, and a kitchen with amazing views that will take your breath away. Downstairs, a generous open space features a cozy half bedroom, a comfortable living room space, and a recreational area with a pool table and bunk bed—ideal for relaxation or entertaining guests.<br /> Nestled on 3.25 acres of private, picturesque land, the property also includes a large 30x40 shop, offering ample storage and workspace. Enjoy incredible mountain views from every angle, along with the serenity and seclusion of the Arbuckle Mountains. The cabin is only five minutes from the Arbuckle Lake boat launch and close to popular destinations like Turner Falls and the Arbuckle Wilderness.<br /> The outdoor living space is perfect for enjoying nature, featuring a spacious covered deck and porch, as well as a fire pit for cozy evenings under the stars. This fully furnished cabin comfortably sleeps nine, making it an ideal Airbnb investment or your own personal getaway spot.<br /> This is a rare opportunity to own a secluded, serene retreat with endless potential for adventure and relaxation. Contact today to schedule your tour!
MlsNumber: --
ListingId: 2505210


Listing Provided By: Pebbles Real Estate, original listing
Phone: (580) 618-1622
Office Phone: (580) 369-3500
Agent Name: Liz Dilbeck
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App