It can be difficult to work through so many things in a single response so I will go with the first two points that you have additional questions about:
I will try to explain No 4 a little better, I would like to add some text links in the top right of the page to other pages, such as Home, About, Lettings, Sales & Contact, these pages will have information that won't change or doesn't need to be changed.
In this first part are you referring to converting the text input to a select list? If so then yes you can make this select list static, the entries must match the term that you will be searching for though. If you have the values in your db then you should be able to make a recordset and set that as the source of the select list. This way if any of the values are updated in the db this list would be updated automatically.
You can add in links or a static menu on any of the pages, if the page is template derived then you will need to make sure that you add this to an editable region of the page. Let's try to work out these issues first before going on to any of the others. It is best to work on these things one at a time.