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

28469 S Big Hollow Road
Park Hill, OK 74451

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $660,000
Beds: 4
Baths: 3
Status: Pending
SqFt: 2667
Agency: Century 21 Wright Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 2023
Notes: Welcome to your dream home nestled in the serene Lake Tenkiller area! This contemporary farm home boasts 4 bedrooms, 2.5 baths, and a spacious 4-car garage, perfect for all your vehicles and toys. Built with top-quality ICF construction featuring 8" exterior walls and soundproof interior walls, this home ensures tranquility and energy efficiency with remarkably low utilities.<br /> <br /> Step onto 1250 sq ft of covered porches, complete with a wood-burning exterior fireplace, ideal for cozy evenings and entertaining guests. The heart of this home, the kitchen, is a chef's delight with an oversized island, instant hot water dispenser, and top-of-the-line Craftmade Maple Cabinets with quiet close doors and full extending drawers.<br /> <br /> Prepare gourmet meals with ease using the 6-burner ZLine Range and exterior venting hood, while two wine coolers keep your beverages perfectly chilled. Quartz countertops gleam under the abundant natural light streaming through the 25' vaulted ceiling adorned with breathtaking wood beams.<br /> <br /> Every detail has been meticulously crafted for comfort and convenience, from the 8' doors throughout to the zoned HVAC units for customizable climate control. Quaker windows ensure energy efficiency, while a commercial-grade metal roof and gutters with leak guards offer peace of mind.<br /> <br /> Unwind by the Mendota Gas Log Fireplace with a gray stone surround in the spacious living room, or head to the detached 3-car garage with additional workshop space for your projects and hobbies.<br /> <br /> Situated on 2.10 acres, this home provides ample space for privacy and outdoor enjoyment, just minutes away from Lake Tenkiller, perfect for water enthusiasts. Don't miss your chance to own this exquisite retreat in one of Oklahoma's most sought-after areas. Schedule your showing today and make this contemporary farm home your own oasis by the lake!
MlsNumber: 2409235


Listing Provided By: Century 21 Wright Real Estate, original listing
Name: Century 21 Wright Real Estate
Phone: (918) 708-1256
Office Name: C21/Wright Real Estate
Office Phone: (918) 708-1256
Agent Name: Edna Kimble
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