For Sale
No HOANo HOA
Single family home for sale at 504 N Old Rand Rd, Lake Zurich, IL 60047 | MLS# 12760165 | Listing updated on 2026-09-29
Photo 1 of Single family home for sale at 504 N Old Rand Rd, Lake Zurich, IL 60047 | MLS# 12760165 | Listing updated on 2026-09-29
Photo 2 of Single family home for sale at 504 N Old Rand Rd, Lake Zurich, IL 60047 | MLS# 12760165 | Listing updated on 2026-09-29
Photo 3 of Single family home for sale at 504 N Old Rand Rd, Lake Zurich, IL 60047 | MLS# 12760165 | Listing updated on 2026-09-29
Photo 4 of Single family home for sale at 504 N Old Rand Rd, Lake Zurich, IL 60047 | MLS# 12760165 | Listing updated on 2026-09-29
47+
Beds Icon

Street View

$2,995,000

Monthly Est:$14,907

  • Beds Icon4 Beds
  • Beds Icon
    6 Baths
  • Beds Icon5,225sqft

504 N Old Rand Rd, Lake Zurich, IL 60047

$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 MRED MLS-IL as distributed by MLS GRID

Property Details

  • Status

    Active

  • Type

    Single Family Residence

  • No. of Stories

    -

  • County

    Lake County

  • City

    Lake Zurich

  • 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!

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

DateEventPrice

09/23/2026

Source: mls_logoMRED MLS-IL #MRD12760165

Listed for Sale

$2,995,000 +330.94%

$573/sqft

07/20/2023

Source: mls_logoMRED MLS-IL #MRD11780266

Price Decreased

$695,000 -0.36%

$133/sqft

07/20/2023

Source: mls_logoMRED MLS-IL as distributed by MLS GRID #MRD11780266

Price Increased

$697,500 +7.31%

$133/sqft

11/18/2022

Source: mls_logoMRED MLS-IL as distributed by MLS GRID #MRD11658666

Price Decreased

$650,000 -7.13%

$124/sqft

11/18/2022

Source: mls_logoMRED MLS-IL #MRD11658666

Sold

$699,900

$134/sqft

Nearby Homes

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.

Skip to Main Content