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;

3638 Edgewater
Enid, OK 73703
Sondra Hernandez with Cobblestone Realty Partners, original listing - (580) 297-9901

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,900
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: --
Agency: Cobblestone Realty Partners
Agency Phone: (580) 297-9901

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Nestled on the picturesque shores of Willow Lake in Enid, Oklahoma, this exquisite home offers over 3500 square feet of luxurious living space. Boasting a private boat dock that is well maintained and ready for you to embark on a fun little trip with your friends or family across the lake. Step inside to discover a world of elegance and refinement. A grand floating staircase greets you, while stone accents and custom paint finishes add a touch of sophistication throughout. The heart of the home is the stunning living room, featuring soaring ceilings and panoramic lake views. Entertain in style in the formal dining area, perfect for hosting memorable gatherings. The kitchen offers high-end appliances, custom cabinetry, a spacious island, and a walk-in pantry with the coolest round room at one end of the kitchen just begging for conversations and get-togethers. Retreat to the primary bedroom suite, complete with a private deck overlooking the lake, a walk-in closet to envy, and a spa-like ensuite bathroom. Additional amenities include a 3-car garage, an in-garage storm shelter for peace of mind, and a water well and sprinkler system for the lush landscaping. Enjoy outdoor living at its finest on the Trex decking, surrounded by beautiful landscaping. Inside, surround sound adds to the ambiance, creating the perfect setting for relaxation or entertainment. This is more than a home; it's a lifestyle—a rare opportunity to live like royalty in a custom-built masterpiece.
MlsNumber: --
ListingId: 20240697


Listing Provided By: Cobblestone Realty Partners, original listing
Phone: (580) 402-0424
Office Phone: (580) 297-9901
Agent Name: Sondra Hernandez
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