Top 5 reasons this unit is Superb Value. 1. LAY-OUT; Seperated 2 bed, 2 bath. 2. VIEWS; South East facing with fantastic views of false Creek. 3. BUILDING; Fully retro fitted 3 years ago. 4 LOCATION; A happy medium between the WestEnd and Yaletown. 5. AMENITIES; Fitness World and Tim Hortons at your door step. PRICE; unreal

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'