Wow-this stunning waterfront home with a rare double primary suite layout offers exceptional flexibility for multi-generational living and is nestled in one of the area's most sought-after communities, known for its beautiful tree-lined streets and resort-style amenities. From the moment you arrive, the home's inviting curb appeal and expansive covered front porch-complete with ceiling fans-set the tone for comfort and charm. Inside, you're welcomed by two versatile flex spaces at the front of the home, ideal for a home office, music room, reading lounge, or sitting area, perfectly positioned across from the formal dining room. The spacious family room features a cozy fireplace and flows into the kitchen and breakfast area, creating an open layout perfect for both everyday living and entertaining. Large windows showcase breathtaking views of the backyard oasis, bringing in natural light and serene water views. The main-level primary suite is generously sized and features a tray ceiling along with an updated en-suite bath, complete with a double vanity, large walk-in shower, and linen closet. Upstairs, a second primary suite with a private full bathroom provides an ideal setup for guests or extended family. You'll also find two additional bedrooms and an oversized fifth bedroom or bonus room-perfect for a media room, playroom, or fitness space. Step outside to your private backyard retreat, where an extended patio with a retractable awning invites you to relax or entertain while enjoying peaceful views of the pond and its elegant fountain-a truly rare and tranquil setting. This exceptional community enhances your lifestyle with multiple stocked ponds, a community pool, park, and ball courts-all surrounded by picturesque scenery. Conveniently located in Indian Trail in Union County, this home offers easy access to shopping, dining, and easy access to both the Monroe Bypass and I485, combining peaceful living with everyday convenience.