504 N Old Rand Road
Lake Zurich, IL 60047
$2,995,000
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| Listing Id: | 12760165 |
|---|---|
| List Price: | $2,995,000 |
| Property Type: | Residential |
| Property Type: | Detached Single |
| Status: | Active |
| Bedrooms Total: | 4 |
| Bathrooms Full: | 5 |
| Bathrooms Half: | 1 |
| Living Area: | 5,225 |
| Parking On Site: | Yes |
| Association Fee: | $0 |
| Tax Annual Amount: | $26,922 |
| Architectural Style: | Farmhouse |
| Waterfront?: | Yes |
| City: | Lake Zurich |
| County Or Parish: | Lake |
| Postal Code: | 60047 |
| Year Built: | 2024 |
| Additional Parcels?: | Yes |
| Appliances: | Range, Microwave, Dishwasher, High End Refrigerator, Bar Fridge, Washer, Dryer, Disposal, Stainless Steel Appliance(s), Range Hood, Water Softener Owned, Humidifier |
| Association Fee Frequency: | Not Applicable |
| Association Fee Includes: | None |
| Basement: | true |
| Basement: | Finished, Egress Window, 9 ft + pour, Rec/Family Area, Sleeping Area, Storage Space, Daylight, Full |
| Bathrooms Total Integer: | 6 |
| Bedrooms Possible: | 5 |
| Community Features: | Park, Lake, Water Rights, Curbs, Sidewalks, Street Paved |
| Construction Materials: | Fiber Cement |
| Cooling: | Central Air, Zoned |
| Directions: | Rt12 N. of Rt 22, E. on Old Rand |
| Electric: | 200+ Amp Service |
| Elementary School: | May Whitney Elementary School |
| Elementary School District: | 95 |
| Exterior Features: | Balcony, Roof Deck, Outdoor Grill, Lighting |
| Fireplace Features: | Gas Log, Gas Starter |
| Fireplaces Total: | 1 |
| Flooring: | Hardwood |
| Foundation Details: | Concrete Perimeter |
| Garage Spaces: | 3 |
| Heating: | Natural Gas, Forced Air, Sep Heating Systems - 2+, Indv Controls, Zoned |
| High School: | Lake Zurich High School |
| High School District: | 95 |
| Interior Features: | Wet Bar, In-Law Floorplan, Built-in Features, Walk-In Closet(s), Beamed Ceilings, Open Floorplan, Pantry, Quartz Counters |
| Laundry Features: | Main Level, Sink |
| Living Area Source: | Plans |
| Lot Features: | Landscaped, Water Rights |
| Lot Size Acres: | 1.02 |
| Lot Size Dimensions: | 84x500x70x534x33 |
| Middle Or Junior School: | Lake Zurich Middle - N Campus |
| Middle Or Junior School District: | 95 |
| MLS Area Major: | Hawthorn Woods / Lake Zurich / Kildeer / Long Grove |
| Model: | CUSTOM |
| Age: | 1-5 Years |
| Agent Owned/Interest (Y/N): | No |
| Aprox. Total Finished Sq Ft: | 0 |
| Assessor Square Footage: | 1944 |
| Attic: | Interior Stair, Unfinished |
| Built Before 1978 (Y/N): | No |
| Bath Amenities: | Separate Shower, Double Sink, Soaking Tub |
| Basement Bathrooms (Y/N): | Yes |
| Bedrooms (Below Grade): | 1 |
| Corporate Limits: | Lake Zurich |
| Dining Room: | Separate |
| Disability Access And/Or Equipped: | No |
| Fireplace Location: | Family Room |
| General Information: | School Bus Service |
| Lot Size: | 1.0-1.99 Acres |
| Master Association Fee: | No |
| Master Association Fee Frequency: | Not Required |
| Market Code: | Active |
| North: | 42 |
| Rebuilt (Y/N): | No |
| Rehab (Y/N): | No |
| Rural (Y/N): | N |
| Offered For Sale Or Rent: | No |
| Special Assessments: | N |
| Is Parking Included In Price: | Yes |
| Special Service Area: | N |
| Square Footage Comments: | New construction square footage above grade is 3, 800 square feet with an additional 1, 410 square feet in the lower level. |
| Total Finished/Unfinshed Sq Ft: | 0 |
| Total Sq Ft: | 0 |
| Type Detached: | 2 Stories |
| Tax Exemptions: | Homeowner |
| Update Date: | 2026-09-29T05:05:35 |
| West: | 88 |
| Window Features: | Screens, Window Treatments |
| Zero Lot Line: | No |
| Original List Price: | $2,995,000 |
| Other Equipment: | Water-Softener Owned, Security System, Fire Sprinklers, CO Detectors, Ceiling Fan(s), Sump Pump |
| Other Structures: | Outdoor Kitchen |
| Ownership: | Fee Simple |
| Parcel Number: | 14173010140000 |
| Parking Features: | Asphalt, Side Driveway, Garage Door Opener, Garage, EV Ready, Yes, Garage Owned, Attached |
| Parking Total: | 3 |
| Possession: | Closing |
| Roof: | Asphalt |
| Rooms Total: | 13 |
| Room Type: | Bedroom 5, Office, Bonus Room, Recreation Room, Sitting Room, Media Room, Foyer, Pantry, Walk In Closet |
| Sewer: | Public Sewer |
| Special Listing Conditions: | List Broker Must Accompany |
| State Or Province: | IL |
| Tax Year: | 2025 |
| Township: | Ela |
| Water Source: | Lake Michigan |
| Actual Status: | Active |
| Water Touches: | Lot Boundary |
| Water View: | Front of Property |
| Lot Size Source: | County Records |
| Water Body Name: | LAKE ZURICH |
| Patio And Porch Features: | Patio, Porch, Deck |
| Activation Date: | 2026-09-23 |
| Additional Parcels Description: | 14184030240000, 14173010070000 |
| View: | Water |
| Waterfront Features: | Lake Front, Lake Privileges, Spring, Waterfront |
| New Construction Y/N: | Yes |
| Habitable Residence?: | Yes |
| Flood Zone: | No |
Listing Courtesy of: Coldwell Banker Realty
Listing Agent: Robbie Morrison
(847) 212-0966
Mortgage Calculator
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 Sheryl Long 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 05:26 PM - CT
Based on information submitted to the MLS GRID as of October 08, 2026 05:26 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 05:26 PM - CT


















































