Step into the grand foyer and be welcomed by formal living and dining rooms, both graced with rich architectural details and one of the home's 3 fireplaces. The large, light-filled rooms throughout offer comfort and flexibility, including a main-level primary suite with a completely remodeled spa-like bath. The kitchen is beautifully renovated featuring stunning new countertops. New carpet has been installed as well as many new light fixtures. Much of the interior has been freshly painted. The expansive finished basement is an entertainer's dream or perfect for multi-generational living. It includes a second kitchen, a large family/media room, a fitness room, a sixth bedroom or study, a ground-floor bar, and a half bath that could easily be converted into a full in-law suite with the addition of a shower. A separate lower-level garage-part of the home's rare four-car garage layout-includes a shop area with built-in workbench, ideal for hobbyists or additional storage needs. Enjoy the best of outdoor living with a brand-new deck overlooking a private backyard oasis featuring a stone patio with built-in gas grill, a charming gazebo nestled in the woods, and a tranquil creek at the rear of the property. With no chance of future development behind the home, your peaceful, wooded view is protected for years to come. Located in highly sought-after Sheffield Manor, residents enjoy a fabulous lifestyle with access to a clubhouse, pool, pickleball and tennis courts-all with low HOA fees and just minutes from North Raleigh's premier shopping, dining, and top-rated schools.