Where is Roselia found in Pokemon Emerald?

Roselia can be found only in Ruby/Sapphire, on Route 117. Unfortunately you can't. Roselia can't be caught in the wild in Emerald. With that being said, it may be possible in a copy of Ruby or Sapphire, and you could trade it over. Otherwise, you're pretty much sunk.