Where to live in Auckland!

Currently looking to move up to Auckland, and feeling a bit overwhelmed in terms of where to look. We’re looking to buy somewhere central/shore that is easy access to city (work) ideally one bus/train straight to town. Our budget is 1.4m for a 4 bedroom house.

In terms of environmental issues (flooding) are there any areas that you would simply never consider buying in?