SQL query with multiple many-to-one joins
Use single quotes instead of double: 

SELECT count(*)
FROM   surveys s
JOIN   properties p ON s.property_id = p.id
JOIN   addresses a ON p.address_id = a.id
WHERE  a.city = 'Garrison'