This is the deal you've been waiting for! 1008 sf, 2 level loft located in historic Gastown. Loft 507 is perfectly laid out. It is very wide as opposed to long and narrow like most lofts. With that comes 2 huge sets of windows allowing an abundance of natural light and beautiful views of the city to the west. This loft has an open kitchen, very large living space, 2 balconies, full bathroom on the main floor and a soaker tub on the upper floor where there is enough room to enclose a 2nd full bathroom or powder room. You'll also have access to one secured parking stall and your guests will have access to several visitor stalls. Pet and rental friendly. There's even a dog wash station for after a great play or swim at Crab Park.

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'