Happy New Year !!
The house is at the top of the hill (which implies that you will need to climb the street) and has a lovely sea view from the kitchen and terrace.
It is 5 walking minutes from the Cathedral, Titanic museum and city centre. 10 walking minutes are needed to the train station.
Cork is at 25 min by train.