SOLD THE CUP-OF-JOE-AND-SUNRISE PATIO ALONE IS ENOUGH FOR US
THE CONDO: 2BED/2BATH & 2PARKING, also has a solarium ( aka sunny bonus room) AND balcony. Have peace of mind in this fully rainscreened concrete highrise. Pets and rentals allowed. LOCATION: On a quiet street with a serene outlook onto East Van treetops but walking distance to all the shops & entertainment to fill your boots on Commercial Drive. LIFESTYLE: Community & convenience, yet quiet... now that's east side living!
# #705 - 1833 Frances St, Vancouver
| PRICE: $389,000 | BEDROOMS: 2 | TAXES(2012): $1,419 | MNT. FEE: $250 |
| SIZE: 875 Sq.Ft. | BATHROOMS: 2 | YEAR BUILT: 1991 | PARKING: 2 |
| MLS: V1003375 | TYPE: Apartment Unit | SUBAREA: Hastings | $/SqFt $445 |
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'



-