510 City View Drive
Mermaid
C1B 0V8
$1,970,000
Single Family
beds: 4
baths: 5.0
built: 2000
- Status:
- Active
- Prop. Type:
- Single Family
- MLS® Num:
- 202528705
- Bedrooms:
- 4
- Bathrooms:
- 5
- Year Built:
- 2000
- Photos (50)
- Schedule / Email
- Send listing
- Mortgage calculator
- Print listing
Schedule a viewing:
Cancel any time.
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 spaces. Dinning room large enough for any table set up! With 4 spectacular bedrooms and 4 well-appointed bathrooms, there's room for the whole family and guests. The show-stopping sunroom facing the water is the ultimate place to relax and soak in the views year round. Above the spacious 3-car garage, has a full in-law suite above provides privacy and convenience for extended family or guests. Nestled on a private dead-end road, this property also offers peace of mind with completed shoreline protection. A truly rare find where modern updates meet timeless waterfront beauty. (id:2493)
- Property Type:
- Single Family
- Common Interest:
- Freehold
- Property Attached:
- No
- Finished Area Above Grade:
- 3,935 sq. ft.
- Taxes:
- $4,885 / 2025
- Community:
- Mermaid
- Exterior Features:
- Stone, Vinyl
- Community Features:
- School Bus
- Waterfront:
- Waterfront
- Structure Type:
- House
- Appliances Included:
- Washer, Refrigerator, Dishwasher, Oven, Dryer, Microwave
- Bedrooms:
- 4
- Bedrooms Above Grade:
- 4
- Bedrooms Below Grade:
- 0
- Bathrooms:
- 5.0
- Half Bathrooms:
- 1
- Fireplace:
- Yes
- Floor finish:
- Laminate, Engineered hardwood, Ceramic Tile
- Foundation:
- Poured Concrete
- Heating:
- Baseboard heaters, In Floor Heating, Oil, Electric, Heat Recovery Ventilation (HRV), Propane, Solar, Wall Mounted Heat Pump
- # Storeys:
- 2.0
- Water:
- Drilled Well
- Sewer:
- Septic System
- Basement:
- Partially finished, Partial
- Lot Size:
- 1.2 acre(s)
- Lot Details:
- 1.2
- Lot Features:
- Paved Driveway
- Parking:
- Attached Garage
- Floor
- Type
- Size
- Other
- Lower level
- Sitting room
- 10' × 10'
- -
- Main level
- Living room
- 17' × 15'
- -
- Main level
- Kitchen
- 22' × 12'
- -
- Main level
- Den
- 17'10" × 12'
- -
- Main level
- Den
- 18' × 17'
- -
- Main level
- Mud room
- 20' × 8'
- -
- Main level
- Pantry
- 10' × 4'5"
- -
- Main level
- Bedroom
- 11' × 10'6"
- -
- Main level
- Bedroom
- 11' × 11'
- -
- Main level
- Sunroom
- 26' × 11'
- -
- Second level
- Bedroom
- 20' × 11'
- -
- Second level
- Bedroom
- 17'8" × 11'
- -
- Second level
- W/I Closet
- 15'8" × 11'9"
- -
- Floor
- Ensuite
- Pieces
- Other
- Second level
- No
- -
- 11' x 13'
- Second level
- No
- -
- 10'8" x 11'
-
Photo 1 of 50 -
Photo 2 of 50
-
Photo 3 of 50
-
Photo 4 of 50
-
Photo 5 of 50
-
Photo 6 of 50
-
Photo 7 of 50
-
Photo 8 of 50
-
Photo 9 of 50
-
Photo 10 of 50
-
Photo 11 of 50
-
Photo 12 of 50
-
Photo 13 of 50
-
Photo 14 of 50
-
Photo 15 of 50
-
Photo 16 of 50
-
Photo 17 of 50
-
Photo 18 of 50
-
Photo 19 of 50
-
Photo 20 of 50
-
Photo 21 of 50
-
Photo 22 of 50
-
Photo 23 of 50
-
Photo 24 of 50
-
Photo 25 of 50
-
Photo 26 of 50
-
Photo 27 of 50
-
Photo 28 of 50
-
Photo 29 of 50
-
Photo 30 of 50
-
Photo 31 of 50
-
Photo 32 of 50
-
Photo 33 of 50
-
Photo 34 of 50
-
Photo 35 of 50
-
Photo 36 of 50
-
Photo 37 of 50
-
Photo 38 of 50
-
Photo 39 of 50
-
Photo 40 of 50
-
Photo 41 of 50
-
Photo 42 of 50
-
Photo 43 of 50
-
Photo 44 of 50
-
Photo 45 of 50
-
Photo 46 of 50
-
Photo 47 of 50
-
Photo 48 of 50
-
Photo 49 of 50
-
Photo 50 of 50
Video Tour Website
Listed by CENTURY 21 COLONIAL REALTY INC
Data was last updated November 28, 2025 at 07:45 PM (UTC)
Area Statistics
- Listings on market:
- 10
- Avg list price:
- $469,250
- Min list price:
- $369,500
- Max list price:
- $1,970,000
- Avg days on market:
- 86
- Min days on market:
- 36
- Max days on market:
- 242
These statistics are generated based on the current listing's property type
and located in
Mermaid. Average values are
derived using median calculations. This data is not produced by the MLS® system.
- JODI BERNARD
- CENTURY 21 NORTHUMBERLAND REALTY
- 1-902-888-7842
- jodi@century21pei.com
Jodi Bernard - CENTURY 21 Northumberland Realty
Office Address:
629 WATER STREET EAST
Summerside, PE, C1N 4H8