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

18602 980 Road
Cheyenne, OK 73628
Mark Haney with Moxy Realty, original listing - (580) 243-2929

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $950,000
Beds: 6
Baths: Full: 2, ½: 1
Status: Active
SqFt: 8975 Square Feet
Agency: Moxy Realty
Agency Phone: (580) 243-2929

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 48 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2011
Notes: This stunning luxury ranch home offers a blend of elegance, craftsmanship, and outdoor living. Set on nearly 49 acres of picturesque land, this home boasts exceptional custom details that elevate it to a class of its own. Upon entering, you are greeted by warm travertine tile and rich wood flooring that flows seamlessly throughout the open-concept living spaces. Hand-carved wood elements from New Mexico add character and charm, while stained glass features offer a timeless touch. The living room centers around a double-sided rock gas fireplace with a wooden mantel and is also visible from the adjacent home office which features custom-built shelving. The kitchen is a chef’s dream, featuring handmade copper sinks, treasure cove granite countertops, and top-of-the-line appliances, including dual dishwashers, double ovens, a 5-burner electric range, microwave, food warmer drawer, and dedicated space for both an ice maker and a refrigerator/freezer. A large pantry with utility hookups offers ample storage. Retreat to the master suite, where indulgence meets tranquility. The master bath features a hand-hammered copper clawfoot bathtub and a master shower with 4 shower heads and a pebble stone floor for a spa-like experience. The large master walk-in closet offers lots of storage, including washer and dryer hookups for ultimate convenience. Step outside onto one of two walkout patios to enjoy the serene views of the surrounding acreage, ideal for relaxing or entertaining. The downstairs area presents incredible potential for customization, with space for up to 5 bedrooms, 3 living areas, a bathroom, and a large safe room. There is also outside access, making it ideal for multi-generational living or guest quarters. The seller had plans to create a workout room, arts and crafts room, and a media/theatre room, offering endless possibilities to personalize the space to your needs. This exceptional property provides the perfect balance of luxurious living and private land.
MlsNumber: --
ListingId: 1149982


Listing Provided By: Moxy Realty, original listing
Phone: (580) 243-2929
Office Phone: (580) 243-2929
Agent Name: Mark Haney
Disclaimer: Copyright © 2025 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