I highly recommend Marlin Court. The apartment we stayed in was spotlessly clean and very comfortable. Its just a short walk from the centre of Paihia and the staff were super helpful. Would definitely stay there again if we're in Paihia.