Also this song was played in " how i met your mother season7 episode17" at the end of episode.

Are you looking for a song, a movie, or a myth or folklore with a woman in a red dress?

You put this in the mythology and folklore forum, and I'm a bit confused what you're asking for.