1 / 50

For Sale · Mermaid

$1,790,000

510 City View Drive, Mermaid

Tour this home

Bedrooms

5 (1 half)

Bathrooms

2000

Year built

About This Home

The details.

Exceptional Waterfront Home! This stunning waterfront home offers the perfect blend of comfort, luxury, and functionality. Fully updated throughout with new flooring, fresh paint, and beautiful new cupboards and great kitchen Island. It features a massive chef's kitchen ideal for entertaining. The heart of the home centers around a dramatic back-to-back fireplace, adding warmth and elegance to both living and dining...

Summarizing the highlights...

MLS® 202617583Listing courtesy of CENTURY 21 COLONIAL REALTY INCView on map

Property Details

Facts & features.

Property type: Single Family
Ownership: Freehold
Year built: 2000
Lot size: 1.2 acres
Storeys: 2
Listed on: 2026-07-15
Days on market: 1
MLS number: 202617583
Data source: Prince Edward Island Real Estate Association

Market intelligence

Statistics and history.

Days on market

Mermaid median asking

$900K

8 active listings

New this week

8 active listings

Where this price sits in Mermaid

$99KThis listing$1.8M

Computed live from active MLS listings we track. Sold-price history and multi-year assessment history switch on when sold-data access arrives.

Coming Soon

Listing & sold history.

These sections unlock with our sold-data feed. They are reserved here so you know exactly what is on the way.

Sold history for this homeComing soon

Listing history (every time it hit the market)Coming soon

Days-on-market trend for this areaComing soon

Nearby sold comparisonsComing soon

July Value

What this home is worth.

Calculating a July Value estimate...

Run The Numbers

Mortgage and cash flow

Mortgage calculator.

Home priceDown payment20%Rate (%)Amortization25 yr

Monthly mortgage payment

$8,371

$1,432,000 financed over 25 years at 5%. For guidance only, not a quote or approval.

Cash flow analysis.

Property tax / moMaintenance / moRental income / mo

Monthly cost (mortgage + tax + maintenance)

$8,371

Cash flow

-$8,371

Estimates for education only. Talk to a JULY advisor for real numbers on this home.

Mermaid right now

Active listings

New this week

$900,000

Median asking price

Live snapshot from the MLS® feed. Sold-price history and trend charts arrive with our VOW data feed.

Similar homes

Nearby homes like this one.

$1,250,000
35 Richard Douglas Drive, Mermaid
3 bed · 2 bath

My Notes

Track this home.

Write a note about this home

Contact JULY

Tour it, ask anything.

Reach JULY now

Call or text any time: JULY answers immediately, day or night, and can book this showing on the spot.

Call JULY Text JULY Email JULY

Talk to a JULY advisor.

Interested in this home?

Book a viewing with a JULY advisor.

Listing information is provided courtesy of the Canadian Real Estate Association's Data Distribution Facility (DDF®) and is deemed reliable but is not guaranteed accurate by JULY Realty or CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos identify professional services rendered by REALTOR® members of CREA to effect the purchase, sale and lease of real estate as part of a cooperative selling system. The trademarks REALTOR®, REALTORS® and the REALTOR® logo are controlled by CREA and identify real estate professionals who are members of CREA.