This one-of-a-kind Charleston-inspired waterfront estate is perfectly positioned along the shores of Lake Wylie, tucked at the end of a quiet private drive shared by only 3 other homes and no HOA. Offering approximately 4,187 SQ FT across 3 thoughtfully designed levels, every floor features its own covered porch or patio with sweeping, year-round lake views. The home's layout is exceptionally well-suited for multi-generational living or entertaining on a grand scale. The lake-facing Great Room showcases breathtaking water views and opens to the dining area and kitchen. Renovated gourmet kitchen is beautifully appointed with Cambria quartz countertops, GE Profile appliances, a 5-burner cooktop, wall oven, custom hood, tile backsplash, and under-cabinet lighting. A formal dining room with classic wainscoting adds timeless charm. A spacious second primary suite on the main level (currently used as 2nd home office) features a walk-in closet, 2 additional storage closets, a cedar-lined closet, and a full bath. Dedicated home office boasts incredible lake views, making it ideal for remote work. The guest and theater wing also includes a new electric fireplace, new full-size windows with a stunning lake view, a wired 7.1 home theater system with built-in speakers, and two built-in refrigerators - one for beverages and one for wine. The 2nd floor is devoted to the primary suite with a cedar-lined walk-in closet, dressing area, oversized laundry room, spa like bath with heated floors, and a large private porch with unobstructed lake views. The lower level includes two bedrooms, each with its own en-suite bath (one full, one half), plus a comfortable sitting area and 2nd laundry. Designed for those who love to entertain and embrace lake life, enjoy boating, fishing, and swimming from your private dock with boat and jet ski lift, or relax on the covered dock sitting area. Soak in the sun and peaceful surroundings on the private sandy lounge area. Additional highlights include an oversized 3+ car garage with a dedicated workshop, wired for RV connection, abundant storage, parking for multiple vehicles, a simulated slate 50+ year roof, exquisite architectural details throughout, beautiful flooring, plantation shutters, and magnificent lake views. Great Palisades area location convenient to shopping, dining, and The Palisades Country Club. Thoughtfully renovated and cared for, this exceptional waterfront retreat is luxury lake living at its finest.