NEW YORK STYLE LOFT... Abbott Place is a true heritage building from 1910 converted in 1996 and located on the BEST BLOCK IN GASTOWN! A very bright and open loft you can make your own features over-height ceilings over 9ft, exposed original brick walls, 4 large windows facing Abbott, and brand new high-end laminate maple hardwood floors. Boutique designer, shopping, award-winning restaurants, night life and annual festivals and events all right at your doorstep! Plus Nesters Market, London Drugs, TD Bank, Woodwards across the street. ***INVESTORS*** don't miss out on this opportunity with NO PET OR RENTAL RESTRICTIONS in Gastown's most sought-after rental building!

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'