Property Details

Start of property details

Share this property:
504 N Old Rand Road
Lake Zurich, IL 60047
FOR SALE · Active
$2,995,000
4
Beds
6
Baths
3
Garage
1.02
Acres
2024
Yr. Built
MLS# 12760165
Cumulative Days on Market: 44 · Includes prior listings · Currently listed since 09/23/26 · Data provided by the MLS.

Property Description

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 dining area with sliding-door access to a patio featuring an outdoor bar and built-in grill. Tandem to the dining area is a gorgeous all-season room with floor-to-ceiling windows and side-door access to the front porch. The main floor also showcases 6" wide-plank floors throughout, a gorgeous powder room with trendy wallpaper, and the most incredible laundry / mudroom outfitted in a deep green cabinetry selection, phenomenal backsplash finishes, and a locker system equipped with a quartz bench. The second floor is just as impressive, with 4 spacious suites, each with hardwood floors throughout. 1 of 4 suites is the primary, with intentional placement at the front of the home to capitalize on the water view while incorporating an incredible secondary office / sitting room, private balcony, custom walk-in closet with organizers, and built-in dresser. The primary spa-like bathroom showcases double vanities, a soaking tub, a remarkable shower with rain features, and phenomenal tile selections. The remaining 3 suites are each finished with walk-in closets and private bathrooms showcasing a single vanity and shower. Second floor also offers the ability to accommodate a 5th bedroom if desired with access from the main hallway and private access from a staircase that leads from the garage. Fully finished lower level ideal for game day with indestructible epoxy floors, exposed ceilings, media area, wet bar, potential gym, 5th bedroom, and a full bathroom with vanity and shower. 3-car attached side-load garage! This is more than a custom home. It is a statement on the water, where architectural vision meets extraordinary craftsmanship, where luxury meets lifestyle, and where every day feels connected to the lake. Beyond the residence, the lifestyle continues. Swim, fish, water sky, boat and enjoy sidewalks that lead to the new Life Time Fitness Club, restaurants, and Breezewald Park with beachside dining, a playground, and entertainment!

Property Highlights

Property Type
Residential
Architectural Style
Farmhouse
Local Property Type
Detached Single
Bedrooms
4
Total Bathrooms
6
Living Area
5,225
Price / Sqft
$573
Acres
1.02
Year Built
2024
Cumulative Days on Market
44

Location

Area
Hawthorn Woods / Lake Zurich / Kildeer / Long Grove
City/Township
Lake Zurich
Waterfront
Yes
View
Water
County
Lake

Lake/Waterfront Information

Water Body Name
LAKE ZURICH
Waterfront Features
Lake Front, Lake Privileges, Spring, Waterfront

Property Details

Price
$2,995,000
Local Property Type
Detached Single
Property Type
Residential

Community

Community Features
Park, Lake, Water Rights, Curbs, Sidewalks, Street Paved

Local Schools

Elementary School
May Whitney Elementary School
Middle School
Lake Zurich Middle - N Campus
High School
Lake Zurich High School
School District
95

Interior Features

Bedrooms and Bathrooms

Total Bathrooms
6
Full Bathrooms
5
1/2 Bathrooms
1
Bedrooms
4

Rooms and Basement

Total Rooms
13
Basement Features
Finished, Egress Window, 9 ft + pour, Rec/Family Area, Sleeping Area, Storage Space, Daylight, Full

Area and Spaces

Living Area
5,225

Appliances

Appliances
Range, Microwave, Dishwasher, High End Refrigerator, Bar Fridge, Washer, Dryer, Disposal, Stainless Steel Appliance(s), Range Hood, Water Softener Owned, Humidifier

Interior Features

Interior Features
Wet Bar, In-Law Floorplan, Built-in Features, Walk-In Closet(s), Beamed Ceilings, Open Floorplan, Pantry, Quartz Counters
Flooring
Hardwood
Laundry Features
Main Level, Sink
Window Features
Screens, Window Treatments
Electic
200+ Amp Service
Fireplace Features
Gas Log, Gas Starter

Heating and Cooling

Heating Features
Natural Gas, Forced Air, Sep Heating Systems - 2+, Indv Controls, Zoned
Fireplaces
1

Building Details

Construction

Architectural Style
Farmhouse
Model
CUSTOM
Year Built
2024
Foundations
Concrete Perimeter

Materials

Construction Materials
Fiber Cement
Roof
Asphalt

Terms

Terms

Ownership
Fee Simple
Special Conditions
List Broker Must Accompany
Cumulative Days on Market
44

Taxes

Tax

Tax (Annual)
$26,921.90

HOA

Association Fee Includes
None

Heating, Cooling & Utilities

Cooling Features
Central Air, Zoned

Utilities

Sewer
Public Sewer
Water Source
Lake Michigan

Lot

Acres
1.02
Lot Dimensions
84x500x70x534x33
Lot Features
Landscaped, Water Rights

Exterior Features

Exterior Features
Balcony, Roof Deck, Outdoor Grill, Lighting
Patio And Porch Features
Patio, Porch, Deck

Parking

Total Parking Spaces
3
Garage Capacity
3
Parking Features
Asphalt, Side Driveway, Garage Door Opener, Garage, EV Ready, Yes, Garage Owned, Attached
Listed by Coldwell Banker Realty, (847) 212-0966
Listing Data last updated 11/05/2026 07:20 pm
Get a Link to this Property: Copy To Clipboard
QR Code link to this property

Phone:
Connect with:

Payment Calculator

per month. fixed. % interest.
$
%
$
%
Principal & Interest
+ Home Insurance
+ Property Tax
+ HOA Fees
per month
Total interest paid over s will be:
All estimates and provided for informational purposes only. Actual amounts may vary. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. Information, rates, programs and loan scenarios shown are for example only as of 6-Nov-2026 and are subject to change without notice. Interest rates provided by the St. Louis Federal Reserve Economic Data (FRED). All products are subject to credit and property approval. Not all products are available in all states or for all loan amounts. Other restrictions and limitations apply. Contact your preferred lender for the pricing associated with your specific transaction. Calculations are generated by Open Source mortgage calculation software tools using common mathematical formulas. All calculations should be independently verified.
Get Walk Score Content

Property History

5 days ago
Property information last updated
43 days ago
Status Active. This is the date the listing was placed on market.
Cumulative Days on Market: 44 days (includes prior listings) · Currently listed since September 23, 2026. Data provided by the MLS.

Similar Properties