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 = 2164 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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 = 2164 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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 = 2164 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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;

12246 Ne 120th Road
Red Oak, OK 74563
Dakota Fleming with C21/Wright Real Estate, original listing - (918) 708-1256

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,900
Beds: 7
Baths: Full: 6
Status: Active
SqFt: 5344 Square Feet
Agency: C21/Wright Real Estate
Agency Phone: (918) 708-1256

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: Seated atop a great hill, overlooking the land below & the majestic San Bois Mountains, lies the incredible Manor at Parks Ranch. As you arrive, the front gates will welcome you to one of the most breathtaking views on earth. You won't be able to imagine it, until you've seen it for yourself. As you come slowly down the driveway, the ever-widening view will enlarge the immensity of your astonishment by the second. Enter through the front doors, & walk into the marvelous Dining & Living Room, easily the largest space in the house. You will be greeted by the exquisite taste of modern, country living. A few steps further, & the incredible mountain view will capture all of your attention, making you ponder where in the world you would ever see a view quite like this. Now entering into the Breakfast Corner, Kitchen, & Family Room you instantly feel the deep, warm sensations of a happy family life. Called further into the home, you will find the Pantry Room, the Dog Wash, the Theater, the Children's Room, the comfortable Bedrooms, the luxurious Bathrooms... until finally you happen upon the Master Bedroom. As your eyes widen with the sheer enormity, you may find yourself feeling a bit overwhelmed with it all. But, turning into the Master Bathroom, the stress starts to melt away. A rose petal bath is drawn in the copper bathtub, a fresh robe & pair of slippers laid upon the Master Closet dresser await you, a glass of champagne & plate of exquisite food are prepared on the bath-side counter... all take the troubles of life away, as you blissfully remember... you are home.
MlsNumber: --
ListingId: 2439569


Listing Provided By: C21/Wright Real Estate, original listing
Phone: (918) 708-1256
Office Phone: (918) 708-1256
Agent Name: Dakota Fleming
Disclaimer: Copyright © 2024 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