Please stand by.
USDAProperties.com is running hot! 🔥 🔥 🔥...

 

 

 

$2,590,000   Price Analysis
USDAProperties Agent Contact Page  Agent Details  share icon     map icon  QR
274 Leeds Dr
Barrington Hills, IL 60010
5 bed 6 bath 7,434 SqFt ($348/SqFt)
5.0 acre lot. Built 1971
Listed 2024-06-27, Taxes $18,583
Ⓧ USDA Ineligible
due to price & location

near Barrington Hills

Nestled on a hill overlooking Mirror Lake

This exquisite 5-acre custom estate blends the warmth of a family home w/ the opulence of a five-star resort. Offering breathtaking lake views and meticulously manicured grounds featuring an inground pool, 2 outdoor kitchens, multiple water features, outdoor pavilion, pool house w/ rooftop deck and sand bach. The expansive main house is complemented by a 2-stall barn and massive outbuilding /garage/workshop/barn. A private gate opens to a circular paved driveway, leading to a custom handcrafted entryway. Inside, you're greeted by pleasing hardwood floors, a dramatic winding staircase & Venetian plaster walls crafted by European artisans. The large dining room w/ a tray ceiling is perfect for both grand dinner parties & intimate family meals. The chef's kitchen boasts travertine floors, custom cherry cabinets, a walk-in pantry, granite countertops, stainless appliances, pro-grade Thermador double oven w/ a 6-burner stovetop & integrated grill, built-in exhaust hood, huge island & double sinks. The bright & open tremendous room features spectacular pool views, cozy stone fireplace, vaulted ceiling w/ a hand-carved medallion & multiple skylights. The inviting library offers custom built-in bookcases & stone fireplace, creating a serene space for quiet contemplation. The bright living room opens to a private patio w/ attractive views of the grounds & lake. The open office provides a private & quiet workspace. The workout room has volume ceilings & lots of windows overlooking the patio. The main level also includes a laundry room w/ custom built-ins & sizable powder room.

Ascending the wide spiral staircase to the 2nd level you'll find a luxurious primary suite w/ hardwood floors, walk-in closet, custom built-ins & an incredible enclosed balcony/sunroom that offers year-round views. The ensuite bathroom features a shower, jetted tub, dual sinks & bidet. 3 add'l large bedrooms, each w/ wood floors, walk-in closets & private full baths, complete the 2nd level. The basement includes an entertainment area, wet bar, mechanical room & ample built-in storage. For the car enthusiast, an attached heated garage, add'l 3-car garage & an outbuilding that can store 4-6 add'l vehicles. While the main house is truly spectacular, the crowning glory of this unique property lies in its meticulously designed & flawlessly executed exterior entertaining spaces. The covered outdoor kitchen is a chef's dream, featuring a custom wood-fired pizza oven and built-in five-burner grill for creating exquisite meals. The inground pool boasts an attached hot tub & an integrated stone diving board. Relax on the patio listening to the soothing sounds of water streaming thru the ponds & waterfalls or find a tranquil spot on one of the multiple individual patios for a peaceful escape from the poolside activity. For larger gatherings, the covered pavilion offers a perfect space for entertaining, rain or shine. The pool house provides add'l conditioned space for entertaining & relaxing. It includes a custom-built wet bar, a cozy sitting area overlooking the pool, lower-level bedroom w/ a walk-in closet & access to a private patio, a large full bathroom w/ steam shower & a massive rooftop deck offering stunning views of the lake, grounds, patio & home. Finally, there is a 2nd winter kitchen w/ a flagstone patio, built-in grill & wood-burning fireplace located off the main house offering easy access to grilling & entertaining during cooler months or when a more intimate outdoor experience is preferred. Enjoy relaxing on your private beach or kayaking on Mirror Lake. In addition to the home & property, another exceptional feature is its prime location. Located in one of the few walkable neighborhoods in Barrington Hills, the sellers have enjoyed riding bikes & walking w/ their children thru the private & quiet streets without worrying about busy traffic or noise that is often experienced w/ other area properties.


Presented by Jim Talerico at
Redfin Corporation.
Listing Agent Photo

Property MLS #12090320 from MRED

Bedrooms: 5
Bedrooms Possible: 5
Primary Bedroom Dimensions: 24 x 17
Bedroom 2 Dimensions: 15 x 16
Bedroom 3 Dimensions: 15 x 19
Bedroom 4 Dimensions: 12 x 19
Bedroom 5 Dimensions: 18 x 15
Primary Bedroom Level: Second
Bedroom 2 Level: Second
Bedroom 3 Level: Second
Bedroom 4 Level: Second
Bedroom 5 Level: Main

Total Rooms: 13
Library, Office, Great Room, Bedroom 5, Sitting Room, Sun Room
Library: 23 x 22
Library Level: Main
Sitting Room: 10 x 22
Sitting Room Level: Basement
Sun Room: 13 x 7
Sun Room Level: Second
Laundry: 10 x 10
Laundry Level: Main
Basement Features: Full
Family Room Dimensions: 13 x 22
Great Room Dimensions: 23 x 30
Living Room Dimensions: 15 x 25
Office/Study Room Dimensions: 13 x 18
Family Room Level: Basement
Great Room Level: Main
Living Room Level: Main
Office/Study Room Level: Main
Basement Description: Finished

Total Bathrooms: 6
Full Bathrooms: 5
1/2 Bathrooms: 1

