For passengers only, you can take the Tangalooma Flyer from Pinkenba. (Google)
Otherwise if you want to bring your 4×4 you must use the Micat Barge. (Google)

The property address is, 8 Cowry Close Tangalooma.

Situated on the top of the beautiful bay view estate directly behind Tangalooma Resort.