Arvedui was indeed the last king, as his name signifies. It is said that this name was given to him at his birth by Malbeth the Seer, who said to his father: "Arvedui you shall call him, for he will be the last in Arthedain. Though the choice will come to the Dúnedain, and if they take the one that seems less hopeful, then your son will change his name and become king of great realm. If not, then much sorrow and many lives of men shall pass, until the Dúnedain arise and are united again.
 

...Listen! This is the word that the sons of Elrond bring to me from their father in Rivendell, wisest in lore: Bid Aragorn remember the words of the seer, and the Paths of Dead.
' And what may be the words of the seer?' said Legolas.
' Thus spoke Malbeth the Seer, in the days of Arvedui, last king at Fornost', said Aragorn.

Over the land there lies a long shadow,
westward reaching wings of darkness.
The Tower trembles; to the tombs of kings
doom approaches. The Dead awaken;
for the hour is come for the oathbreakers:
at the Stone of Erech they shall stand again
and hear there a horn in the hills ringing.
Whose shall the horn be? Who shall call them
from the grey twilight, the forgotten people?
The heir of him to whom the oath they swore.
From the North shall he come, need shall drive him:
he shall pass the Door to the Paths of the Dead.