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
This property is $1.3M more than the Median Sold Price and $144/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
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.
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.
We're sorry, we currently don't have sales or tax history data for this listing.
Payment Calculator
Calculate your estimated monthly expenses for this listing. Play with the values below to better understand your monthly payment and utilities.
$12.7K
Per Month
Principal & Interest
$12.4K
Home PriceThe dollar amount you pay for the home.
$
Interest RateMortgage interest rates fluctuate, but they're typically in the 5% to 9% range. Your rate will be calculated based on personal details including your credit score.
%
Down PaymentThe initial money paid at closing that is usually a percentage of the purchase price. Most loans require at least 3% down, but a 0% down payment may be possible if you're eligible for a VA or USDA loan.
$%
Loan TermThis is how long you'll pay on the loan. A longer term gives you smaller payments, while a shorter term saves you money on interest.
Property Taxes
$0
Property Taxes -Annual CostEvery homeowner pays taxes to their local government based on their home's value and the property tax rates for the county or city. Most areas charge property taxes semiannually.
$/ Year
Mortgage Insurance
$0
Mortgage Insurance -Monthly PremiumMortgage insurance helps secure a mortgage with a lower down payment. It typically costs 0.1% - 2% of your loan amount per year.
$/ Month
Homeowners Insurance
$67
Homeowners Insurance -Monthly PremiumMost homeowners pay about $1,000 a year for homeowners insurance, but the cost varies based on your location, home and coverage.
$/ Month
Homeowners Association (HOA)
$166
Homeowners Association -Monthly FeesHomeowners Association (HOA) fees can range from $30 per month to $500+ per month. Be sure to ask your agent about HOA fees on a home as it can impact your affordability or check the online home listing.
$/ Month
Utilities
$0
Utilities - Monthly CostYou'll need to budget for utilities as a homeowner, which typically includes water and sewer, gas and electric, internet and cable. Cost will depend on your location and the size of your home. On a monthly basis, Americans pay $239 - $442 per month.
$/ Month
Recommended Financing
30-Year Fixed
Rate/APR
7.5% / 6.68%
Total Monthly Payment
$7,562
Powered By
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
7
/10
Grove Avenue Elementary School
900 S Grove Ave
Distance between this listing and this school0.81 miles
Public District Grades KG-5
Middle School
6
/10
Barrington Mdle School- Prairie Cmps
40 E Dundee Rd
Distance between this listing and this school0.98 miles
Public District Grades 6-8
High School
7
/10
Barrington High School
616 W Main St
Distance between this listing and this school1.64 miles
Public District Grades 9-12
Assigned Schools
7
/10
Grove Avenue Elementary School
900 S Grove Ave
Distance between this listing and this school0.81 miles
Public District Grades KG-5
Nearby Schools
7
/10
Hough Street Elementary School
310 S Hough St
Distance between this listing and this school1.34 miles
Public District Grades PK-5
9
/10
North Barrington Elementary School
310 N Il Route 59
Distance between this listing and this school1.66 miles
Public District Grades KG-5
Assigned Schools
6
/10
Barrington Mdle School- Prairie Cmps
40 E Dundee Rd
Distance between this listing and this school0.98 miles
Public District Grades 6-8
Nearby Schools
8
/10
Barrington Middle School Station
215 Eastern Ave
Distance between this listing and this school1.66 miles
Public District Grades 6-8
7
/10
Lake Zurich Middle - S Campus
435 W Cuba Rd
Distance between this listing and this school4.09 miles
Public District Grades 6-8
Assigned Schools
7
/10
Barrington High School
616 W Main St
Distance between this listing and this school1.64 miles
Public District Grades 9-12
Nearby Schools
8
/10
Wm Fremd High School
1000 S Quentin Rd
Distance between this listing and this school4.73 miles
Public District Grades 9-12
9
/10
Lake Zurich High School
300 Church St
Distance between this listing and this school5.80 miles
The neighbors living near this home have an average income of $162,391. Typical income of Barrington Hills, IL residents is $200k+ annually. Typical family type is married, no kids. Most 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/10Barrington Mdle School- Prairie Cmps: GreatSchools Rating 6/10Barrington High School: GreatSchools Rating 7/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.
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.
Over 1 listings were sold over their listed price in October 2024 in Barrington Hills, IL. In the same period over 3 listings were sold below the listed price and 0 listings were sold for the listed price. The number of homes for sale in Barrington Hills, IL increased by 11.1% between September 2024 and October 2024. In October 2024 median list price was $1,118,000 and the average listing age was 36 days.
From Rocket Homes Real Estate and based on county public records data.