SOLD CONTEMPORARY CONDO IN TRENDY MT. PLEASANT
Listed By: Blu Living
Hello, my name is Stella 506. I am a South East corner unit sitting perched atop the slopes of Mt. Pleasant waiting to find love. I have a phenomenal layout that makes perfect use of my square footage and seems to just work. I offer a view than you might imagine and particularly so from my enormous sun drenched balcony. I am an epicurean's dream located just a stone's through to many of the city's best eats. But don't worry; I stay fit by regularly using my common exercise room. If you are looking for a perfect blend of contemporary design and functional space, then look no further. I am the one! Come see for yourself this Sunday March 27, 2-4pm
# #506 - 2770 Sophia St, Vancouver
| PRICE: $470,000 | BEDROOMS: 1 | TAXES(2010): $1,652 | MNT. FEE: $274 |
| SIZE: 812 Sq.Ft. | BATHROOMS: 1 | YEAR BUILT: 2008 | PARKING: 1 |
| MLS: V874606 | TYPE: Apartment Unit | SUBAREA: Mount Pleasant VE | $/SqFt $579 |
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'








