THE LOFT: Brewery Creek is a unique 1905 heritage conversion. The high ceilings alone should be enough to make you shed a tear or two of joy. Add some exposed brick walls & pass me a tissue. To die for 2 level open concept which could be your blank slate. Beautiful as is,or chanel that inner artist (afterall this is Main St) Excuse me as I direct your attention away now to the clawfoot bathtub. That could be you lounging in it with a ton of bubbles & a glass of wine...THE LOCATION: Soma , ( South of Main) the most interesting & fastest changing neighbourhoods in Vancouver. Walking distance to transit, indie fashion, art , and of course coffee. THE LIFESTYLE: Enjoy Mt Pleasant for what it is, eclectic, inventive & both culturally & socioeconomically diverse.

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'