15 days on rocket

74 Dundee Ln, Barrington Hills, IL, 60010

$2,500,000

Home List Price

$10,000*

Closing Credit

5 Bedrooms
6 Full Baths, 1 Partial
6,809 SqFt
$367/SqFt
House
Schools Nearby

Location

Image provided by Mapbox

Get An Agent. Get A Mortgage.

Save BIG.

Rocket Homes logo

74 Dundee Ln, Barrington Hills$2,500,000

Buyer Closing Credits

$10,000*

1.25% Loan Amount

Rocket Homes logo

Still Have Questions? Contact Us.

Contact Us Phone Number1 (855) 200-2001

Property Highlights

Home TypeSingle Family Residence
Attached Garage8 spaces
Year Built1993
HeatingNatural Gas, Forced Air, Baseboard, Radiant
CoolingCentral Air, Zoned
BasementYes
WaterfrontLake Front, Waterfront
MLS #11965732
Lot Size5.30 Acres
StatusActive

About 74 Dundee Ln

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, beautiful 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 spacious kitchen with a breakfast area opens to a charming sunroom adorned with arched openings with beautiful 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 & her baths and walk-in closets. Four additional bedrooms, all with walk-in closets and ensuite baths, provide ample space for family & 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 baths, a voluminous great 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. Embrace the extraordinary in this lakeside retreat!

Property Details

Property Features

Property Information:

  • Year Built: 1993
  • Living Area: 6,809 SqFt

Listing Office:

  • Office Name: @properties Christie's International Real Estate
  • Office Phone: (847) 381-0300
  • Listing Agent: John Morrison

Interior Features

Interior Information:

  • Appliances: Double Oven, Microwave, Dishwasher, Refrigerator, Freezer, Washer, Dryer, Disposal, Trash Compactor, Cooktop, Water Purifier
  • Basement: Yes
  • Interior: 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

Bedroom and Bathroom Information:

  • Partial Bathrooms: 1
  • Full Bathrooms: 6
  • Total Bedroom Count: 5

Exterior Features

Exterior Information:

  • Waterfront: Lake Front, Waterfront
  • Exterior: Deck

Parking Information:

  • Garage Space: 8 spaces
  • Attached Garage: Yes

Lot Features

Lot Information:

  • Lot: Waterfront, Landscaped, Riparian Water Rights, Views
  • Lot Size: 5.30 Acres

Utilities

Utilities Information:

  • Heating: Natural Gas, Forced Air, Baseboard, Radiant
  • Cooling: Central Air, Zoned

School Info

Assigned Schools Information:

  • Barrington High School, Public District Grades 9-12
  • Barrington Mdle School- Prairie Cmps, Public District Grades 6-8
  • Grove Avenue Elementary School, Public District Grades KG-5

Other

Directions Information:

  • Directions: Dundee East of 59, Dundee Lane North to Home

Price Information

Listing Price Info

Price Summary:

  • List Price: $2,500,000
  • Price Per SqFt: $367/SqFt

HOA Fees:

  • Amount: $2000
  • Frequency: Annually
House and calculator

What can I afford?

Understand what home price range makes sense for your budget.

Housing Market Comparison

See how this home compares to others in Barrington Hills, IL.

Map thumbnail provided by MapBox

Barrington Hills, IL

City

Med. Sold Price

$860K

Med. Price/SqFt

$214

Avg. Days On Market

24

# of Sold Homes

6

74 Dundee Ln vs Barrington Hills

15 DAYS ON ROCKET

-9 Days

$2,500,000

+$1.6M More

$367/SqFt

+$152 More

KEY TAKEAWAY

This property is $1.6M more than the Median Sold Price and $152/SqFt more than other homes in Barrington Hills, IL.

Based on homes sold in the last 12 months

MLS Details

MLS Information:

  • MLS Name: MRED
  • MLS Number: #11965732

Listing Office:

  • Office Name: @properties Christie's International Real Estate
  • Office Phone: (847) 381-0300
  • Listing Agent: John Morrison

IDX Listings courtesy of Midwest Real Estate Data as distributed by MLS GRID.

All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.

IDX Copyright © 2024 Midwest Real Estate Data LLC (MRED). All rights reserved.

