Stunning waterfront retreat in the desirable Frierson Subdivision offering six bedrooms, four-and-a-half baths, and exceptional space for entertaining, relaxing, and enjoying breathtaking sunset views. Ideally located near Boat Church, this beautifully maintained brick home combines timeless charm with thoughtful upgrades throughout. Step inside to find engineered hardwood flooring, smooth ceilings, plantation shutters, and an inviting layout designed for both everyday living and hosting guests. The gourmet kitchen features custom walnut cabinetry, abundant storage, electric cooktop range, dishwasher, microwave, refrigerator, and spacious prep areas perfect for gathering with family and friends.The bright sunroom overlooks the water and opens to an expansive composite deck with both open-air and screened-in spaces, creating the ultimate outdoor entertaining experience. The beautifully landscaped yard is enhanced with mature fruit trees and two waterside storage buildings for added convenience. The fully finished basement level offers incredible flexibility with a second kitchen, dining area, half bath, and additional storage. A separate waterside-access room is ideal for a tackle room, hobby space, workshop, or additional recreational use. Upstairs, a spacious man cave area is flanked by two additional rooms that would make excellent offices, nurseries, craft rooms, or flex spaces. The oversized garage, abundant closet space, and walk-in attic spanning the length of the home provide exceptional storage opportunities. Additional highlights include a full-house Generac generator, composite waterfront decking, custom finishes throughout, and a peaceful setting perfect for lake living and entertaining alike.This rare waterfront gem offers the perfect blend of comfort, functionality, and scenic beauty.