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



![]() |
$734,900
406 1551 FOSTER STREET, WHITE ROCK
2 Bedrooms, 2 Bathrooms, 1264 sqft
Welcome to Sussex House, an elegant concrete building in White Rock. This move-in ready END unit features a bright, spacious layout with 2 bedrooms on opposite sides, an office nook, 2 full bathrooms, and large in-suite storage room. The open-concept living area is filled with natural light through oversized windows. The kitchen offers granite countertops, stainless steel appliances, and a cozy nook, perfect for your morning coffee. Enjoy the warmth of the cozy gas fireplace and numerous updates ... Click for more details
Call Captain Vancouver at (604) YOUR KEY |
R3121281
Listing by Macdonald Realty (Surrey/152)
|
| # | MLS® | Address | City | Price | Beds | Baths | Year | SqFt | Land |
|---|---|---|---|---|---|---|---|---|---|
| 1 | R3121281 | 406 1551 FOSTER STREET | White Rock | $734,900 | 2 | 2 | 2005 | 1264 |