This is a beauty artist live/work studio in the Mecca Loft building just off Main St. The owners have taken great care of this property! The kitchen has been tastefully updated with new cabinets, storage solutions & appliances. They've also revamped the laundry area & installed an efficient all-in-one clothes washer/dryer. The loft has approx. 12' ceilings and a great open living space allowing for plenty of room to spread out, dine and sleep. The large windows & concrete floors are a great feature that appeals to a large majority. The Mecca also has a large rooftop patio equipped with BBQ & seating. When you're not hanging out there you'll have countless eateries & watering holes along Main St & SE False Creek!

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'