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!
Active
$2,995,000
504 N Old Rand Rd, Lake Zurich, IL 60047
5beds
5,225sqft
Single Family Residence
Built in 2024
1.02 Acres Lot
$-- Zestimate®
$573/sqft
$-- HOA
What's special
Gorgeous fireplaceExtended pierExquisite landscapingScullery pantryRemote window treatmentsStunning front elevationQuartz counters
- --
- 3,711
- views
- 330
- saves
Zillow last checked:
Listing updated:
Listed by:
Rob Morrison, SFR (847)212-0966,
Coldwell Banker Realty
Source: MRED as distributed by MLS GRID,MLS#: 12760165
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 6
- Full bathrooms: 5
- 1/2 bathrooms: 1
Rooms
- Room types: Bedroom 5, Office, Bonus Room, Recreation Room, Sitting Room, Media Room, Foyer, Pantry, Walk In Closet
Primary bedroom
- Features: Flooring (Hardwood), Window Treatments (Blinds), Bathroom (Full, Double Sink, Tub & Separate Shwr)
- Level: Second
- Area: 285 Square Feet
- Dimensions: 19X15
Bedroom 2
- Features: Flooring (Hardwood), Window Treatments (Blinds)
- Level: Second
- Area: 156 Square Feet
- Dimensions: 13X12
Bedroom 3
- Features: Flooring (Hardwood), Window Treatments (Blinds)
- Level: Second
- Area: 210 Square Feet
- Dimensions: 15X14
Bedroom 4
- Features: Flooring (Hardwood), Window Treatments (Blinds)
- Level: Second
- Area: 168 Square Feet
- Dimensions: 14X12
Bedroom 5
- Features: Flooring (Other), Window Treatments (Blinds)
- Level: Basement
- Area: 300 Square Feet
- Dimensions: 20X15
Bar entertainment
- Features: Flooring (Other)
- Level: Basement
- Area: 108 Square Feet
- Dimensions: 12X9
Bonus room
- Features: Flooring (Other)
- Level: Second
- Area: 435 Square Feet
- Dimensions: 29X15
Dining room
- Features: Flooring (Hardwood), Window Treatments (Blinds)
- Level: Main
- Area: 255 Square Feet
- Dimensions: 17X15
Family room
- Features: Flooring (Hardwood), Window Treatments (Blinds)
- Level: Main
- Area: 340 Square Feet
- Dimensions: 20X17
Foyer
- Features: Flooring (Hardwood)
- Level: Main
- Area: 110 Square Feet
- Dimensions: 11X10
Kitchen
- Features: Kitchen (Eating Area-Breakfast Bar, Eating Area-Table Space, Island, Pantry-Butler, Pantry-Closet, Pantry-Walk-in, Breakfast Room, Custom Cabinetry, Updated Kitchen), Flooring (Hardwood), Window Treatments (Blinds)
- Level: Main
- Area: 323 Square Feet
- Dimensions: 19X17
Laundry
- Features: Flooring (Hardwood), Window Treatments (Blinds)
- Level: Main
- Area: 81 Square Feet
- Dimensions: 9X9
Media room
- Features: Flooring (Other)
- Level: Basement
- Area: 399 Square Feet
- Dimensions: 21X19
Office
- Features: Flooring (Hardwood), Window Treatments (Blinds)
- Level: Main
- Area: 132 Square Feet
- Dimensions: 12X11
Pantry
- Features: Flooring (Hardwood)
- Level: Main
- Area: 35 Square Feet
- Dimensions: 7X5
Recreation room
- Features: Flooring (Other), Window Treatments (Blinds)
- Level: Basement
- Area: 156 Square Feet
- Dimensions: 13X12
Sitting room
- Features: Flooring (Hardwood), Window Treatments (Blinds)
- Level: Second
- Area: 210 Square Feet
- Dimensions: 15X14
Walk in closet
- Features: Flooring (Hardwood)
- Level: Second
- Area: 72 Square Feet
- Dimensions: 9X8
Heating
- Natural Gas, Forced Air, Sep Heating Systems - 2+, Indv Controls, Zoned
Cooling
- Central Air, Zoned
Appliances
- Included: Range, Microwave, Dishwasher, High End Refrigerator, Bar Fridge, Washer, Dryer, Disposal, Stainless Steel Appliance(s), Range Hood, Water Softener Owned, Humidifier
- Laundry: Main Level, Sink
Features
- Wet Bar, In-Law Floorplan, Built-in Features, Walk-In Closet(s), Beamed Ceilings, Open Floorplan, Pantry, Quartz Counters
- Flooring: Hardwood
- Windows: Screens, Window Treatments
- Basement: Finished,Egress Window,9 ft + pour,Rec/Family Area,Sleeping Area,Storage Space,Daylight,Full
- Attic: Interior Stair,Unfinished
- Number of fireplaces: 1
- Fireplace features: Gas Log, Gas Starter, Family Room
Interior area
- Total structure area: 0
- Total interior livable area: 5,225 sqft
Property
Parking
- Total spaces: 3
- Parking features: Asphalt, Side Driveway, Garage Door Opener, Garage, EV Ready, Yes, Garage Owned, Attached
- Attached garage spaces: 3
- Has uncovered spaces: Yes
Accessibility
- Accessibility features: No Disability Access
Features
- Stories: 2
- Patio & porch: Roof Deck, Patio, Porch, Deck
- Exterior features: Balcony, Outdoor Grill, Lighting
- Has view: Yes
- View description: Water, Front of Property
- Has water view: Yes
- Water view: Water,Front of Property
- Waterfront features: Lake Front, Lake Privileges, Spring, Waterfront
- Body of water: LAKE ZURICH
Lot
- Size: 1.02 Acres
- Dimensions: 84x500x70x534x33
- Features: Landscaped, Water Rights
Details
- Additional structures: Outdoor Kitchen
- Additional parcels included: 14184030240000,14173010070000
- Parcel number: 14173010140000
- Special conditions: List Broker Must Accompany
- Other equipment: Water-Softener Owned, Ceiling Fan(s), Sump Pump
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Farmhouse
- Property subtype: Single Family Residence
Materials
- Fiber Cement
- Foundation: Concrete Perimeter
- Roof: Asphalt
Condition
- New construction: No
- Year built: 2024
Details
- Builder model: CUSTOM
Utilities & green energy
- Electric: 200+ Amp Service
- Sewer: Public Sewer
- Water: Lake Michigan
Community & HOA
Community
- Features: Park, Lake, Water Rights, Curbs, Sidewalks, Street Paved
- Security: Security System, Fire Sprinkler System, Carbon Monoxide Detector(s)
HOA
- Services included: None
Location
- Region: Lake Zurich
Financial & listing details
- Price per square foot: $573/sqft
- Tax assessed value: $366,709
- Annual tax amount: $26,921
- Date on market: 9/23/2026
- Ownership: Fee Simple
- Has irrigation water rights: Yes
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 7/19/2023 | Sold | $697,500+0.4%$133/sqft |
Source:  MRED as distributed by MLS GRID #11780266 Report a problem | ||
| 6/11/2023 | Contingent | $695,000$133/sqft |
Source: MRED as distributed by MLS GRID #11780266 Report a problem | ||
| 6/8/2023 | Listed for sale | $695,000$133/sqft |
Source: MRED as distributed by MLS GRID #11780266 Report a problem | ||
| 5/18/2023 | Contingent | $695,000$133/sqft |
Source: MRED as distributed by MLS GRID #11780266 Report a problem | ||
| 5/15/2023 | Listed for sale | $695,000+6.9%$133/sqft |
Source: MRED as distributed by MLS GRID #11780266 Report a problem | ||
| 11/18/2022 | Sold | $650,000-7.1%$124/sqft |
Source: MRED as distributed by MLS GRID #11658666 Report a problem | ||
| 10/29/2022 | Pending sale | $699,900$134/sqft |
Source:  RE/MAX International #11658666 Report a problem | ||
| 10/28/2022 | Contingent | $699,900$134/sqft |
Source: MRED as distributed by MLS GRID #11658666 Report a problem | ||
| 10/28/2022 | Listed for sale | $699,900$134/sqft |
Source: MRED as distributed by MLS GRID #11658666 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $9,351 +6.9% | $340,902 +178.9% |
| 2023 | $8,745 +17.7% | $122,224 +10% |
| 2022 | $7,433 +3.5% | $111,161 +17.9% |
| 2021 | $7,180 +1.8% | $94,285 +2.6% |
| 2020 | $7,050 +1.6% | $91,868 +0.9% |
| 2019 | $6,941 -0.1% | $91,067 -1% |
| 2018 | $6,949 | $91,997 +1.2% |
| 2017 | $6,949 +3.1% | $90,889 +3.3% |
| 2016 | $6,743 -2% | $88,011 +5% |
| 2015 | $6,881 +5.1% | $83,828 -0.1% |
| 2014 | $6,550 +5.3% | $83,926 +4% |
| 2012 | $6,223 -0.2% | $80,691 -8.8% |
| 2011 | $6,238 +4.5% | $88,521 -3.5% |
| 2010 | $5,967 -3.8% | $91,708 -11.2% |
| 2009 | $6,203 +2% | $103,314 +2.1% |
| 2008 | $6,080 +21.4% | $101,219 +2.1% |
| 2006 | $5,010 -0.1% | $99,135 |
| 2005 | $5,014 -7.3% | -- |
| 2004 | $5,407 +4.3% | -- |
| 2003 | $5,184 +6.8% | -- |
| 2002 | $4,852 +2% | -- |
| 2001 | $4,755 +10.7% | $65,692 +2.7% |
| 2000 | $4,297 | $63,978 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 60047
Nearby schools
Schools provided by the listing agent
- Elementary: May Whitney Elementary School
- Middle: Lake Zurich Middle - N Campus
- High: Lake Zurich High School
- District: 95
Source: MRED as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Similar homes
- $3,100,0005 bd7 ba7.6k sqft65 Round Barn Rd, Barrington Hills, IL 60010Active
MLS ID #12786032, Heidi Seagren, CRS, Compass. MRED as distributed by MLS GRID - $1,499,9006 bd8 ba7.5k sqft6548 Stockbridge Ln, Long Grove, IL 60047Active
MLS ID #12782887, Keith Brand, Berkshire Hathaway HomeServices Chicago. MRED as distributed by MLS GRID - $2,750,0005 bd6 ba6k sqft14 Carnoustie Ln, Inverness, IL 60067Active
MLS ID #12769832, Monica Balder, Baird & Warner. MRED as distributed by MLS GRID - $1,599,0006 bd5 ba5.6k sqft3995 Orchard Ln, Long Grove, IL 60047Active
MLS ID #12783948, Jane Lee, RE/MAX Top Performers. MRED as distributed by MLS GRID
