More than 100 twitchers have flocked to a quiet street to catch a glimpse of an ultra-rare bird which has never been seen in Yorkshire before.