ONE-OF-A-KIND WATERFRONT RETREAT ON 2 ACRES with OVER 4,900 SQFT OF HEATED LIVING SPACE, FULLY FINISHED DAYLIGHT BASEMENT, and NO HOA!! This CUSTOM-BUILT BRICK HOME offers DEEDED WATER ACCESS, STUNNING VIEWS, and the kind of SPACE and FLEXIBILITY buyers are searching for!! ALL within the CORINTH HOLDERS HIGH SCHOOL DISTRICT and a convenient commute to RALEIGH, FLOWERS PLANTATION, PUBLIX, and HARRIS TEETER. Step inside to find REAL HICKORY HARDWOOD FLOORS, TILE, and a DRAMATIC FAMILY ROOM with SOARING CEILINGS and PINE ACCENTS. Architectural details throughout include DECORATIVE COLUMNS, TRANSOM WINDOWS, SKYLIGHTS WITH BLINDS, and custom trim work that adds character without overwhelming the space. The KITCHEN is designed for both everyday living and entertaining featuring a GRANITE ISLAND, WALL OVEN, COMMERCIAL-GRADE VENT HOOD with RANGE, HICKORY CABINETS, PANTRY, and INCLUDED APPLIANCES. Multiple dining areas including a FORMAL DINING ROOM, BREAKFAST AREA, and SUNROOM WITH WATER VIEWS give you flexibility for hosting. The MAIN-LEVEL OWNER'S SUITE is a true retreat with a FIREPLACE, PRIVATE VERANDA overlooking the water, WALK-IN CLOSET with wood shelving, and a SPA-STYLE BATH featuring a FREESTANDING TUB, DOUBLE-HEADED SHOWER, and DUAL VANITY. Upstairs offers a LOFT, FULL BATH, and FLEX ROOMS that can function as additional bedrooms, office space, or bonus areas. The FULLY FINISHED DAYLIGHT BASEMENT adds significant value and versatility with nearly 2,000 SQFT of additional heated space--complete with a SECOND KITCHEN, LIVING AREA, FIREPLACE, BEDROOMS, FLEX ROOMS, and both INTERIOR & EXTERIOR ACCESS that is ideal for MULTI-GENERATIONAL LIVING, GUEST SPACE, or ENTERTAINING. Outdoor living is just as impressive with COVERED PORCHES, WRAP-AROUND PATIO, and PROFESSIONALLY LANDSCAPED GROUNDS designed to take full advantage of the WATERFRONT SETTING with PLENTY OF ROOM TO ADD A POOL if desired. RARE opportunity to own a PRIVATE, CUSTOM WATERFRONT PROPERTY with SPACE, FUNCTION, and FLEXIBILITY that is hard to find in today's market.