Fantastic 1 bedroom unit in the BOSA built "Eden" building, one of Yaletowns premier developments. Functional open concept floor plan w/ spacious kitchen and dining area, a bright living room feat. gas fire place and mounted flat screen TV, Fr ench door access into master bedroom incl. a walk thru closet and a Jack and Jill ensuite bath. Bonus in suite storage room which can double as office/den and a west facing balcony. Buildings gym/spa is on the same floor, just steps away. Enjoy life in the heart of this vibrant community and walk to all of the shops, restaurants and cafe's it has to offer, in addition to the wonderful sea wall just 3 blocks away. **Building has guest suite for visitors. Pets and rentals are allowed.

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'