Hip & modern front half duplex on the edge of Chinatown in the heart of Strathcona & just a short stroll from skytrain & seawall. This total transformation includes all new wood flooring, new windows, 2 new bathrooms, a new kitchen and the coolest floating stairs all the way to the top. The reverse plan offers a top floor with open concept kicthen + eating area and living room with a wood burning fireplace. Middle floor is the master bedroom, walk in closet and ensuite bathroom. Main floor is den, baby's room and 3 pc bathroom with circular shower and laundry. 1 secure parking in shared garage. Must see to appreciate this architecturally unique structure with sleek and stylish interior. OPEN CANCELLED.

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 1select * 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'