Prepare to be captivated by this extraordinary modern farmhouse overflowing with undeniable character, impeccable lake life, and timeless design, all situated on over an acre of scenic waterfront property on Lake Hartwell with a 4 car garage, 2 combined residential areas, and two kitchens! From the moment you arrive, the home's cedar shaker and stacked stone accents along with the carriage-style four-car garage make a striking impression. A flagstone-covered front porch sets the tone for the warmth and sophistication that continues throughout. Step inside to a grand vaulted great room featuring statement cedar columns, rustic hardwoods, and custom built-ins flanking a classic fireplace, all framed by a breathtaking wall of windows. The open concept family and dining areas provide the perfect backdrop for both entertaining and everyday comfort. At the heart of the home, the chef's kitchen stuns with a massive solid wood island, lighted glass display cabinets on each end, farmhouse sink, gas range with ship-lap overhead vent hood, beveled subway tile backsplash, warming drawer, and updated stainless steel appliances. A butler's pantry complete with wine rack, wet bar, and barn doors that add the perfect finishing touch. The main-level primary suite is a private haven with double walk-in closets, split vanities, a claw-foot soaking tub, frame-less walk-in shower, and private water closet. An additional bedroom and full bath on the main level make it ideal for guests or multi-generational living. Upstairs, a versatile loft space offers endless options as an additional bedroom, game room, home office, or creative studio. The oversized laundry room with charming brick floors is perfect for customizing a stylish mudroom. A rear stairwell leads to a half bath and the attached garage, which includes a fully equipped second residence with vaulted beamed ceiling, a second full kitchen with mosaic tile backsplash, two bedrooms, and a full bathroom. Additional highlights include a workshop with a commercial-grade ice machine, updated light fixtures blending industrial and antique styles, and an abundance of storage throughout. The attention to detail is an understatement! The expansive backyard offers privacy, plenty of space for outdoor living, and a private boat dock with covered slip as your gateway to the best of Lake Hartwell living. This is a home with undeniable charm, craftsmanship, and a layout that delivers space, function, and beauty in equal measure. Offering a truly desirable lifestyle, it's a place you'll be proud to call home. Don't miss your opportunity to own this one-of-a-kind lakefront retreat and schedule your private showing today!