The Loft: 2bed/2 bath/2parking & den. 10'5 ft ceilings and some concrete wall features. Sunfilled southfacing patio. The bedrooms are private, separated by the living room. As for the 2nd bedroom..it's HUGE and has a walk in closet too. You'll have no trouble feeling right at home here.
The Location: Main St living is all about proximity, people, and this place is nailing it. Your front door is a literal stone’s throw from some of the city's most tasty restaurants, sexy shopping and cafe connoisseurs.
The Lifestyle: East Van community vibe. Walk or bike everywhere. Happy.
“THIS SOMA LOFT IS WORTH KILLING FOR [BUT PLEASE DON'T]”
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'