Ps 102:16
For the LORD will rebuild Zion and appear in his glory.
In the millennium, the Lord will rebuild Jerusalem and He will appear there, once again coming to “tabernacle” with His people. 

Ps 102:18

Let this be written for a future generation, that a people not yet created may praise the Lord.
What a wonderful way to think about Scripture - that it was written with us in mind so that we may read it and praise His name.

Psalm 106 is an example of reviewing all the things that God has done for His people.  Something that we should do as well - remember all the things that God has done for us collectively as a nation, as a church, and as individual believers.

Ps 102:25-27
In the beginning you laid the foundations of the earth, and the heavens are the work of your hands. They will perish, but you remain; they will all wear out like a garment. Like clothing you will change them and they will be discarded. But you remain the same, and your years will never end.
The earth and the heavens will one day perish. 

2 Pet 3:12-14
as you look forward to the day of God and speed its coming. That day will bring about the destruction of the heavens by fire, and the elements will melt in the heat. But in keeping with his promise we are looking forward to a new heaven and a new earth, the home of righteousness. So then, dear friends, since you are looking forward to this, make every effort to be found spotless, blameless and at peace with him.
The heavens will be destroyed by fire and there will be a new heaven and a new earth.

Rev 21:1-2
Then I saw a new heaven and a new earth, for the first heaven and the first earth had passed away, and there was no longer any sea. I saw the Holy City, the new Jerusalem, coming down out of heaven from God, prepared as a bride beautifully dressed for her husband.

What an image!