Agent profile image in chat bubble
Agent profile image in chat header

IDX Support

sales rep | Brivity IDX

Agent profile image in message

504 N Old Rand Rd , Lake Zurich, IL 60047
$2,995,000
Est. Payment: $16,344.94/mo
4 Bed
6 Bath
5225 Sqft
1.02 Acres
Status: active | Days on site: 7
Get Pre-Qualified
3755 - 60228
By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from IDX Support, its affiliates, and agents or vendors acting on their behalf. These communications may be delivered using an automatic telephone dialing system or by using an artificial or prerecorded voice. Message and data rates may apply. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms of Use and Privacy Policy.

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

Highlights

Listed by Robbie Morrison , 847-212-0966 Coldwell Banker Realty , 847-222-5000. Midwest Real Estate Data mls logo

Property Type

Residential

Lot/Acreage
1.02

Year Built

2024

County

Lake

Area

Hawthorn Woods / Lake Zurich / Kildeer / Long Grove

School District

95

Listing ID

12760165

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:4
  • ▪ Bathrooms:6
  • ▪ Full Bathrooms:5
  • ▪ 1/2 Bathrooms:1
Appliances:Range, Microwave, Dishwasher, High End Refrigerator, Bar Fridge, Washer, Dryer, Disposal, Stainless Steel Appliance(s), Range Hood, Water Softener Owned, Humidifier, Water-Softener Owned,Security System,Fire Sprinklers,CO Detectors,Ceiling Fan(s),Sump Pump
Air Cond:Central Air,Zoned
Fireplaces:Gas Log,Gas Starter
Floor:Hardwood
Basement:Finished,Egress Window,9 ft + pour,Rec/Family Area,Sleeping Area,Storage Space,Daylight,Full
Other:
  • ▪ Additional:Wet Bar, In-Law Floorplan, Built-in Features, Walk-In Closet(s), Beamed Ceilings, Open Floorplan, Pantry, Quartz Counters
Water:Lake Michigan

Exterior Features

Lot:Landscaped,Water Rights,Lake Front,Lake Privileges,Spring,Waterfront
Lot Dimensions:84x500x70x534x33
Garage Capacity:3
Roof:Asphalt
Others:
  • ▪ Additional:Balcony, Roof Deck, Outdoor Grill, Lighting
Sewer:Public Sewer
Parking Features:Asphalt,Side Driveway,Garage Door Opener,Garage,EV Ready,Yes,Garage Owned,Attached
Principal Interest
$16,345
Taxes
$2,243

Home Price

$2,995,000

Loan Details

30 yrs
7.25%

Down Payment

20%
$599,000
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$16,344.94

Principal

Taxes

Principal Taxes HOA Total
Monthly $16,344.94 $2,243.49 $0.00 $18,588.44
Yearly $196,139.32 $26,921.90 $0.00 $223,061.22
Total $5,884,179.72 $807,657.00 $0.00 $6,691,836.72
Lender profile image
Master Chief
Lender
GET PRE-QUALIFIED

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Oct 2026

Average Price

All Price Ranges
N/A
Oct 2026

Average Days on Market

All Price Ranges
N/A
Oct 2026
Market insight data is pulled from the same city as the listing being viewed (Lake Zurich, IL).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

Based on information submitted to the MRED as of the date listed below. All data is obtained from various sources and has not been, and will not be, verified by broker or MRED. MRED 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. IDX information is provided exclusively for consumers' personal non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed by MTP or MRED. The use of the MRED 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.

Based on information submitted to the MLS GRID as of the date listed below. All data is obtained from various sources and may not have been 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. IDX information is provided exclusively for consumers' personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that 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. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability. Some listings have been excluded from this website.

IDX service by Blueroof 360

Data last updated: 2026-10-27T14:56:06.000Z

© 2026 Midwest Real Estate Data

MLS Logo - Midwest Real Estate Data