Hang on a second...
USDAProperties.com is running hot! 🔥 🔥 🔥...

 

 

 

$2,500,000   Price Analysis
USDAProperties Agent Contact Page  Agent Details  share icon     map icon  QR
74 Dundee Ln
Barrington Hills, IL 60010
5 bed 7 bath 6,809 SqFt ($367/SqFt)
5.3 acre lot. Built 1993
Listed 2024-04-15, HOA $167, Taxes $30,047
Ⓧ USDA Ineligible
due to price & location

near Barrington Hills

Welcome to lakeside luxury living at its finest!

Nestled along the tranquil shores of breathtaking Keene Lake, unveil the potential of this enchanting home and let your design dreams unfold in this private, idyllic setting. The interior of the home has been virtually staged to reflect the possibilities that exist within. Indulge in resort style amenities right at home with an incredible attached indoor pool house featuring cedar walls and ceilings, a 20x40 ft inground pool with hot tub plus a soothing sauna room. From the moment you arrive, you'll be captivated by the stunning architectural details and serene lake views that envelope this remarkable property. Step inside to discover a world of refined elegance and sophistication. The main residence features exquisite custom ceilings, pleasing fireplaces and a grand two-story entry adorned with a triple tray ceiling and dazzling crystal chandelier. Formal living and dining rooms provide the perfect backdrop for gatherings, while a vast kitchen with a breakfast area opens to a charming sunroom adorned with arched openings with charming Saltillo tiles seamlessly connecting the space.

The adjacent family room is the perfect gathering space and the main floor office and library allow for work from home convenience. Upstairs the primary suite awaits with its own sitting area and fireplace, offering views of the lake and luxurious his and her baths and walk-in closets. Four additional bedrooms, all with walk-in closets and ensuite baths, provide ample space for family and guests. Head downstairs to the finished lower level where you will find a huge recreation room, game area, workshop, meditation and craft rooms - something for everyone to enjoy. An attached guest house boasting 4 bedrooms, 3 bths, a voluminous tremendous room with soaring ceilings, a large kitchen and a finished walk-out lower level offers added versatility for your lifestyle. Outside the fun continues with tennis courts, garage parking for 8 cars and a sprawling lawn and deck, perfect for enjoying the splendor of this lakeside oasis. Just minutes to town, train, shopping, restaurants and D220 schools. Emb race the extraordinary in this lakeside retreat!


Presented by John Morrison at
@properties Barrington.
Listing Agent Photo

Property MLS #11965732 from MRED

Bedrooms: 5
Bedrooms Possible: 5
Primary Bedroom Dimensions: 32 x 18
Bedroom 2 Dimensions: 19 x 15
Bedroom 3 Dimensions: 17 x 12
Bedroom 4 Dimensions: 17 x 12
Bedroom 5 Dimensions: 19 x 11
Primary Bedroom Level: Second
Bedroom 2 Level: Second
Bedroom 3 Level: Second
Bedroom 4 Level: Second
Bedroom 5 Level: Second

Total Rooms: 16
Breakfast Room, Bedroom 5, Library, Recreation Room, Heated Sun Room, Workshop, Office, Sewing Room, Foyer, Other Room
Library: 19 x 16
Library Level: Main
Heated Sun Room: 45 x 17
Heated Sun Room Level: Main
Work Room: 22 x 18
Work Room Level: Basement
Sewing Room: 14 x 12
Sewing Room Level: Basement
Other Room: 61 x 53
Other Room Level: Main
Laundry: 8 x 8
Laundry Level: Main
Basement Features: Full
Entry Foyer Dimensions: 28 x 19
Family Room Dimensions: 21 x 17
Game/Recreation Room Dimensions: 60 x 48
Living Room Dimensions: 19 x 19
Office/Study Room Dimensions: 19 x 16
Basement Sqft: 2643
Entry Foyer Level: Main
Family Room Level: Main
Game/Recreation Room Level: Basement
Living Room Level: Main
Office/Study Room Level: Main
Basement Description: Finished

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

Vaulted/Cathedral Ceilings
Skylight(s)
Sauna/Steam Room
Bar-Wet
Hardwood Floors
First Floor Laundry
Pool Indoors
Built-in Features
Walk-In Closet(s)
Bookcases
Coffered Ceiling(s)
Beamed Ceilings
Flooring: Terracotta, Carpet, Hardwood

