SOLD GASTOWN HERITAGE LOFT IN THE TAYLOR
Listed By: Blu Living
Taylor #304 - "Single and ready to mingle". I'm looking for someone special who loves heritage,bricks,beams,open concepts,reclaimed hardwood, and stainless. I'm over 100 yrs old but had major surgery in 2003 by the award winning SALIENT group. Are you a fan of Gastown, living right on Water street, and rooftop decks?? Do storage lockers and bike rooms give you goose bumps?? If so, give realtor a ring and come check me out.
# #304 - 310 Water St, Vancouver
| PRICE: $395,500 | BEDROOMS: 1 | TAXES(2011): $1,232 | MNT. FEE: $230 |
| SIZE: 646 Sq.Ft. | BATHROOMS: 1 | YEAR BUILT: 2003 | PARKING: 0 |
| MLS: V908865 | TYPE: Apartment Unit | SUBAREA: Downtown VW | $/SqFt $612 |
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'










-