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

9901 Abby Lane
Yukon, OK 73099
Leesa Williams with Keller Williams-Yukon, original listing - (405) 354-4888

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $844,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4203 Square Feet
Agency: Keller Williams-Yukon
Agency Phone: (405) 354-4888

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2013
Notes: STUNNING HOME ON 5 ACRES with a 42x40 FOAM INSULATED SHOP! This sprawling home has many fine touches with over 4000 square feet in a single-story home, 5 BEAUTIFUL ACRES with Rolling hills, and a LARGE SHOP. The curb appeal of this home is just lovely with it's tall entry way, circle drive and lovely landscaping. As soon as you enter, you are greeted by a large dining room, separated by the built in buffet and 19 FT BAR TOP which seats 7 around the HUGE KITCHEN. This Kitchen is a chef's dream with its 5 burner gas stove, 2 full size double ovens, built in spice shelves in the refrigerator surround, granite sink, large center island with raw edge granite and functional cabinetry surround, there is no lack of cabinet or counter space in this kitchen! Off the living room is 1 of the 2 Master Suites the home has to offer, with a great walk-in shower, walk-in closet with raw edge granite as well. There is also a HUGE BONUS SPACE to this side of the home. This is a huge space with 2 large rooms. The first bonus space has a built-in kitchenette/bar area and direct outdoor access, giving it so much potential. The SECOND BONUS space is connected and is currently used as a movie theater with large screen. The large office sets at the front of the home with built-in desk and cabinets. The main Master suite is located to the back of the dining room and it is HUGE with a large beautiful bathroom with great walk-in shower and a large closet with seasonal racks. The other 2 secondary rooms are a great size, both with huge closets and they share a large bathroom! The home has a sun room off the back. It is a large covered patio with added retractable screens and beautiful wood burning fireplace. DONT FORGET THE STORM SHELTER AND GENERATOR and REVERSE OSMOSIS FOR REFRIGERATOR, dishwasher and kitchen sinks. HEAT AND AIR WAS REPLACED LAST YEAR. BUYER TO VERIFY THE SIZE OF THE SHOP BC it has been added on.
MlsNumber: --
ListingId: 1137417


Listing Provided By: Keller Williams-Yukon, original listing
Phone: (405) 354-4888
Office Phone: (405) 354-4888
Agent Name: Leesa Williams
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.


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 = 2134 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 Craig Bass
Craig Bass
ASCIIChamberlain Realty LLC
Call Today!: (405) 334-8482

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App