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

1 Hayward Court
Lake In The Hills, IL 60156
Laurie Arslani with eXp Realty, LLC, original listing - (888) 574-9405

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,900
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3418 Square Feet
Agency: eXp Realty, LLC
Agency Phone: (888) 574-9405

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: Welcome to 1 Hayward Ct, a stunning custom residence on a quiet cul-de-sac in sought-after Lake in the Hills. Expansive, impressive, and loaded with upgrades - this magazine-worthy style 4+ bedrooms, 3.5-bathroom home offers over 4409 sq ft of exquisitely finished living space, including a show-stopping basement, curated upgrades throughout, and an entertainer's dream backyard. From the moment you arrive, you'll notice the impeccable attention to detail and craftsmanship-from the striking stone-accented exterior (2019) to the lush landscaping, landscape lighting, and expansive paver patio designed. A fully insulated shed, new fence (2018), and epoxy-coated garage and patio (2022) enhance functionality while adding polish and charm. Step inside and fall in love with the expansive, light-filled layout. The heart of the home is the gourmet kitchen, thoughtfully remodeled with granite countertops, top-of-the-line stainless steel appliances, built-in stainless-steel refrigerator, a professional-grade hood exhaust, and custom pull-out shelving by Shelf Genie. Warm hardwood floors, solid oak doors and trim, and designer lighting create an upscale, cohesive ambiance throughout the main level. Upstairs, you'll find four generously sized bedrooms with custom window treatments, newer carpet (2020-2021), and a beautifully finished hallway featuring hardwood flooring and a cozy built-in nook (2019). The primary suite and second-floor bathrooms were tastefully remodeled to provide spa-like comfort and elegance. Prepare to be impressed by the fully finished basement (2021), complete with luxury vinyl plank flooring, a beverage fridge, custom cabinetry, and a one-of-a-kind bar crafted from reclaimed 1920s McHenry barn wood. The post wrap and built-in shower were expertly designed by Wilson Hill Carpentry, creating a unique, high-end space perfect for entertaining or relaxing. Additional flex rooms in the basement offer endless possibilities-perfect for a home office, fitness space, guest suite, or extra storage. Additional upgrades include an Electric charging station (2019) with upgraded electrical panel, new water heater (2024), new sump pump (2024), high-efficiency furnace (2019), and Aero Seal duct cleaning/sealing/sanitizing (2022). Roof replaced 2016. All windows were replaced in 2019, and the home was freshly painted in 2025, ensuring it's truly move-in ready. Designed with pet lovers in mind, this homes kitchen remodel features a custom-installed, lockable dog door-combining functionality, durability, and modern convenience for your four-legged family members. This home seamlessly blends luxury, character, and modern convenience. Every inch has been upgraded with purpose and elegance, offering a lifestyle of comfort and sophistication. Don't miss the opportunity to own one of the most thoughtfully updated homes in the area-schedule your private tour today!
MlsNumber: --
ListingId: 12327733


Listing Provided By: eXp Realty, LLC, original listing
Phone: (888) 574-9405
Office Phone: (888) 574-9405
Agent Name: Laurie Arslani
Disclaimer: Copyright © 2025 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 Mortgage Pro

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 = 662 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 Brian Bachtell NMLS#2580785
Brian Bachtell NMLS#2580785
ASCIIThe Money Store
Call Today!: (847) 571-6699
Office: (708) 730-2003

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App