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

4157 W Roadrunner
Hulbert, OK 74441
Angela Tinsley with Property Solutions Real Estate, original listing - (918) 457-4100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: 6
Baths: Full: 5, ½: 1
Status: Active
SqFt: 3252 Square Feet
Agency: Property Solutions Real Estate
Agency Phone: (918) 457-4100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1997
Notes: How about that view! This posh lakeside retreat, just steps from the shimmering waters of Fort Gibson Lake, offers a front-row seat to breathtaking, year-round lake views. Designed for ultimate relaxation and recreation, this home features spacious decks and patios perfect for both entertaining and unwinding.<br /> Ready to make a splash? The dock setup includes two boat slips and 4 jet ski lifts for your watercraft and jet ski landings for quick access to water activities. With ample space for all your water toys, the dock offers the perfect spot to enjoy a day on the lake. The home is conveniently located just steps from the water, with easy access to your luxurious boat or a set of jet skis.<br /> The landscaped yard offers a great space for outdoor gatherings, complete with a firepit for roasting marshmallows or hot dogs after a day on the water. Whether you're seeking a peaceful retreat or a touch of adventure, this home and its dock offer everything you need.<br /> Inside, the expansive living room features soaring ceilings and large windows that flood the space with natural light, all while offering stunning lake views. The open-concept kitchen is equipped with updated appliances, ample counter space, and a large central island—ideal for cooking and gathering. The upstairs loft provides privacy as a primary suite with an en suite bath.<br /> The lower level includes sleeping quarters, a cozy living room with a kitchenette, a gas log fireplace, and a stone-covered patio for sheltered outdoor enjoyment.<br /> Don’t forget the guest home! Recently renovated, this three-bedroom, one-bathroom retreat features a modern kitchen with stainless-steel appliances, custom cabinetry, and granite countertops, perfect for guests or family.<br /> With a large three-car garage, ample parking, and easy access to the water, this property is the ultimate lakefront retreat. Every detail has been carefully crafted to provide the perfect blend of comfort, convenience, and lakeside luxury.
MlsNumber: --
ListingId: 2504572


Listing Provided By: Property Solutions Real Estate, original listing
Phone: (918) 457-6601
Office Phone: (918) 457-4100
Agent Name: Angela Tinsley
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