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
$521,500 Zestimate®
$329/sqft
$2,064 Estimated rent
Owner options
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
Originating MLS: Cape Fear Realtors MLS, Inc.
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Primary bedroom
- Dimensions: 16 x 13
Bedroom 2
- Dimensions: 13 x 10
Bedroom 3
- Dimensions: 13 x 11
Dining room
- Dimensions: 12 x 11
Kitchen
- Dimensions: 13 x 11
Laundry
- Dimensions: 7 x 6
Living room
- Dimensions: 20 x 14
Other
- Description: Foyer
- Dimensions: 12 x 5
Heating
- Heat Pump, Electric
Cooling
- Central Air, Heat Pump
Appliances
- Included: Electric Oven, Dishwasher
- Laundry: Laundry Room
Features
- Master Downstairs, Walk-in Closet(s), High Ceilings, Bookcases, Elevator, Ceiling Fan(s), Blinds/Shades, Walk-In Closet(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
Accessibility
- Accessibility features: Accessible Elevator Installed
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered, Porch, Balcony
- Fencing: None
Details
- Parcel number: R05000003122147
- Zoning: MX
- Special conditions: Standard
Construction
Type & style
- Home type: Condo
- Property subtype: Condominium
Materials
- Composition, Brick Veneer
- Foundation: Slab
- Roof: Architectural Shingle
Condition
- New construction: No
- Year built: 2005
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Natural Gas Connected, Sewer Available, Water Available
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 monthly
- Amenities included: Clubhouse, Pool, Fitness Center, Game Room, Maintenance Common Areas, Maintenance Grounds, Maintenance Structure, Management, Master Insure, Meeting Room, Party Room, Pest Control, Sidewalks, Street Lights, Tennis Court(s)
- Association name: CAMS
- Association phone: 910-256-2021
Other
Other facts
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional,VA Loan
- Road surface type: Paved
Sell for more on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
$521,500
2% more+$10,430
With Zillow Showcase(estimated)$531,930