SOLD OPEN CONCEPT LOFT IN MT PLEASANT
Listed By: Blu Living
Calling Artworks lovers !!! Seeking someone funky & interesting to love my unique open concept. I've got everything you need including, in-suite laundry, open kitchen, divided bedroom area, and a patio. Yes !! A PATIO with an awesome southern view of an old heritage house. Interested ??
# #207 - 237 E 4th Av, Vancouver
| PRICE: $345,000 | BEDROOMS: 1 | TAXES(2011): $1,215 | MNT. FEE: $162 |
| SIZE: 661 Sq.Ft. | BATHROOMS: 1 | YEAR BUILT: 1995 | PARKING: 0 |
| MLS: V911719 | TYPE: Apartment Unit | SUBAREA: Mount Pleasant VE | $/SqFt $522 |
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'
-