Top 5 reasons this house may be perfect for you;

#1 - LAY-OUT - Unique 2800+ sq/ft multi level floor plan with 4 bedrooms, 4 bathrooms, huge 2 car garage, 2 dens/rec rooms and an awesome deck 

#2 - MORTGAGE HELPER - Fully functional basement suite with excellent tenants looking to stay (paying $800 per/mth)

#3 - VIEWS - Excellent views of sun rise, Burke Mtn, Mt Baker, Golden Ears, and Pitt River

#4 - EXTRAS - Real hardwood through-out, slate kitchen and ensuite, 2.5 year old roof, newer hot water tank, and crown moulding

#5 - LOCATION - Close to multiple schools, parks/playground, walking paths, and walking distance to the good old Gilnetter

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'