North of W 4th - Corner one bedroom with S/W/N exposure and 3 balconies. Kitchen updates include cabinets and appliances. Large dining bar built to create an open floor plan. Cozy W/B fireplace in living room, opening to large balcony. Fres h coat of paint and new carpeting makes this suite move-in condition. Bonus: insuite laundry, parking and storage. Building - rainscreened, updated plumbing and new roof. Pets w/ restrictions, no rentals. Open house Sunday November 21st 2-4 pm.

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'