Timeless Charleston charm meets modern living in this beautifully maintained home tucked within the highly sought-after Parkside at Mayfaire community. Built in 2004, this spacious residence offers nearly 3, 500 hsf of thoughtfully designed living space — including a 537-square-foot detached apartment above the garage with a private entrance, perfect for multi-generational living, a home office, or rental income opportunity. Step inside to discover double front porches, real hardwood floors throughout, and an inviting open-concept layout ideal for entertaining. The chef's kitchen is equipped with granite countertops, a Viking gas range, wet bar, and wine cooler, all flowing seamlessly into the main living and dining spaces. The first-floor suite provides convenience and privacy with its own ensuite bath and custom closet. Upstairs, two ensuite guest bedrooms and a treehouse-like primary suite featuring a spa-inspired bathroom, custom walk-in closet, and private balcony access — the perfect retreat for morning coffee or evening relaxation. The apartment above the garage offers a full kitchen, living area, bedroom, and bathroom, all finished with a modern, elevated design and washer/dryer hookups — ideal for guests, workspace, or an income-producing rental. Additional Highlights: Encapsulated crawl space & newer insulation Improved HVAC systems (2022 - 2024) New roof (2024) Rear-load garage with fully fenced yard Flexible, carpeted walk-in attic (easily finished for extra space) 4 bedrooms | 4.5 baths Main house + 1 bedroom | 1bath apartment Total heated square feet: 3, 491 (Main house 2, 956 + Apartment 537) Prime location just minutes to Mayfaire Town Center, Wrightsville Beach, and Wilmington's best dining, shopping, and coastal amenities. Low HOA, Pristine Community, No Flood zone.