- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes





Street View
$2,995,000
Monthly Est:$14,907
4 Beds
- 6 Baths
5 full baths + 1 half bath
5,225sqft
504 N Old Rand Rd, Lake Zurich, IL 60047
$2,995,000
$14,907/moEst:
Get Pre-Approved
Single Family Residence
Built in 2024
$-- HOA
1.02 acres lot
$573/sq.ft
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!
- Houzeo last checked: 4 minutes ago
- Listing updated: September 29, 2026 at 5:06 am
- Listing Provided by: Robbie Morrison (847) 212-0966 | Coldwell Banker Realty (847) 222-5000
- Source: MRED MLS-IL as distributed by MLS GRID | MLS#: 12760165

Property Details
Status
Active
Type
Single Family Residence
No. of Stories
-
County
City
Neighborhood
--
Year Built
2024
HOA Fees
-
Finished Area
5,225 sqft
Lot Size
1.02 acres lot
Basement Area
- sqft
MLS Name
MRED MLS
MLS Number
12760165
MLS Status
Active

Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 6
Bedroom 5
Level: Basement
Area: 300.00 Square Feet
Dimensions: 20X15
Office
Level: Main
Area: 132.00 Square Feet
Dimensions: 12X11
Bonus Room
Level: Second
Area: 435.00 Square Feet
Dimensions: 29X15
Recreation Room
Level: Basement
Area: 156.00 Square Feet
Dimensions: 13X12
Sitting Room
Level: Second
Area: 210.00 Square Feet
Dimensions: 15X14
Media Room
Level: Basement
Area: 399.00 Square Feet
Dimensions: 21X19
Foyer
Level: Main
Area: 110.00 Square Feet
Dimensions: 11X10
Pantry
Level: Main
Area: 35.00 Square Feet
Dimensions: 7X5
Walk In Closet
Level: Second
Area: 72.00 Square Feet
Dimensions: 9X8
Bar/Entertainment
Level: Basement
Area: 108.00 Square Feet
Dimensions: 12X9
Bedroom 2
Level: Second
Area: 156.00 Square Feet
Dimensions: 13X12
Bedroom 3
Level: Second
Area: 210.00 Square Feet
Dimensions: 15X14
Bedroom 4
Level: Second
Area: 168.00 Square Feet
Dimensions: 14X12
Dining Room
Level: Main
Area: 255.00 Square Feet
Dimensions: 17X15
Family Room
Level: Main
Area: 340.00 Square Feet
Dimensions: 20X17
Kitchen
Level: Main
Area: 323.00 Square Feet
Dimensions: 19X17
Laundry
Level: Main
Area: 81.00 Square Feet
Dimensions: 9X9
Master Bedroom
Level: Second
Area: 285.00 Square Feet
Dimensions: 19X15
Interior
Exterior Features
Balcony, Roof Deck, Outdoor Grill, Lighting
Sewer
Public Sewer
Interior Features
Wet Bar, In Law Floorplan, Built In Features, Walk In Closet(s), Beamed Ceilings, Open Floorplan, Pantry, Quartz Counters
Window Features
Screens, Window Treatments
Appliances
Range, Microwave, Dishwasher, High End Refrigerator, Bar Fridge, Washer, Dryer, Disposal, Stainless Steel Appliance(s), Range Hood, Water Softener Owned, Humidifier
Flooring
Hardwood
Heating
Natural Gas, Forced Air, Sep Heating Systems 2+, Indv Controls, Zoned
Cooling
Central Air, Zoned
Construction
Year Built
Year Built: 2024
Home type
Single Family Residence
Foundation Details
Concrete Perimeter
Architectural Style
Farmhouse
Construction Materials
Fiber Cement
Roof
Asphalt
Utilities & Energy
Electric
200+ Amp Service
Fireplace Features
Gas Log, Gas Starter
Basement
Finished, Egress Window, 9 Ft + Pour, Rec/family Area, Sleeping Area, Storage Space, Daylight, Full
Parking Features
Asphalt, Side Driveway, Garage Door Opener, Garage, Ev Ready, Yes, Garage Owned, Attached
Water Source
Lake Michigan
Laundry Features
Main Level, Sink
Other Features
Community Features
Park, Lake, Water Rights, Curbs, Sidewalks, Street Paved
Patio And Porch Features
Patio, Porch, Deck
Lot Features
Landscaped, Water Rights
Price History
| Date | Event | Price |
|---|---|---|
09/23/2026 Source: | Listed for Sale | $2,995,000 +330.94% $573/sqft |
07/20/2023 Source: | Price Decreased | $695,000 -0.36% $133/sqft |
07/20/2023 Source: | Price Increased | $697,500 +7.31% $133/sqft |
11/18/2022 Source: | Price Decreased | $650,000 -7.13% $124/sqft |
11/18/2022 Source: | Sold | $699,900 $134/sqft |
Nearby Homes
Find Homes by Property Features in Lake Zurich, IL
Nearby New Homes For Sale
This representation is based in whole or in part on data supplied by Midwest Real Estate Data, LLC through Nov 12, 2026, 02:30PM. Midwest Real Estate Data, LLC does not guarantee nor is it in any way responsible for its accuracy. Data maintained by Midwest Real Estate Data LLC may not reflect all real estate activity in the market. Based on information submitted to the MLS GRID as of Nov 12, 2026, 02:30PM. All data is obtained from various sources and has not been, and will not be, 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. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. Some IDX listings have been excluded from this website. Information is provided exclusively for consumers’ personal non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed by MLS GRID, MRED or Houzeo. 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. Properties displayed may be listed or sold by various participants in the MLS, Listings courtesy of MRED as distributed by MLS GRID. ©2026 Midwest Real Estate Data LLC. All Rights Reserved
Advertising Broker: Jorge Romero | Realty One Group Inc.









