Prime Location! Under $390,000. It doesn't get better than this. Close to schools, transit, great area of Pitt Meadows. All you have to do is move in. The home has been renovated including: new paint & mouldings, new carpets, new kitchen co untertops, vaulted ceiling, skylight, formal dining room. Fully fenced rear yard, bring the kids, sandbox and swing set. It does not get better than this. Quick possession is possible. Very easy to show. Seller is anxious! Call for your tour.

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'