Double Oven
Microwave
Dishwasher
High End Refrigerator
Freezer
Washer
Dryer
Disposal
Trash Compactor
Cooktop
Water Purifier Owned

Cooling Features: Central Air, Zoned
Heating Features: Natural Gas, Forced Air, Baseboard, Radiant
Number of Fireplaces: 6

Breakfast Room Dimensions: 19 x 12
Breakfast Room Level: Main
Dining Area Dimensions: 21 x 14
Dining Area Level: Main
Kitchen Dimensions: 24 x 21
Kitchen Level: Main

Deck
Other Structures: Second Garage, Tennis Court(s)

Lot Description: Lake Front, Landscaped, Water Rights, Water View
Lot Size Acres: 5.3
Lot Size Dimensions: 397X693X324X68X640
Lot Size Square Feet: 230868

Driveway: Asphalt, Circular, Side Drive
Garage Spaces: 8
Garage Description: Attached, Detached
Garage Features: Garage Door Opener(s), Transmitter(s), Multiple Garages
Parking Total: 8

Association: Yes
Association Fee: 2000
Association Fee Frequency: Annually
Association Fee Includes: Lake Rights
Calculated Total Monthly Association Fees: 167

Elementary School: Grove Avenue Elementary School
High School: Barrington High School
High School District: 220

Grove Avenue Elementary School is a public elementary school located approximately 0.8 miles away.
directions icon Map directions

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

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

Creative Learning Montessori School is a private elementary, middle and high school located approximately 0.5 miles away.
directions icon Map directions

Community Features: Lake, Water Rights, Street Paved

Annual Tax Amount: 37868.19
Source Listing Status: Active
County: Cook
Directions: Dundee East of 59, Dundee Lane North to Home
Tax Year: 2022
Ownership: Fee Simple
Source Property Type: Residential
Source Neighborhood: Barrington Lakes
Parcel Number: 01112020120000
Subdivision: Barrington Lakes
Township: Barrington
Property Subtype: Detached Single
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2020$104,054 + $11,586
$115,640
$30,047
2019$187,949 + $23,173
$211,122
$48,013
2018$191,811 + $17,380
$209,191
$48,599
2017$215,367 + $17,380
$232,747
$73,862
2016$215,367 + $17,380
$232,747
$49,511
2015$187,877 + $11,586
$199,463
$47,421
2014$187,877 + $11,586
$199,463
$47,343
2013$187,877 + $11,586
$199,463
$45,461
2012$192,889 + $11,586
$204,475
$44,274
2011$192,889 + $11,586
$204,475
$41,623
2010$192,889 + $11,586
$204,475
$40,714
2009$204,426 + $17,380
$221,806
$40,864
2007$226,184 + $27,808
$253,992
$40,649
2006$222,018 + $18,539
$240,557
$40,790

Listed 2024-04-15
$2,500,000
MRED

Total Square Feet Living: 6809
Year Built: 1993
Foundation Details: Concrete Perimeter
Property Age: 31
Roof: Shake
Levels or Stories: 2

Sewer: Septic-Private
Water Source: Private Well

Other Equipment: Humidifier, Water-Softener Owned, Central Vacuum, CO Detectors, Ceiling Fan(s), Sump Pump, Multiple Water Heaters
Click Thumbnail Images To View Full Size
unknownunknownunknownunknownunknown
porchhouse_viewunknownunknownliving_room
unknownliving_roomliving_roomunknowndining_room
laundry_roomdining_roomkitchenkitchenkitchen
dining_roomliving_roomunknownliving_roomdining_room
living_roomliving_roomunknownliving_roombedroom
kitchenbathroomunknownbedroombedroom
bedroombedroombedroomliving_roomliving_room
unknownunknownunknownporchunknown
house_viewunknownporchunknownporch
farm_landunknownhouse_viewunknownhouse_view
unknowndining_roomdining_roomunknownliving_room
bedroombedroombedroombedroomunknown
dining_roomunknownunknownunknownunknown
unknownfloor_planfloor_planfloor_planfloor_plan
floor_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.