SOLD WESTEND SPECIAL. CONCRETE BUILDING, WALKING DISTANCE TO THE BEACH
Listed By: RE/MAX Select Properties
Located 1 block from Sunset Beach sits this sharply priced fresh spacious one bedroom condo! This home with its open floor plan has been freshly painted with newer bathroom, laminate floors! Hurry WHY RENT? When with 5%down inc monthly maintenence and taxes your payments would be approximately $1291 / month??? TREMENDOUS VALUE HERE! LESS THAN RENT! Dont delay, CALL TODAY
# 317 1080 PACIFIC ST, VANCOUVER
| PRICE: $264,900 | BEDROOMS: 1 | TAXES(2010): $997 | MNT. FEE: $263 |
| SIZE: 508 Sq.Ft. | BATHROOMS: 1 | YEAR BUILT: 1981 | PARKING: 1 |
| MLS: V898484 | TYPE: Apartment Unit | SUBAREA: West End VW | $/SqFt $521 |
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 1select * 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'