SOLD DOUBLE PATIOS AND UNOBSTRUCTED VIEWS IN THE STELLA
Listed By: Blu Living
If I were a man, I'd be the most interesting man in the world. I'd have double the fun. Two bedrooms.Two bathrooms and Two balconies Ole! I'd know I'd never have to settle for anything less than unobstructed views of the city, ocean and mountains. I'd have corian countertops, stainless steel appliances, one parking, insuite storage and live in a cool Mt. Pleasant neighborhood. If I did an open house without telling anyone, people would still get there. I wouldn't always drink beer, but when I did, I'd prefer Stella.
# #902 - 2770 Sophia St, Vancouver
| PRICE: $618,888 | BEDROOMS: 2 | TAXES(2010): $2,108 | MNT. FEE: $308 |
| SIZE: 910 Sq.Ft. | BATHROOMS: 2 | YEAR BUILT: 2008 | PARKING: 1 |
| MLS: V878957 | TYPE: Apartment Unit | SUBAREA: Mount Pleasant VE | $/SqFt $680 |
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'








