West facing loft with city and harbour views from this 723 sq ft double height space with 18 foot ceilings. Two concrete shear walls, concrete floors both on the main and up in the mezzanine. Nice size balcony to enjoy the summer evenings. Gas fireplace and stove. Solid concrete construction in a sought after artist live/work building. Mezzanine addition and relocated stairs not included in the square footage. Bonus 7,000 sq ft amenity building with wood, metal ceramic workshops, exercise area, darkroom and music rehearsal space. Secured underground parking.

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'