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;

5095 S Highway 77 Highway
Davis, OK 73030
Lani Topetchy with Pebbles Real Estate, original listing - (580) 369-3500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: --
Baths: Full: 4
Status: Active
SqFt: 4600 Square Feet
Agency: Pebbles Real Estate
Agency Phone: (580) 369-3500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1985
Notes: Sitting on 11 Acres +/- this Home away from Home Lodge is approximately 4600 sq. ft. with an open layout and a beautiful rock fireplace located in the corner of the living area. The kitchen is Commercial Grade with a spacious prep area and storage space. Just outside the back door is a staircase leading to Private Living Quarters w/Kitchen and a Studio Style set up. The Lodge has a 15x60 spacious covered porch for family get togethers and parties. The roomy porch as a a Native Rock Fireplace and views of your inground swimming pool! Property has a creek, bridge, and 11 Ac. +/-. This would make the perfect home away from home for your whole family to use as a great getaway or as a rental for Family Reunions or a perfect Wedding Venue. For those seeking a unique escape, the lodge features two enchanting treehouse cabins. These elevated retreats offer breathtaking views of the tranquil atmosphere of the Turner Falls area. Each cabin is thoughtfully designed to blend seamlessly with nature, allowing guests to experience the outdoors without sacrificing to much comfort. You will find this property centrally located being only 130 miles from Dallas and 75 miles to OKC. Enjoy the unique area of Turner Falls, the historic Chickasaw National Park, or the Lake of the Arbuckles. Come to Southern Oklahoma and experience our Hometown Hospitality and our area will soon be your NEW HAPPY PLACE!
MlsNumber: --
ListingId: 2507090


Listing Provided By: Pebbles Real Estate, original listing
Phone: (580) 465-8170
Office Phone: (580) 369-3500
Agent Name: Lani Topetchy
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