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

16928 State Highway 33
Kingfisher, OK 73750

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,150,000
Beds: 4
Baths: 5
Status: Active
SqFt: --
Agency: Adams Family Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 2015
Notes: Wow, hard to find acreage just outside city limits on Hwy 33, 1/2 mile from the golf course, city indoor heated swimming pool, kids park & less that 10 minutes to grocery store, hospital, post office, movie theater, schools and banks. Come and take possession of the beautiful 4 oversized bedroom home, where you can sit outside on the balcony and enjoy the view, especially when baby deer are in your backyard. Built in 2015/16, this home has granite throughout, tile on the first floor including the bathroom walls. Stainless steel, built in oven, microwave, dishwasher, Induction cook top (steel pots and pans only). Good size living room with a fireplace and big windows that provide plenty of light; the master bedroom is big enough to accommodate a sitting area if you wish. The bathroom has a whirlpool where you can relax after a long day at work, (don't forget you have 10 acres that will keep you entertained) and the closet is every women's dream, you will love it. There are two other bedrooms that shared a bathroom on the other side of the house. Upstairs there is another living room, one bedroom with a full bathroom and also a bonus/office/study room where it's nice and quiet or you can just walk out on the balcony and relax. This home has 2 HVAC units that are divided into 4 different zones, so it will help keep the cost of energy down and let me mention that the house has spray foam 100% of the structure (all outside walls and roof). The tankless water heaters run on propane, and there are two of those, one for the master bathroom and one for the rest of the house, you will not run out of hot water. And for a day with the family, there is the patio where you can build your dream outdoor kitchen, or use a grill while everybody enjoys the pool, or play in the yard and you do not have to worry about going inside the house to use the bathroom, there is a bathroom outside and even an outdoor shower. You will be very happy with this beautiful set up..come and enjoy it.
MlsNumber: 1095885


Listing Provided By: Adams Family Real Estate, original listing
Name: Adams Family Real Estate
Phone: (405) 285-4600
Office Name: Adams Family Real Estate LLC
Office Phone: (405) 285-4600
Agent Name: Chip Adams
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