The general public can search for active listings of residential properties at the following websites:
Realtor.ca - Canada's nation-wide residential listings search website
RealtyLink - Residential real estate search for the BC Lower Mainland
The above two websites provide basic information of active property listings in the MLS (Multiple Listing Service®).
As a realtor and member of the Real Estate Board of Greater Vancouver, I have access to Paragon MLS database, which contains much more detailed information of active listings as well as sold and expired listings. If you need my assistance to conduct a more comprehensive search in the Paragon MLS database, please contact me.