Vaulted/Cathedral Ceilings
Skylight(s)
Hardwood Floors
First Floor Laundry
Built-in Features
Walk-In Closet(s)
Granite Counters
Separate Dining Room
Pantry
Door Features: French Doors
Flooring: Hardwood, Slate

Yes
Laundry Features: Gas Dryer Hookup, In Unit, Sink

Cooling Features: Central Air
Fireplace Features: Wood Burning, Electric
Heating Features: Natural Gas, Electric, Forced Air
Number of Fireplaces: 2

Dining Area Dimensions: 14 x 18
Dining Area Level: Main
Kitchen Dimensions: 13 x 17
Kitchen Level: Main

Balcony
Deck
Patio
Hot Tub
Roof Deck
Brick Paver Patio
In Ground Pool
Storms/Screens
Outdoor Grill
Fire Pit
Invisible Fence
Other Structures: Outdoor Kitchen, Pool House, RV/Boat Storage, Second Garage, Stable(s), Garage(s)

Lot Description: Beach, Cul-De-Sac, Horses Allowed, Lake Front, Landscaped, Water Rights, Water View, Waterfront
Lot Size Acres: 5.0
Lot Size Dimensions: 103X568X336X75X608X357
Lot Size Square Feet: 217800

Driveway: Brick, Circular
Garage Spaces: 4
Garage Description: Attached
Garage Features: Carport, Heated, 7 Foot or more high garage door, Multiple Garages
Parking Total: 4

Elementary School: Countryside Elementary School
Elementary School District: 220
High School: Barrington High School
High School District: 220

Countryside Elementary School is a public elementary school located approximately 1 miles away.
directions icon Map directions

Barrington High School is a public high school located approximately 2.4 miles away.
directions icon Map directions

Barrington Mdle School- Prairie Cmps is a public middle school located approximately 3.8 miles away.
directions icon Map directions

Noahs Ark Christian Preschool is a private elementary school located approximately 2.5 miles away.
directions icon Map directions

Community Features: Pool, Stable(s), Horse-Riding Trails, Lake, Curbs, Gated, Sidewalks, Street Lights, Street Paved

Annual Tax Amount: 24217.79
Source Listing Status: Active
County: Cook
Directions: W County Line Road to Donlea Road, South to Crabapple, West to Leeds
Tax Year: 2022
Ownership: Fee Simple
Source Property Type: Residential
Parcel Number: 01041020030000
Township: Barrington
Property Subtype: Detached Single
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2021$50,965 + $21,780
$72,745
$18,583
2020$50,965 + $21,780
$72,745
$18,095
2019$60,406 + $21,780
$82,186
$17,910
2018$76,544 + $16,335
$92,879
$20,779
2017$76,544 + $16,335
$92,879
$20,336
2016$76,544 + $16,335
$92,879
$19,435
2015$73,584 + $10,890
$84,474
$19,718
2014$73,584 + $10,890
$84,474
$19,694
2013$76,727 + $10,890
$87,617
$19,629
2012$73,484 + $10,890
$84,374
$17,948
2011$73,484 + $10,890
$84,374
$16,931
2010$77,445 + $10,890
$88,335
$17,381
2009$74,046 + $16,335
$90,381
$15,985
2007$68,011 + $26,136
$94,147
$15,788
2006$67,656 + $17,424
$85,080
$14,883

Listed 2024-06-27
$2,590,000
MRED
Listing removed 2024-06-22
$0
MRED
Listed 2023-10-13
$2,735,000
MRED
Listing removed 2023-10-13
$2,750,000
MRED
Listed 2023-07-20
$2,750,000
MRED
Sold 2004-05-10
$790,000
Public Record
Sold 2002-04-09
$757,000
Public Record
Sold 2000-08-29
$779,000
Public Record
Sold 1991-05-14
$483,000
Public Record

Total Square Feet Living: 7434
Year Built: 1971
Property Age: 53
Levels or Stories: 2

Electric: Circuit Breakers
Sewer: Septic-Private
Water Source: Private Well

Other Equipment: Water-Softener Owned, Security System, CO Detectors, Sump Pump, Generator, Multiple Water Heaters
Click Thumbnail Images To View Full Size
house_viewunknownunknownunknownunknown
dining_roomdining_roomkitchenkitchenkitchen
kitchenkitchenkitchenkitchendining_room
living_roomliving_roomliving_roomliving_roomkitchen
living_roomliving_roomliving_roomliving_roomliving_room
living_roomliving_roomliving_roomliving_roomdining_room
living_roomliving_roomunknownunknownlaundry_room
kitchenbathroomunknownbedroombedroom
living_roomunknownbathroombathroombedroom
bedroombathroombathroombedroombedroom
bathroombedroomunknownbedroombedroom
bathroomunknownbedroomliving_roomkitchen
dining_roomunknownhouse_viewunknowndining_room
kitchenbathroombathroomliving_roomliving_room
unknownunknownunknownunknownunknown
house_viewhouse_viewporchporchporch
porchporchporchporchporch
house_viewporchporchporchporch
porchhouse_viewhouse_viewunknownunknown
unknownporchfarm_landporchhouse_view
yardhouse_viewyardhouse_viewhouse_view
unknownporchunknownunknownunknown
garagegaragegaragegarageunknown
unknownunknownunknownfloor_planfloor_plan

The property loan eligibility may be subject to additional requirements beyond geographical location including but not limited to the condition of the property. Speak with a real estate professional to find out more about the eligibility of a specific property.