Photo by Polly B

Search Condos Rentals in Mermaid

  • Plan, book, stay with confidence
    • bex rewards loyalty icon
    Be picky
    Search almost a million properties worldwide
    payments icon
    Treat yourself
    Sign in to save 10% or more on thousands of hotels
    Sign in
    today icon
    Change your mind
    Book hotels with free cancellation

Browse Select Mermaid Condo Rentals

Luxurious Waterfront Condo in downtown Charlottetown,
Outdoor dining
Luxurious Waterfront Condo in downtown Charlottetown,
10.0 out of 10, Exceptional, (111)
"We thoroughly enjoyed our stay. Upon arrival we received a good orientation of the building and area around it. The condo is clean and bright and very close to the downtown. We would not hesitate to book this same location on our next visit. 100% highly recommended "
Luxurious Waterfront Condo in downtown Charlottetown,
Bright and Spacious place located across from Red Shores Casino. Charlottetown.
Outdoor dining
Bright and Spacious place located across from Red Shores Casino. Charlottetown.
9.0 out of 10, Wonderful, (4)
"Very good place"
Bright and Spacious place located across from Red Shores Casino. Charlottetown.
Downtown Heritage Condo
Private kitchen
Downtown Heritage Condo
10.0 out of 10, Exceptional, (20)
"Clean, new, well appointed, excellent location "
Downtown Heritage Condo
Walk to Fine Restaurants & Confederation Centre of The Arts.
Fridge, microwave, oven, stovetop
Walk to Fine Restaurants & Confederation Centre of The Arts.
10.0 out of 10, Exceptional, (77)
"We were in town for USports Rugby and foynd this fantastic condo! Easy walk to to great restaurants and pubs. Great harbour view. The guest guide in the condo was very helpfull too. Definitely recommend this accommodation!"
Walk to Fine Restaurants & Confederation Centre of The Arts.
2 BDRM OCEAN/BEACH FRONT ROTATING CONDO!
On the beach
2 BDRM OCEAN/BEACH FRONT ROTATING CONDO!
9.8 out of 10, Exceptional, (35)
"My son and I enjoyed our room especially the rotating feature to this room."
2 BDRM OCEAN/BEACH FRONT ROTATING CONDO!
Relax at Idlewood Cottage, Near beaches - Stanhope
Smart TV, fireplace
Relax at Idlewood Cottage, Near beaches - Stanhope
10.0 out of 10, Exceptional, (4)
"We all were very pleased with the accommodations and all the different venues to enjoy. Outside, by the fireplace, out on the enclosed porch. Neighborhood very nice. We all really enjoyed it stay. "
Relax at Idlewood Cottage, Near beaches - Stanhope
Central Island location close to Confederation Trail, golf and many attractions.
Exterior
Central Island location close to Confederation Trail, golf and many attractions.
10.0 out of 10, Exceptional, (8)
"Brad's excellent service made our stay enjoyable, easy and comfortable. We will be back!"
Central Island location close to Confederation Trail, golf and many attractions.
2 BDRM OCEAN/BEACH FRONT ROTATING CONDO!
Beach nearby
2 BDRM OCEAN/BEACH FRONT ROTATING CONDO!
9.6 out of 10, Exceptional, (5)
"This place was fantastic, the highlight of our trip. We loved the set up of the condo, the rotation and the proximity to the beach. It was a very relaxing visit and we were able to connect with nature. We absolutely would visit again. I'm aware that it was the off-season, but it was frustrating trying to get information as to which places were open or not open as many of the websites for the local food places didn't specify whether they were open or when they were opening for the season. I...
2 BDRM OCEAN/BEACH FRONT ROTATING CONDO!
2 BDRM OCEAN/BEACH FRONT ROTATING CONDO!
Beach nearby
2 BDRM OCEAN/BEACH FRONT ROTATING CONDO!
9.6 out of 10, Exceptional, (4)
"The condo is beautiful and the location is amazing. Loved the neighbourhood as it is very close to Cavendish Beach. The showerhead and the bathroom is awesome."
2 BDRM OCEAN/BEACH FRONT ROTATING CONDO!
2 Bdrm Ocean/Beach Front Rotating Condo!
Beach nearby
2 Bdrm Ocean/Beach Front Rotating Condo!
10.0 out of 10, Exceptional, (8)
"Upon our arrival, our condo was ready and easily accessed. Information about the unit was easily found. The rooms and living area were comfortable. We enjoyed the rotating feature and the sauna. It’s close proximity to shops, restaurants, and the harbor was wonderful. The location is beautiful. We really enjoyed our stay at this architectural marvel…Kindly The Schmidt Family"
2 Bdrm Ocean/Beach Front Rotating Condo!
Waterfront Condo-2BR, 2BR
Dining tables
Waterfront Condo-2BR, 2BR
Waterfront Condo-2BR, 2BR
Luxury downtown living in the heart of Charlottetown. Come play on our Island!!!
Fridge, microwave, oven, stovetop
Luxury downtown living in the heart of Charlottetown. Come play on our Island!!!
10.0 out of 10, Exceptional, (4)
"Would stay here again and not change anything."
Luxury downtown living in the heart of Charlottetown. Come play on our Island!!!
Lowest nightly price found within the past 24 hours based on a 1 night stay for 2 adults. Prices and availability subject to change. Additional terms may apply.
Don't see what you're looking for?
See all available properties in Mermaid
Save an average of 15% on thousands of hotels when you're signed in
Sign in
Sign up, it's free

