Stunning and Dramatic loft at The Terminus. Located in the most desirable part of Historic Gastown on Water St. Enjoy some of Vanouver's most exclusive boutique shops and dining establishments within mere steps of your front door... This fantastic two-level 'loft residence' provides a generous 1,291 sq ft of interior and feature soaring ceilings, heritage windows and hardwood flooring throughout. The sleek modern kitchen is equipped with stainless steel counters, white lacquer cabinets and European stainless steel appliances including an integrated fridge. Main floor bathroom is a unique linear design with sliding frosted glass partitions. Master ensuite is luxurious and spa-style with a lge Phillipe Starke designed tub and shwr.

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'