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

241 Chateau Bend
Ardmore, OK 73401
Tom Love with Keller Williams Realty Ardmore, original listing - (580) 319-7425

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,200,000
Beds: 4
Baths: Full: 3, ½: 2
Status: Active
SqFt: 4320 Square Feet
Agency: Keller Williams Realty Ardmore
Agency Phone: (580) 319-7425

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2011
Notes: This elegant European-style home is located in the Tuscan Vineyards rural, gated addition. The family room has a vaulted ceiling with beams and a large stone gas log fireplace. <br /> The bar area has a beverage cooler and wine storage. <br /> The kitchen has Knotty Alder European-style kitchen cabinets with soft-close drawers and pullouts, and new double convection ovens. It has a 48" vent hood, 42" 6-burner with a griddle gas cooktop, an undermount copper sink, a pantry, and a large kitchen island.<br /> The circular dining area has 6' wainscoting. <br /> The nearby powder room has Venetian Plaster walls. <br /> The primary bedroom/bathroom has a barrel vaulted ceiling and access to the patio. The 4' x 8' closet has built-ins. The bathroom has an oversized shower and a coffee bar with a butcher block countertop.<br /> The 2nd and 3rd bedrooms have private bathrooms and the 4th bedroom is near a half bath.<br /> The laundry room has a Dutch door and opens to the back patio at the other end. There are spacious countertops, many cabinets, and a utility sink. <br /> Upstairs is the 20' x 27' playroom, the 20' x 17' media room, an electronics room, a half bathroom, and a 13' x 5' storage closet.<br /> Outside, the porte-cochere allows covered access to the heated and cooled office/hobby room that has an overhead door. The covered patio overlooks the saltwater pool, which has a slide, a custom rock edge, a waterfall, and a sun shelf. The heated/cooled pool house features 12' sliding glass doors, a wood-burning FP, a kitchenette, and a 3/4 bath. The outside kitchen has a large bar, a grill, and a wood-fired pizza oven. One outside faucet has both hot and cold water. <br /> More details: all custom woodwork, granite, central vacuum, 3 CHA units, tankless and standard water heaters. Rough Sawn White Oak hard wood, Travertine tile, and carpet flooring. SS wiring, in and out. Foam insulated walls and attic; aerobic system, front sprinklers, whole house water filter system, and exterior lights with timer.
MlsNumber: --
ListingId: 2421582


Listing Provided By: Keller Williams Realty Ardmore, original listing
Phone: (580) 465-1092
Office Phone: (580) 319-7425
Agent Name: Tom Love
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.


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 = 2135 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 Shawn Stovall
Shawn Stovall
ASCIIActive Real Estate
Call Today!: (580) 564-5167

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App