SOLD MODERN, SUN FILLED YALETOWN CONDO WITH CITY AND WATER VIEWS!
THE CONDO: This bright space is filled with sunlight. 2bed/2bath & den upgraded walnut floors throughout, modern white streamlined built ins and modern lighting. SW patio with expansive city & peekaboo water views. Separated bedrooms for privacy. One large parking stall, space for a truck and motorcycle and storage. THE BUILDING: The Brava famous for it's 4th floor OUTDOOR pool and rooftop patio. Hot tub, sauna, steam room, large gym, movie theater and 2 guest suites. THE LIFESTYLE: Across from Emery Barnes Park, Starbucks Coffee,Yaletown shops, restaurants, Choices market and a 5 in walk to the Canada line. City living at it's finest.
Call or text Nina for more info 604.763.8898
# #2607 - 1199 Seymour St, Vancouver
| PRICE: $599,000 | BEDROOMS: 2 | TAXES(2014): $1,967 | MNT. FEE: $355 |
| SIZE: 820 Sq.Ft. | BATHROOMS: 2 | YEAR BUILT: 2005 | PARKING: 1 |
| MLS: V1085363 | TYPE: Apartment Unit | SUBAREA: Downtown VW | $/SqFt $730 |
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'
-