403 175 E BROADWAY BB
Listed By: Blu Living
The fabulous, famous & historic Lee building presents this adorable, modern one bedroom with a quaint layout, city & mountain views, high-end kitchen with Fisher Paykel appliances, custom cabinetry throughout & gorgeous hardwood floors. This landmark building is in the heart of the neighborhood's best coffee shops, clothing stores, pubs and restaurants. Maintenance fees include: property taxes, heat, water, electricity & management. Great for investors or a funky place for you to hang your fedora! Pets/rentals welcome. Solid, well run building. Come see quick!
# #403 - 175 E Broadway Bb, Vancouver
| PRICE: $249,900 | BEDROOMS: 1 | TAXES(2012): $0 | MNT. FEE: $807 |
| SIZE: 694 Sq.Ft. | BATHROOMS: 1 | YEAR BUILT: 1912 | PARKING: 0 |
| MLS: V1002398 | TYPE: Apartment Unit | SUBAREA: Mount Pleasant VE | $/SqFt $360 |
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'









-