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

3202 Castle Court
Durant, OK 74701
Chase Crain with Epique Realty, original listing - (888) 560-3964

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,000,000
Beds: 5
Baths: Full: 5, ½: 3
Status: Active
SqFt: 8893 Square Feet
Agency: Epique Realty
Agency Phone: (888) 893-3537

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2011
Notes: This lovely 5-bedroom, 8-bathroom home inspired by the Chateaux of Northern France begins to impress as you step in from the balustraded travertine terrace. Oak hand scraped hardwoods gleam in the living areas and kitchen, beneath a rare combination of fashionable and natural lighting. Ceiling styles that draw the eye's attention include vaulted, coved, beamed and bricked. The crackling warmth of 3 gas fireplaces can be found in the living room, morning room and study. Not a detail left out from veneer walls in the formal dining, butler's pantry, one of a kind custom trim, arched door frames, 25 ft ceilings with custom drapery and much much more! The convivial gourmet kitchen features granite counters and premium appliances (Wolf and Subzero). A classic island configuration maximizes workspace and flexibility. After you tour this one, your list of required kitchen features for any home might include these double ovens. The entire scene shines beneath stylish lighting. The expansive primary bedroom is conveniently located on the main-floor, offering the luxury of tranquility at the end of the day. In addition to the convenience of the private spa like bathroom, you will find not one but two walk-in closets to accommodate dual wardrobes for all seasons, with room left over for luggage and personal storage. A sitting area is a bonus of versatility. Enjoy family movie night in the huge media room with 110" screen and luxury theater seats! No reason to leave the house to get a workout in. You can get your cardio and weight training done in your home gym. The generous, well-cared-for yard provides plenty of opportunity for enjoyment. The back porch is open-air for maximum breeze flow with a vaulted ceiling, outdoor kitchen and fireplace. Make (or dodge!) a splash in the beautiful swimming pool, the social and sapphire centerpiece of the backyard. This lovely home is a special charmer in Camelot Forest Estates! (Listing Agent is related to sellers)
MlsNumber: --
ListingId: 2412901


Listing Provided By: Epique Realty, original listing
Phone: (888) 560-3964
Office Phone: (888) 560-3964
Agent Name: Chase Crain
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