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



![]() |
$355,000
8 39884 GOVERNMENT ROAD, SQUAMISH
2 Bedrooms, 1 Bathroom, 960 sqft
Charming 2 bedroom home with a fantastic private backyard! Welcome to this cozy and well-maintained 2-bedroom, 1-bath home offering comfort, value and plenty of great features. Updates include a new electric heat pump, gas on-demand hot water, newer windows, new kitchen appliances and new siding. The open-concept layout makes great use of the space. Step outside to a large private backyard surrounded by greenery, perfect for BBQs, gardening, relaxing and enjoying the mountain views. Located just ... Click for more details
Call Captain Vancouver at (604) YOUR KEY |
R3156047
Listing by Black Tusk Realty
|
![]() |
$819,800
313 1506 SCOTT CRESCENT, SQUAMISH
2 Bedrooms, 2 Bathrooms, 1016 sqft
Unobstructed ocean and mountain views, incredible natural light, and Stawamus Chief views from your large private covered patio. This bright and spacious 2-bedroom, 2-full bathroom, den/office complete with A/C home offers over 1,015sq. ft. and is one of the best-positioned residences at Redbridge, located on the highly desirable view side of the building. Enjoy 20,000 sq.ft. of exceptional amenities including a gym, sauna, hot tub, cold plunge, co-working space, lounges, outdoor kitchens, red ... Click for more details
Call Captain Vancouver at (604) YOUR KEY |
R3156021
Listing by Macdonald Realty
|
![]() |
$899,900
12 39752 GOVERNMENT ROAD, SQUAMISH
3 Bedrooms, 3 Bathrooms, 1570 sqft
Discover the perfect blend of space, flexibility & community in this beautifully upgraded 3 bedroom, 2.5 bathroom townhome offering over 1550 sq. ft. The functional layout features an open den or office plus a versatile flex room currently used as a soundproof recording studio, ideal as a media room, gym, playroom, office or potential 4th bedroom. Recent updates include replacement of all Poly B piping, engineered hardwood on the main level, laminate flooring upstairs & tiled bathrooms. The roof ... Click for more details
Call Captain Vancouver at (604) YOUR KEY |
R3155708
Listing by RE/MAX Masters Realty
|