Is it true what they say about the French? Mon cherie, the Montreux is the best. I'm a hop, skip and a kiss to the Cambie Rav line. The seawall is across the street. I'm walking distance to downtown, Whole foods, London Drugs and beneath me is Starbucks. Ps) I like coffee in bed. Inside, I'm just as fantastique with quality finishings, 9 ft ceilings, fireplace, balcony, solarium, radiant bathroom flooring, den ,and an insuite storage with built in closets. I also have a walk up entrance.. ahh c'est la vie..

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'