I once lived on a clifftop that looked straight out to sea, which was pretty groovy! But I grew up on a river, and I've loved river cities ever since. They don't get much more beautiful than Budapest on the Danube (or 'Duna'). The river once marked the border of the Roman Empire.