504 N Old Rand Road
Lake Zurich, IL 60047

4 Beds 5 Full 1 Half Bath 5225 sq ft

Waters Edge is where passion and vision unite; it's where peace exists and class is elevated! 233 acres of spring-fed waterway outline Lake Zurich with its scenic views, water sports, and cultural attractions along the shoreline. A luxury corridor where a 2024 custom design is set at the height of the lake's elevation with 90 feet of water frontage. A 1,200-square-foot hardscape terrace with a dry bar overshadows the water, making an unparalleled connection with an extended pier, followed by exquisite landscaping and an adjacent water feature. The attention surrounding this extraordinary build speaks for itself, set back on over an acre with a stunning front elevation leading guests to a vaulted front porch with panoramic views of the lake. 8' French doors unveil a thoughtfully curated main-level floor plan, intentionally designed to capture the surrounding views from every vantage point. Adjacent to the entry is a sophisticated glass-enclosed office with remarkable views of the lake. Beyond the office is an expansive family room with exposed beams, a gorgeous fireplace, remote window treatments, and glass-door access to the garden beds. A family room that is versatile for both comfort and entertainment while open to the stunning kitchen with 42" shaker cabinets, a stunning dimensional backsplash, quartz counters, Wolf range and microwave, Sub-Zero refrigerator, contrasting breakfast bar facing the lake with a built-in Sub-Zero beverage fridge, and scullery pantry. The exemplary kitchen is defined by its elegance while open to the ...

+ Read More
See More

Listing Courtesy of: Coldwell Banker Realty
Listing Agent: Robbie Morrison
(847) 212-0966

Mortgage Calculator

Per Month
Principal and Interest
Property Taxes 2243
HOA Fees 0
Homeowners Insurance 1497
$
$
%
%
$
$
$
%

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 Amy Gert - Residential are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo (a little black house) and detailed information about them includes the names of the listing brokers. Some properties which appear for sale on this website may subsequently have sold and may no longer be available. 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.

NOTICE: Many homes contain recording devices, and buyers should be aware they may be recorded during a showing.

Copyright © 2026 Midwest Real Estate Data LLC
Information deemed reliable but not guaranteed.

Midwest Real Estate Data LLC data last updated on October 08, 2026 04:15 PM - CT

Broker Reciprocity Logo

Based on information submitted to the MLS GRID as of October 08, 2026 04:15 PM - CT. 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. Properties displayed may be listed or sold by various participants in the MLS. Some listings have been excluded from this website.

IDX information is provided exclusively for consumers’ personal noncommercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID 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.

Property Last Updated: October 08, 2026 04:15 PM - CT