Luxury Living in the Heart of Mayfaire
Welcome to The Terrace—one of the most popular floor plans in the Village at Mayfaire, True to its name, this beautifully maintained condo features a signature wraparound covered terrace, offering a peaceful retreat to enjoy morning breezes, the scent of salt air, and views of the Village's lush, manicured grounds.
This unit is located on the 2nd floor with elevator access in a quiet part of the neighborhood. It includes 3 bedrooms, 2 full bathrooms and a private garage with keypad entry. Travertine tile flows through the main living spaces, while plush Karastan carpet with upgraded padding softens each bedroom. Tasteful upgrades include custom shades and Hunter Douglas wood blinds, custom built-in bookcase and window seat, KitchenAid three-rack dishwasher, Whirlpool refrigerator (2021), and UV-protective window film complement the neutral, open-concept interior.
The Village at Mayfaire offers an exceptional lifestyle with access to a resort-style pool, tennis courts, clubhouse, car wash station, and walking paths. Stroll to Mayfaire Town Center's boutiques, restaurants, and cinema, or bike to Wrightsville Beach in minutes—this location is truly unbeatable and perfect for a low maintenance coastal retreat or second home.
Don't miss this rare opportunity to own one of the most desirable condos in Mayfaire. Schedule your showing today!
For sale
$549,000
554 Grande Manor Court #203, Wilmington, NC 28405
3beds
1,582sqft
Est.:
Condominium
Built in 2005
-- sqft lot
$548,500 Zestimate®
$347/sqft
$684/mo HOA
What's special
- 20 days
- on Zillow |
- 411 |
- 16 |
Zillow last checked: 7 hours ago
Listing updated: April 09, 2025 at 12:15am
Listed by:
Beth A Lennon 910-512-4363,
Coldwell Banker Sea Coast Advantage
Source: Hive MLS,MLS#: 100499693

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Primary bedroom
- Area: 208
- Dimensions: 13.00 x 16.00
Bedroom 2
- Area: 130
- Dimensions: 10.00 x 13.00
Bedroom 3
- Area: 143
- Dimensions: 11.00 x 13.00
Dining room
- Area: 132
- Dimensions: 11.00 x 12.00
Kitchen
- Area: 143
- Dimensions: 11.00 x 13.00
Laundry
- Area: 42
- Dimensions: 6.00 x 7.00
Living room
- Area: 280
- Dimensions: 14.00 x 20.00
Other
- Description: Foyer
- Area: 60
- Dimensions: 5.00 x 12.00
Heating
- Heat Pump, Electric
Cooling
- Central Air
Appliances
- Included: Stove/Oven - Electric, Dishwasher
- Laundry: Inside
Features
- Bookcases, Elevator, Master Downstairs, 9Ft+ Ceilings, Ceiling Fan(s), Walk-In Closet(s)
- Flooring: Carpet, Tile
- Windows: Blinds
- Has fireplace: No
- Fireplace features: None
Interior area
- Total structure area: 1,582
- Total interior livable area: 1,582 sqft
Property
Parking
- Total spaces: 1
- Parking features: Parking Lot, On Street, Detached, Additional Parking, Concrete, Paved
- Has uncovered spaces: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered, Porch
- Fencing: None
Details
- Parcel number: R05000003122147
- Zoning: MX
Construction
Type & style
- Home type: Condo
- Property subtype: Condominium
Materials
- Composition, Brick Veneer, Wood Frame
- Foundation: Slab
- Roof: Architectural Shingle
Condition
- New construction: No
- Year built: 2005
Utilities & green energy
- Sewer: Municipal Sewer
- Water: Public
- Utilities for property: Natural Gas Connected
Community & HOA
Community
- Security: Smoke Detector(s), Fire Sprinkler System
- Subdivision: The Village at Mayfaire
HOA
- Has HOA: Yes
- Amenities included: Clubhouse, Pool, Fitness Center, Game Room, Maint - Comm Areas, Maintenance Grounds, Maintenance Structure, Management, Master Insure, Meeting Room, Party Room, Pest Control, Sidewalk, Street Lights, Tennis Court(s)
- HOA fee: $8,208 annually
- HOA name: CAMS
- HOA phone: 910-256-2021
Location
- Region: Wilmington
Financial & listing details
- Price per square foot: $347/sqft
- Tax assessed value: $330,200
- Annual tax amount: $2,872
- Date on market: 4/9/2025
- Listing terms: Cash,Conventional,VA Loan
- Road surface type: Paved
- Loading
- Loading