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



![]() |
$619,000
1653 ROSEVALE STREET, AGASSIZ, AGASSIZ
3 Bedrooms, 2 Bathrooms, 1859 sqft
Investor, builder, or buyer with a vision"-this is your chance to unlock the potential of a rare property with stunning Mt. Cheam views. Set on a private lot along a paved road, this 3-bedroom, 2-bath historic home is ready for its next chapter. Bring your ideas to restore, renovate, or reimagine the property to suit your goals. The yard features mature fruit trees, established gardens, a sunroom, plenty of parking, and excellent storage for vehicles, RVs, or hobbies. A unique opportunity for th ... Click for more details
Call Captain Vancouver at (604) YOUR KEY |
R3142408
Listing by RE/MAX Nyda Realty Inc.
|
![]() |
$699,000
20806 SAKWI CREEK ROAD, AGASSIZ
3 Bedrooms, 2 Bathrooms, 1442 sqft
Frank Lloyd Wright-inspired hillside chalet at Sasquatch Mountain, perfectly positioned on an unobstructed lot in one of Hemlock Valley's best locations. This 3 bed, 2 bath cabin showcases massive reclaimed structural beams, engineered footings built to withstand 420 lbs / sqft snow loads, and breathtaking vaulted windows framing views of the ski runs. Enjoy a spacious 5' crawl space for all your ski gear and a rare bonus ample parking for guests! Equipped with SMART home technology throughout s ... Click for more details
Call Captain Vancouver at (604) YOUR KEY |
R3142490
Listing by Macdonald Realty (Surrey/152)
|