sand will last many years when added to paint. the thing to remember is to use a good quality paint in an eggshell or satin finish. only add about 1 cup of sand. if you add too much,your paint won't stick. remember that when you add texture,your paint won't go as far.