The best opaque treatments tend to last the longest. But you may prefer a semi-transparent or clear finish for aesthetic reasons. Solid wood stains: Just like regular paint, solid stains hide the ...