Ron Hynes and Murray MacLaughlin's 'No Chnage in Me' has the great opening line of:

You could shoot off a cannon in the middle of Bond
And attract no attention in downtown St John's

There's also Gary O'Driscoll's 'Out from St Leonards' which as well as the place named in the title also mentions Placentia and Stephenville (and Toslow, and Toronto)

Both are Newfoundland songs of course.