Experience unparalleled lakefront living with this exceptional estate, offering 933 feet of pristine frontage on the picturesque Duncan Lake in award winning Caledonia schools. Just a short drive from downtown Grand Rapids, this home is nestled on a sprawling 5.7-acre private oasis. This smart home features a Control-4 system, automatic shades throughout, ceiling concealed retractable TV's in the living room/primary suite and much more.The main floor boasts a spacious gathering room with breathtaking lake views, alongside a cozy den and family room complete with a theater screen. The immaculate chef's kitchen, featuring a charming breakfast nook, is perfect for culinary enthusiasts.Sub zero paneled refrigerator, two dishwasher options, a wet bar, dual islands and a double oven are a few notable kitchen features. The breathtaking wood paneled executive office (or potential 8th bedroom) is conveniently located on the main level. Upstairs, the master suite provides a luxurious retreat with unbelievable views, complete with separate walk in closets and a hotel like bathroom with soaking tub. The upper level has two additional bedrooms and a private bath. The lower level is an entertainer's dream with a secondary kitchen, family room, game room, two bedrooms, and a large laundry area with a full bath complete with a curved zero step shower. Connected by an indoor corridor you will find two heated, insulated barns (40x64 and 30x36) equipped with a generator, air compressor, and reverse osmosis water system for car washing. A separate two-bedroom in-law suite apartment boasts the third laundry room, 2 bedrooms, a full bathroom and kitchen/living room. The electric stair chair provides an alternative method of access to the in-law apartment in addition to the staircase. The outdoor space is equally impressive, with no detail missed! Two composite decks and an expansive patio leading to a stunning in-ground pool complete with a slide, diving board, and a pool house with a full walk-up bar, storage room and half b