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



![]() |
$1,850,000
1905 LOWER ROAD, ROBERTS CREEK
5 Bedrooms, 3 Bathrooms, 1585 sqft
Completely rebuilt in 2022, this gorgeous seaside cottage offers all the modern-day amenities. Immerse yourself in the ultimate coastal lifestyle with luxury finishes, offered fully furnished in a fabulous location with perfect all-day sun, walk-out waterfront, and a sandy beach just steps from your door. This stunning cottage features an open floor plan, hardwood floors, and ocean views from nearly every window. With 5 bedrooms, 3 bathrooms, & ample storage, it´s ideal for family or guests. Lo ... Click for more details
Call Captain Vancouver at (604) YOUR KEY |
R3120589
Listing by Sotheby's International Realty Canada
|
![]() |
$1,999,000
1499 HANBURY ROAD, ROBERTS CREEK
6 Bedrooms, 6 Bathrooms, 4475 sqft
Sunny Roberts Creek acreage! This 4.81 acre property boasts stunning gardens, a spacious multigenerational home, and a lovely 2 stall barn. The property is well drained and gets plenty of light, which can be hard to find in the Creek, and makes it perfect for someone wanting to grow their own food, have some livestock, or both! With a drilled well you don't have to worry about water restrictions and the filtration system gives you peace of mind that it's always crystal clear. Inside the home you ... Click for more details
Call Captain Vancouver at (604) YOUR KEY |
R3120984
Listing by Royal LePage Sussex
|