BRAND NEW, sleek, and ultra-modern! Extremely hip 2 bdrm PENTHOUSE located within minutes of the Athletes' Village, trendy Main Street shops and restaurants, and Skytrain. Spectacular mtn and city VIEWS from floor-to-ceiling windows. Designer details include 9'2" ceilings, polished concrete floors, sliding diffused glass walls and top-of-the-line European appliances hidden away to make the kitchen look like a piece of furniture. Stunning contemporary skylit interior opens to 2 spacious private decks [north and south facing]. Quality concrete construction covered by 2-5-10 year Warranty. Fitness facility, project workshop, and gallery/exhibition space. One parking plus storage locker. Pets and rentals OK. Open Sat/Sun Apr 16/17 2-4pm.

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'