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;

32289 S Cherokee Lane
Park Hill, OK 74451
Trish Ary with Keller Williams Advantage, original listing - (918) 712-2252

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $349,500
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2128 Square Feet
Agency: Keller Williams Advantage
Agency Phone: (918) 712-2252

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: BEAUTIFUL HOME AND SHOP ON 1 ACRE JUST ¼ MILE FROM LAKE TENKILLER AND ½ MILE FROM BARNACLE BILL’S MARINA! Embrace the luxury of lake life with this 3-bedroom, 3-bathroom, 2,128 square foot ranch-style home, perfectly situated on large 1-acre corner lot within walking distance of Lake Tenkiller! This property offers both convenience and charm, with a circular driveway, mature trees, decorative lighting, and exceptional curb appeal. Inside, the spacious living and dining area features vaulted ceilings, large double-hung windows, and a cozy gas log fireplace with a fan blower and glass doors. The kitchen is thoughtfully designed for both functionality and entertaining, offering an island, two eating bars, a pantry, breakfast nook, and abundant storage. The utility/mudroom adds practicality to the layout. The spacious master bedroom is a true retreat, featuring a walk-through closet with tons of built-ins and separate en-suite bathrooms on either side—shower, vanity, and toilet on one side, and soaking tub with scenic views, vanity, and toilet on the other. One of the guest bedrooms is equipped with a custom Murphy bed, built-in bookcases, and folding nightstands. Quality finishes, including granite countertops, Tuscan Brown Oak hardwood floors, LVP flooring in kitchen and bathrooms, and stainless appliances, provide durability and style throughout the home. Outdoor living space is designed to impress, with a covered patio, oversized party deck, a stacked stone outdoor wood-burning fireplace, and a Vita Spa hot tub—ideal for relaxing or entertaining. The detached 3-car garage/shop offers side entry, two electric overhead doors, a plumbed kitchenette/bathroom, and ample storage space. With its prime location and proximity to Lake Tenkiller, as well as easy access to highways such as HWY 82, HWY 62, HWY 51, and Muskogee Turnpike, this property is perfect for a permanent residence, vacation home, and/or investment property. Schedule a private showing today!
MlsNumber: --
ListingId: 2439949


Listing Provided By: Keller Williams Advantage, original listing
Phone: (918) 282-2524
Office Phone: (918) 712-2252
Agent Name: Trish Ary
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.


Local Real Estate Expert

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;
Real Estate Expert Photo for Kimm Kennon
Kimm Kennon
ASCIILakeland Real Estate
Call Today!: (918) 864-4922

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App