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

105 S 7th
Jet, OK 73749
McKenzie Schuermann with Rockin Double J United Country, original listing - (580) 747-6930

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,250,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: --
Agency: Rockin Double J United Country
Agency Phone: (580) 747-6930

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Discover Your Dream Equestrian Retreat! Welcome to the ultimate horse lover's paradise! Nestled on a sprawling 40.58 acres of picturesque land, this stunning 5,000 MOL barndominium offers an unparalleled lifestyle for equestrians and nature enthusiasts alike. With an expansive 100x250 indoor arena, with sprinkler system and a generous 12 RV capacity, this property is designed for both relaxation and recreation. This home also comes fully furnished! Property Highlights: •Indoor Arena: 100x200 feet of versatile space for training, riding, and hosting events. •Horse Facilities: Enjoy the luxury of 3 indoor horse stalls and 10 outdoor horse stalls, complete with an indoor wash-bay for grooming your majestic companions. •Accommodations: This exceptional home boasts 4 spacious bedrooms, including 2 private apartment-style suites for guests or family. With 4 full baths and 1 half bath, comfort and privacy are guaranteed for everyone. •Entertaining Spaces: The upstairs features a spectacular open game room/man cave, equipped with a bar and half bath, offering the perfect spot to unwind while overlooking the indoor arena. •Sustainable Living: Benefit from solar lighting throughout the barn and covered stall area, plus central heating powered by an electric tankless water heater for efficiency and comfort. •Outdoor Amenities: Enjoy the convenience of RV/Boat parking, Hay Barn, & The covered patio invites you to relax and soak in the beautiful views. Natural Wonders Await: Located within a short distance from Great Salt Plains Lake Wildlife Refuge, experience the beauty of nature with equestrian trails just 10 miles away. Whether you’re riding through scenic landscapes or exploring local wildlife, adventure is just around the corner. Perfectly Designed for You: Built in 2013, this custom-designed home features a robust steel exterior and a durable metal roof, ensuring longevity and low maintenance. The inviting wood-burning fireplace adds warmth to chilly evenings, while vinyl windows flood the space with natural light. This is more than just a home; it’s a lifestyle. Whether you’re an experienced equestrian or simply seeking a tranquil retreat, this property has it all. Don't miss your chance to own this unique equestrian paradise!
MlsNumber: --
ListingId: 20241786


Listing Provided By: Rockin Double J United Country, original listing
Phone: (580) 747-2824
Office Phone: (580) 747-6930
Agent Name: McKenzie Schuermann
Disclaimer: Copyright © 2024 Northwest Oklahoma Association of REALTORS®. 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