I'm pretty sure that if all holders of a certain surname dies, so does the surname. The lineage is no more.
Of course, you may have a situation in which a surname is lost due to marriage, but the family still has ownership of the properties.
If the entire family of characters die, regardless of by marriage or by surname, ?I'd imagine the property AND the surname are no longer yours.