SOMA LOFTS: 863 sq.ft. 2-Bedroom/2-Bath, pakring and storage both insuite and additional. Soma Lofts boasts 10'5 ceilings with floor-to-ceiling windows that span the width of the unit. Lots of natural light! If you like outdoor space this unit has it! 443 sq.ft. patio that stretches the length of the unit. Kitchen comes with a stainless steel appliance package and granite countertops and the unit has been freshly painted. Soma Lofts is located in the vibrant Main Street corridor which is fast becoming a diner's destination with lots of shopping and entertainment. Remainder of 2-5-10 warranty left. Solid concrete construction, a fabulous building and one of Vancouver's top areas to live in.

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'