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



![]() |
$239,000
228 2279 MCCALLUM ROAD, ABBOTSFORD
2 Bedrooms, 1 Bathroom, 955 sqft
Open to all offers! Come check out this move-in-ready condition, well-run 55-plus complex located in central Abbotsford, within walking distance to local shops, restaurants, Doctor offices, transit, & life labs. Over 950 Sq. Ft of living space, plus an enclosed solarium with a storage there and another on the same floor down the hall. Features include beautiful newer laminate flooring, freshly painted throughout, brand new carpet in both bedrooms, new light fixtures, new bathroom with walk-in sh ... Click for more details
Call Captain Vancouver at (604) YOUR KEY |
R3151997
Listing by eXp Realty
|
![]() |
$758,000
1108 9133 HEMLOCK DRIVE, RICHMOND
2 Bedrooms, 2 Bathrooms, 1025 sqft
Rarely available corner unit with amazing city and mountain views. 1,025 sq. ft. home featuring 2 spacious bedrooms and 2 full bathrooms in a well-managed building. Excellent location close to Richmond Centre, shopping, restaurants, and public transit. Functional open-concept layout with granite countertops, stainless steel appliances, laminate flooring, and an electric fireplace. This home also includes 2 parking stalls and a large storage locker. Enjoy outstanding amenities, including an indoo ... Click for more details
Call Captain Vancouver at (604) YOUR KEY |
R3151904
Listing by RE/MAX City Realty
|
![]() |
$1,299,000
22291 GARRATT DRIVE, RICHMOND
4 Bedrooms, 3 Bathrooms, 2101 sqft
Why choose a condo when you can own a beautifully renovated detached home with room to grow? Welcome to a home where family dinners, backyard BBQs, birthday parties, and summer evenings with friends become part of everyday life. The private backyard is the perfect place for kids and pets to play while you relax or entertain. Inside, every major update has already been completed, including a stunning new kitchen, new appliances, stylish bathrooms, new flooring, fresh paint, plus newer windows, do ... Click for more details
Call Captain Vancouver at (604) YOUR KEY |
R3151986
Listing by eXp Realty
|