- 0
- 3
- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
24 hours ago
No HOA
Street View
$2,995,000
Monthly Est:$14,907
4 Beds
6 Baths5 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 lea...
Continue Reading- Houzeo last checked: 2 hours ago
- Listing updated: September 23, 2026 at 1:32 pm
- Listing Provided by: Robbie Morrison (847) 212-0966 | Coldwell Banker Realty (847) 222-5000
- Source: MRED MLS-IL | 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
New
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
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
Interior Features
Wet Bar, In Law Floorplan, Built In Features, Walk In Closet(s), Beamed Ceilings, Open Floorplan, Pantry, Quartz Counters
Appliances
Range, Microwave, Dishwasher, High End Refrigerator, Bar Fridge, Washer, Dryer, Disposal, Stainless Steel Appliance(s), Range Hood, Water Softener Owned, Humidifier
Window Features
Screens, Window Treatments
Cooling
Central Air, Zoned
Flooring
Hardwood
Exterior Features
Balcony, Roof Deck, Outdoor Grill, Lighting
Sewer
Public Sewer
Heating
Natural Gas, Forced Air, Sep Heating Systems 2+, Indv Controls, Zoned
Construction
Year Built
Year Built: 2024
Home type
Single Family Residence
Foundation Details
Concrete Perimeter
Roof
Asphalt
Architectural Style
Farmhouse
Construction Materials
Fiber Cement
Utilities & Energy
Basement
Finished, Egress Window, 9 Ft + Pour, Rec/family Area, Sleeping Area, Storage Space, Daylight, Full
Laundry Features
Main Level, Sink
Fireplace Features
Gas Log, Gas Starter
Electric
200+ Amp Service
Parking Features
Asphalt, Side Driveway, Garage Door Opener, Garage, Ev Ready, Yes, Garage Owned, Attached
Water Source
Lake Michigan
Other Features
Community Features
Park, Lake, Water Rights, Curbs, Sidewalks, Street Paved
Lot Features
Landscaped, Water Rights
Patio And Porch Features
Patio, Porch, Deck
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 Sep 24, 2026, 11:00AM. 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 Sep 24, 2026, 11:00AM. 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. 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.