The data relating to real estate for sale on this website comes in part from the Broker Reciprocity program of Midwest Real Estate Data LLC. Real Estate listings held by brokerage firms other than the broker/agent who owns the website are marked with the MRED Broker Reciprocity logo or the Broker Reciprocity thumbnail logo (the MRED logo) and detailed information about them includes the names of the listing brokers.

All data is obtained from various sources and has not been, and will not be, verified by broker or MRED. MRED supplied Open House information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. IDX information is provided exclusively for consumers’ personal non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed by MTP or MRED. The use of the MRED Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time.

Some properties which appear for sale on this website may subsequently have sold and may no longer be available. Information Deemed Reliable but Not Guaranteed. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available. The accuracy of all information, regardless of source, including but not limited to square footages and lot sizes, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals. NOTICE: Many homes contain recording devices, and buyers should be aware they may be recorded during a showing.

DIGITAL MILLENNIUM COPYRIGHT ACT (DMCA) NOTICE
The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA") provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to DMCAnotice@theMLSGRID.co

The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner’s behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

Copyright © 2024 Midwest Real Estate Data LLC (MRED). All rights reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 5/1/2024, 10:15:21 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.

Property Sales & Tax

We're sorry, we currently don't have sales or tax history data for this listing.

Payment Calculator

$12.7K

Per Month

Recommended Financing

30-Year Fixed

Rate/APR

7.5% / 6.68%

Total Monthly Payment

$7,562

Powered By

Rocket Mortgage

Advertisement

NMLS#3030

Schools

Schools Nearby

The school rating is a score out of 10, where 10 is the highest and 1 is the lowest. Assigned schools have a bold outline.

Elementary School

school-card-donut-4150401
7
/10

  • Grove Avenue Elementary School

  • 900 S Grove Ave

  • 0.81 miles

  • Public District Grades KG-5

Middle School

school-card-donut-4150402
5
/10

  • Barrington Mdle School- Prairie Cmps

  • 40 E Dundee Rd

  • 0.98 miles

  • Public District Grades 6-8

High School

school-card-donut-4150403
8
/10

  • Barrington High School

  • 616 W Main St

  • 1.64 miles

  • Public District Grades 9-12

All data from GreatSchools

Neighborhood

What Are The Neighbors Like?

The neighbors living near this home have an average income of $162,391. The majority of Barrington Hills, IL residents have income $200k+ annually. Most families are married, no kids. The majority of residents in this area have post secondary degree education.

All data provided by Home Junction and Claritas

Frequently Asked Questions About 74 Dundee Ln

What is the listing price of this property?

The listing price of 74 Dundee Ln property is $2,500,000.

What type of property is this?

The property 74 Dundee Ln is a house located in Barrington Hills, Illinois, 60010.

Is this property for sale now?

Active Listing: 74 Dundee Ln is For Sale (Active/New) which means the seller is accepting offers.

What are the assigned schools for this property?

The assigned schools for 74 Dundee Ln are:
Grove Avenue Elementary School: GreatSchools Rating 7/10
Barrington Mdle School- Prairie Cmps: GreatSchools Rating 5/10
Barrington High School: GreatSchools Rating 8/10

How many bedrooms and bathrooms does this property have?

The property at 74 Dundee Ln has 5 bedrooms and 6 full and 1 half bathrooms.

What is the square footage of this property?

The property 74 Dundee Ln is 6,809 SqFt (source: MLS/tax record).

Which year was this property built?

The year of construction for 74 Dundee Ln is 1993.

Rocket Homes›Illinois›Lake County›Barrington Hills›60010›74 Dundee Ln

This home is located at 74 Dundee Ln in Barrington Hills, IL and zip code 60010 in the Barrington Lakes neighborhood. This 6,809 square foot home, which was built in 1993, sits on a 5.30 acre lot. Features: 5 bedrooms, 7 bathrooms. It has been listed on Rocket Homes since April 15, 2024 and is currently priced at $2,500,000.

Barrington Hills, IL housing market in March 2024 saw over 1 listings sold above listed price, more than 2 sold at listed price and over 3 sold below. In March 2024 in Barrington Hills, IL there were 26.9% more homes for sale than in February 2024. The median list price of listings available in March 2024 was $860,000, while the average time on the real estate market was 24 days.

From Rocket Homes Real Estate and based on county public records data.

More Resources