Welcome to your bright two level loft at "The Space Lofts". Plenty of natural light from this open concept designed modern styled plan. Enjoy sunny views of Downtown. This 680+ [approx] loft features plenty of potential for your ideas. This suite includes an underground secure parking stall. Live in the heart of Downtown next door to Yaletown and the Vancouver's best amenities. This building includes a gym, rooftop decks, and a caretaker.

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'