The Loft: this is a great 883 SF open concept loft in award winning L'Atelier featuring original hardwood floors, views to the north, approx. 10' ceilings. L'Atelier also offers a fantastic common roof top patio equipped with BBQ and seating! The Location: Hastings Sunrise is Vancouver's most vibrant up and coming neighbourhood, brimming w/ European-style markets and eateries, steps to everything and only 15 minutes downtown. This is an area that must be explored and rediscovered. See how long you can go without driving! The Lifestyle: Heritage, character, charm, history and now the future.

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'