NEWLY UPDATED and stunning from the inside out - this move-in ready 5 Bedroom waterfront custom ranch home in prestigious Harrow Gate of Inverness is situated on a premium and tranquil 1.04-acre cul-de-sac and has been completely remodeled in 2022. No expense has been spared including over $120,000 on the kitchen and master bathroom alone! Enjoy family time or entertaining in the cathedral Great Room which opens up to a vaulted beamed ceiling with a floor-to-ceiling stone fireplace. The NEWLY REMODELED bright and spacious Kitchen offers abundant designer custom cabinetry, an oversized island with quartz countertops, top of the line stainless appliances, breakfast bar, dining area, wet bar and lakefront deck access. The Grand Owner's En-Suite highlights a beamed ceiling with a walk-out exit to the deck with lake views and his and hers closets. The attached BRAND-NEW (2022) LUXURIOUS bathroom has SPAlike finishes and features an expansive walk-in shower with imported subway tile, rain shower head and hand sprayer as well as a soaking tub and double basin vanity. The spacious secondary bedrooms have walk-in closets with plenty of space, and an adjacent or nearby bathroom. The first floor and most of the walkout level have been repainted in 2022 and the first floor has all BRAND-NEW FLOORING including over 2200+ SF of oak hardwood floors and all new carpeting in the secondary bedrooms. Work from home in the versatile main floor office connected to the kitchen near the entrances or the executive office with wet bar on the lower level. The walkout lower level has an elegantly finished 1800+ SF of comfortable living space with a large recreation room with room for pool or ping pong and space for a home theatre with multi-level floor seating with wet bar and a second stone fireplace. Bedrooms 4 & 5 are on the walkout level and Bedroom 5 comes with an attached executive office with wet bar which could be repurposed as an in-law suite with full kitchen if desired. The storage/equipment room has well maintained dual zone HVAC along with a BRAND-NEW 50-Gal water heater and JUST INSTALLED (May 22) Angel Water Ozone injection whole house treatment system delivering bottled water quality for the entire home! The walkout level has ALL NEW flush mount and dimmable LED lighting for a brightly lighted appearance. The convenient main floor laundry/mudroom has ceramic tile flooring and offers easy access to the massive attached 3+ car garage with epoxy floors and integrated full wall shelving. There are two attic storage areas; one accessible from the interior with a heavy-duty retractable stairway near the cedar closet and the second is in the garage. Most major exterior systems have been renovated or replaced in the past 10 years - NEW North Windows 2012, NEW Exterior paint June 2017, NEW COMPLETE TEAR-OFF ROOF/GUTTERS Oct 2018, NEW RIP AND REPLACE Asphalt Driveway Oct 2019, NEW Brick Courtyard Entrance June 2020, Select Windows ordered and fully paid with installation in the fall. You can paddleboat, canoe, swim, catch and release fish, or ice skate from your own yard or walk a couple of blocks to the even larger Lake Harrowgate for more outdoor recreational opportunities year-round. The home is located in the Award-winning Barrington 220 School District and is conveniently located to all schools, O'Hare, Woodfield and local shopping plus downtown Barrington's cultural attractions and METRA train station, with full I-90 East/West Access within 5 miles! Low Cook County Taxes! The new construction done in 2022 comes with a 1-year warranty while new appliances carry factory warranty and the existing home is sold "as-is". This home offers tons of space to spread out and is ideal for growing families who like to entertain, multi-generation living or working from home. No expense has been spared in making this rare ranch style home with over 5200 SF(under roof) updated to all the newest standards, trouble-free and ready for move-in immediately!