Mentions of The Rose of Avondale here do seem to be from people who have just got the title of The Rose of Allandale wrong, sometimes as the result of an imagined Irish connection. There is a Blackbird of (Sweet) Avondale (which is Irish), and American songs about a mining disaster at a place of that name, but I don't find any useful references to a Rose of Avondale; though I do have an old LP of a Pipe Band playing a tune they call by that name; it's The Rose of Allandale, though, with the wrong title. Is there actually a song of that name at all?