There are various unique weapons in AWoIaF.
A longword owned by Thoros of Myr has flame effects. Its item name only displays it as generic Longsword however.
Wildfire is a throwing weapon with an AoE. See: Wildfire
The whitewalkers carry Ice Cleaver and Ice Sword