SQL: SELECT * FROM Listings WHERE (Active='Y') AND (AddDate > '2026-06-27 00:00:00') AND (PropertyType = 'Single Family')



![]() |
$689,000
315 400 KLAHANIE DRIVE, PORT MOODY
2 Bedrooms, 2 Bathrooms, 962 sqft
Welcome to The Tides by Polygon, the perfect blend of comfort, style and location. this private, greenbelt facing 2 bed/2 bath home is thoughtfully designed with bedrooms on opposite sides, a walk-in closet, and an upgraded ensuite, offering both functionality and elegance. Entertain with ease in the open concept kitchen, featuring s/s appliances, gas stove, and plenty of counter space, all flowing into a cozy living room with a fireplace. Hardwood floors throughout, along with a new washer/drye ... Click for more details
Call Captain Vancouver at (604) YOUR KEY |
R3140553
Listing by Sutton Group-West Coast Realty
|
![]() |
$1,199,900
2102 290 NEWPORT DRIVE, PORT MOODY
2 Bedrooms, 2 Bathrooms, 1499 sqft
Welcome to this spacious and beautifully maintained 2-bedroom plus den, 2-bathroom home offering over 1,500 sq. ft. of comfortable living space. Enjoy breathtaking panoramic views from this bright and airy residence, featuring granite countertops, hardwood flooring, abundance of closet space. The thoughtfully designed floor plan provides generous room sizes, a den perfect for a home office or guest space, including a huge private storage room conveniently located behind your parking stall. Outst ... Click for more details
Call Captain Vancouver at (604) YOUR KEY |
R3140461
Listing by RE/MAX All Points Realty
|