We stayed at Luca's apartment for 5 nights and would definitely recommend the flat.
We were only 10 minutes walk from St Mark's square but it felt secluded and quiet. You are minutes from the Arsenale stop where the number 1 boat stops so it is easy to get around the whole island.
I used the sofa bed which was comfy and the kitchen and bathroom were great too.