Is tempted the final house of night book?

No, "Tempted" is not the final book in the House of Night series.

The final book in the series is "Redeemed", which was published in 2013.

"Tempted" is the 9th book in the series.