Welcome home, is the first thing you'll think when walking through the front doors at the "Pilkington House" loft. I emphasis "home" as it feel like a grand, cozy home with that warm, historic, NYC kind of modern edge.This bright, massive 3 bed, 2 bath corner loft spans 2700sft, with 9.5ft ceiling, polished concrete floors, complete high-end renovation throughout with a functional, comfortable floor plan for a full family, couple or that single bachelor/ette Boutique building with only 6 units & 2 per floor, in the centre of Gastown's world famous shops and eats. Sharing an unbeatable, manicured rooftop patio with 180 views of the mountain, water and city 2 SECURE UNDERGROUND PARKING.

 

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'