Welcome to your penthouse view loft. This unique residence has been completely redesigned in a modern Japanese aesthetic. A unique 1051 sq.ft. open layout which faces North with views to Downtown and the North Shore mountains. An architectural detailed interior with the finest finishings including: walnut flooring, custom glass & steel railing, steel staircase, custom wood kitchen with state-of-the-art stainless steel countertops, high-grade appliances, and plenty of custom wood built-in storage closets/units. Upstairs loft/office could be 2nd bedroom. Endless light throughout the whole space. Live/work solid concrete constructed building. 1 parking included. An excellent loft space with plenty of flexibility.

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'