Top 5 reasons this Townhouse is AWESOME #1. Unique and desirable End unit with views of the Mountains. #2. Located right across from Clubhouse and easy access to extra parking. #3. 3 Levels of great space. 3 beds, 2 baths, and your own garage. #4. Mallard place is a great family friendly complex. All units are owner occupied. #5. Price SHARP !!! 

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'