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



![]() |
$199,900
34 28605 TRANS CANADA HIGHWAY, YALE "€Œ DOGWOOD VALLEY, HOPE
1 Bedroom, 1 Bathroom, 536 sqft
Live year-round or escape for your perfect holiday home away from home! This charming 1 bed, 1 bath home at Emory Bar RV Park offers comfort and relaxation. Featuring tall vaulted ceilings, daylight windows, and a spacious living room with large bay windows, this home is truly a retreat. It comes complete with modern stainless steel appliances and is covered by a full 10-year new home warranty, giving you peace of mind. Nestled in a serene, treed setting, the family- and pet-friendly park is jus ... Click for more details
Call Captain Vancouver at (604) YOUR KEY |
R3096712
Listing by Century 21 Creekside Realty (Luckakuck)
|
| # | MLS® | Address | City | Price | Beds | Baths | Year | SqFt | Land |
|---|---|---|---|---|---|---|---|---|---|
| 1 | R3096712 | 34 28605 TRANS CANADA HIGHWAY, Yale "“ Dogwood Valley | Hope | $199,900 | 1 | 1 | 2022 | 536 |