Are you that person who loves living near the water? How about a home with a wicked view? Or a pad nestled in the heart of the city? The prestigious Azura II can check all those boxes and more. This sought-after & rarely available "08" corner 1 bed & den, (could be 2nd bed) offers STUNNING view of False Creek, George Wainborn Park, English Bay, the North Shore mountains & Vancouver city lights from every room through the floor to ceiling windows.new flooring, an open, modern kitchen with a large storage/pantry, and a perfect patio for BBQing and enjoying the sunset to round out all this suite has to offer. The on-site Super club satisfies all your fitness needs. Come and see how you can live the life of Vancouver luxury!

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'