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!
Sold for $520,000 on 07/29/25
$520,000
554 Grande Manor Court #203, Wilmington, NC 28405
3beds
1,582sqft
Condominium
Built in 2005
-- sqft lot
$520,100 Zestimate®
$329/sqft
$2,232 Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: July 30, 2025 at 09:51am
Listed by:
Beth A Lennon 910-512-4363,
Coldwell Banker Sea Coast Advantage
Bought with:
David B Benford, 143619
Landmark Sotheby's International Realty
Source: Hive MLS,MLS#: 100499693

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: Dishwasher
Features
- Master Downstairs, Bookcases, Elevator, Ceiling Fan(s)
- Flooring: Carpet, Tile
- 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 & neighborhood
Security
- Security features: Fire Sprinkler System, Smoke Detector(s)
Location
- Region: Wilmington
- Subdivision: The Village at Mayfaire
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $8,208 annually
- 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)
- Association name: CAMS
- Association phone: 910-256-2021
Other
Other facts
- Listing terms: Cash,Conventional,VA Loan
- Road surface type: Paved
Services availability

Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.
Sell for more on Zillow
Get a free Zillow Showcase℠ listing and you could sell for .
$520,100
2% more+ $10,402
With Zillow Showcase(estimated)
$530,502