Title Page Background
DEBUG FN args: Array ( [0] => 2166 [1] => [2] => [3] => agent ) BEFORE: Site: 2166 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2166 Igate: njhud LocID: 2166 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2166 AND i.igate IN ('okhud','usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2166 [1] => [2] => [3] => lender ) BEFORE: Site: 2166 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2166 Igate: njhud LocID: 2166 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2166 AND i.igate IN ('okhud','usahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2166 [1] => [2] => [3] => other ) BEFORE: Site: 2166 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2166 Igate: njhud LocID: 2166 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2166 AND i.igate IN ('okhud','usahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

347192 E Highway 62 Highway
Meeker, OK 74855

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $595,000
Beds: 4
Baths:
Status: Active
SqFt: --
Agency: Keller Williams of Shawnee

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Introducing a luxurious country estate that epitomizes the perfect blend of elegance and comfort. Nestled on a sprawling 10-acres, this magnificent 4-bedroom, 3.5-bathroom residence offers an unparalleled living experience. With 4,326 square feet of living space, this property exudes sophistication at every turn. Gleaming hardwood floors flow seamlessly throughout, lending warmth and charm to the space. The heart of this home is undoubtedly the gourmet kitchen, which boasts stunning Corian countertops that provide both beauty and functionality. It's the perfect place to prepare gourmet meals for family and friends. The living areas are thoughtfully designed, offering two distinct spaces for relaxation and entertainment. Whether you prefer cozying up by the fireplace with a good book or hosting gatherings with loved ones, these areas cater to all your needs A dedicated office space provides a quiet retreat for work or study. The bedrooms are spacious, each featuring huge closets. The master suite is a sanctuary in itself, with an ensuite bathroom that includes a spa-like bathtub, a separate shower, and dual vanities. The outdoor amenities are just as impressive as the interior. Step outside onto the expansive patio and take in the breathtaking views of the surrounding countryside. A picturesque pond graces the property, offering a serene spot for reflection. For added safety and peace of mind, a storm shelter is discreetly located on the grounds. In conclusion, this extraordinary property is a rare find that seamlessly combines style, function, and the tranquility of country living. With its 4 bedrooms, 3.5 baths, 2 living areas, office, hardwood floors, corian countertopsd & a stunning view, it offers a lifestyle of unmatched quality and beauty. Don't miss the opportunity to make this dream home your own. Experience the epitome of luxury living in this spectacular residence, where every element is designed to delight and inspire. Guard Dogs-DO NOT ENTER PROPERTY!
MlsNumber: --


Listing Provided By: Keller Williams of Shawnee, original listing
Phone: (405) 273-1900
Office Phone: (405) 273-1900
Agent Name: Ann Bain
Disclaimer: Copyright © 2024 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