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

4001 Driftwood Dr
Enid, OK 73703
Patty Probasco with Coldwell Banker Realty III, LLC, original listing - (580) 233-8833

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $895,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: --
Agency: Coldwell Banker Realty III, LLC
Agency Phone: (580) 233-8833

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Beautifully renovated to perfection several years ago and has been continually maintained throughout the current ownership . This 5034 SF (mol) home sits on 1.07 acres of lush professional landscaping. As you enter through the covered walkway to the majestic wrought iron front door, you will be wowed with the beautiful architectural accents in each of the three rooms off of the gallery entry which showcases the formal dining, living area with cozy floor to ceiling stone fireplace and the piano room or office with open bookcases, but flanked with white painted columns to give a division to each room. As you continue on down the gallery you will enter the chef's kitchen with Wolf gas range, center island, eat up bar and the large dinette area overlooking, but divided by wrought iron is the large gathering room with 12' ceilings and 3 tall windows looking out onto the covered veranda areas. This room is great for entertaining guests with its awesome mahogany wet bar. Right off of the gathering room there is a walk-in reinforced concrete block safe room. There are 2 guest bedrooms with their own private baths on one side of the home, plus a 4th bedroom and bath upstairs. The large utility room has lots of counter space and cabinets and there is a mud room as you enter in from the garage. The primary bedroom suite is on the opposite side of the home with sitting area and sumptuous bath and his/hers closets and his/her vanities. Cast iron soaking tub, coffee bar and heated tile flooring. There is also a connecting room to the primary suite which could be an office, exercise room, sewing or hobby room. The primary bedroom has a door out to the covered veranda area as well. Other features offered are 4 HVAC systems, irrigation system connected to water well, Marvin windows, solid wood doors throughout and crown moldings, plantation shutters, 5 ceiling solar tubes, wood beams and surround sound speakers in ceiling. There is also a 4th car garage or workshop area on the north side of the home. The exterior of the home boasts a large corner lot, plus a 3 car garage with custom flooring, landscape lighting, Generac gas powered generator, wrought iron fencing, large covered veranda with tile flooring, outdoor kitchen with plumbed gas cooker. This home has additional features you will see when you schedule your own private tour. Spectacular location on large corner lot across from Oakwood Golf and Country Club for your golfing convenience. Hurry!!! you will not want to miss this opportunity!!!
MlsNumber: --
ListingId: 20241527


Listing Provided By: Coldwell Banker Realty III, LLC, original listing
Phone: (580) 548-4646
Office Phone: (580) 233-8833
Agent Name: Patty Probasco
Disclaimer: Copyright © 2024 Northwest Oklahoma Association of REALTORS®. 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