STUNNING PANORAMIC MOUNTAIN AND WATER VIEWS from this "Heritage Style" condominium in Historic Gastown. Award winning concrete construction, fully rainscreened exterior. 900 sqft 2 bedroom, 2 bath end unit with an outstanding floorplan. Running the full depth of the building, bedrooms face the heritage streetscape, with the open plan living/kitchen/dining area enjoying the spectacular view, French doors open to the balcony. High end finishings include granite counters, gas range, and fireplace, pedestal sink, soaker tub and thick reclaimed hardwood floors. Amazing common roofdeck with gas BBQ, secured parking, pets and rentals welcome. Open House Sat March 14th, 2-4pm.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and agents.active = 'y'' at line 4select * from agents join agent_sites on (agents.id = agent_sites.agent_id) where agent_sites.site_id = 2 and agents.id = and agents.active = 'y'