Other property types in Mermaid

Your Home Away From Home- 4 bed, 3 bath, centrally located.
Fridge, microwave, oven, stovetop
Your Home Away From Home- 4 bed, 3 bath, centrally located.
10.0 out of 10, Exceptional, (21)
"This home is a definitely worth staying at! It was clean, comfortable (ac), lots of space and had all the amenities you’d need! The home was easy to get to and very convenient for groceries and anything else you need. You will not be disappointed!"
Your Home Away From Home- 4 bed, 3 bath, centrally located.
Glendenning Hall
Exterior
Glendenning Hall
2.0 star property
8.8 out of 10, Excellent, (657)
"a lot of homeless people around"
Glendenning Hall
Dream 5 Bedroom Beachfront Vacation Home With Amazing Sunrise Views
Interior
Dream 5 Bedroom Beachfront Vacation Home With Amazing Sunrise Views
10.0 out of 10, Exceptional, (15)
"Not a review, just information for the property owner - there was no way for us to lock the small door to the garage (dead bolt count be turned)"
Dream 5 Bedroom Beachfront Vacation Home With Amazing Sunrise Views
Lowest nightly price found within the past 24 hours based on a 1 night stay for 2 adults. Prices and availability subject to change. Additional terms may apply.
Beautiful view of the beach with palm trees

Black Friday: Members save 30%+

Members save 30%+ on selected hotels until December 4 with our Black Friday deals. Stay by December 15, 2025.
Unlock Black Friday deals

Frequently asked questions

How much do condos in Mermaid cost?
You’ll pay from to per night for condos in Mermaid. Whatever your budget, an ideal stay is a click away on Expedia. These prices were available on Expedia within the past 7 days, for a hotel booking with a check-in date within the next year. Prices reflect current offers and availability is subject to change. Additional terms may apply.
How many condos are there in Mermaid?
Make use of your vacation days and pick from 12 condos in Mermaid. For work-related travel, a family vacation or anything in between, Expedia will help you find the ideal place in a few quick clicks.
Why book your condo in Mermaid with Expedia?
Booking a condo in Mermaid is as simple as working out your travel dates and selecting a place that meets your requirements. On the search for something affordable or upmarket, or a stay that also includes a kitchenette? Use Expedia’s search filters to narrow your results even further and find the ideal fit.
How can I find cheap condos in Mermaid?
The easiest way to locate cheap condos in Mermaid is with Expedia’s convenient filter tool. Refine your search results by budget, amenities and star rating to grab awesome prices in a few clicks.