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 = 3134 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 = 3134 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 = 3134 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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;

11 Moate Lane
Barrington Hills, IL 60010

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,499,200
Beds: 5
Baths: 5
Status: Active
SqFt: 6528
Agency: Worth Clark Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 1996
Notes: Experience the epitome of luxury living in this exquisite Barrington Hills estate, nestled on 5.11 acres of breathtaking scenery. This distinguished property boasts a spectacular 5-bedroom, 5-bathroom residence complemented by a backyard sanctuary that caters to both discerning homeowners and their beloved horses or favored hobbies. Step into a world of indulgence with a 20 x 40 saltwater pool accompanied by a rejuvenating hot tub, meticulously landscaped gardens, and a serene koi pond complete with a cascading waterfall. Entertain in style on expansive decks and patios, equipped with an outdoor kitchen, fireplace, and firepit, ideal for alfresco dining and gatherings under the stars. For the automotive enthusiast, a heated garage accommodates up to 6 cars, while a versatile barn structure offers a 670 SF studio/guest apartment and a heated and cooled 3-stall barn. Paddocks, pastures with PVC fencing, and a round pen cater to equestrian pursuits, ensuring the utmost comfort for your horses. Boasting over 7,000 SF of meticulously crafted living space, the all-brick residence exudes timeless elegance and modern sophistication. Oversized windows flood the interiors with natural light, highlighting walnut floors, high ceilings, and exquisite moldings. The grand Great Room, adorned with a stone fireplace, sets the stage for cozy gatherings, while the gourmet kitchen impresses with a vast marble island, top-of-the-line Thermador & Sub-Zero appliances, and scenic views of the pool and pastures. Retreat to the luxurious primary suite offering a spa-like bathroom, custom walk-in closets, and hardwood floors. Additional bedrooms provide comfort and privacy, including an ensuite guestroom on the main level. The lower level is a haven for relaxation and entertainment, featuring radiant heat stone floors, a recreation room with a fireplace, a fully equipped theater room, and a second kitchen. Sliding doors lead to the patio and pool area, offering seamless indoor-outdoor living. Exceptional upgrades include a tankless water heater, high-end conditioning system, generator, central vac, and a new architectural shingle roof. With its idyllic setting, privacy, and proximity to town amenities, this extraordinary property offers a perfect retreat for every season.
MlsNumber: 12029029


Listing Provided By: Worth Clark Realty, original listing
Name: Worth Clark Realty
Phone: (314) 222-0065
Office Name: Worth Clark Realty
Office Phone: (800) 991-6092
Agent Name: David Riano
Disclaimer: Copyright © 2024 Midwest Real Estate Data, LLC. 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 = 3134 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 Cierra Thurman
Cierra Thurman
ASCIIColdwell Banker Realty
Call Today!: (708) 595-9889

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App