agoda complaint: Refund from agoda on hotel booking

Summary of the issue

Original intention was to book for a 2 night hotel stay at genting resort
Unfortunately by an error or to your system glitch 24 nights booking has been generated from the booking system , we have gone ahead and acknowledge the booking thinking it’s the 2 nights booking , upon completion payment we realized the error in booking we immediately contacted agoda customer service requesting to cancel or amend the booking despite many email exchanges and phone calls we are yet to receive a favorable response. Apparently agoda have used 3rd party to make this booking who seems adamant to amend cancel booking . 3rd party agent continues to say this booking is non refundable hence cannot be canceled without claiming 100% value . We have spoken to the hotel and understand below situation
1 ) as per hotel booking can be amended cancel since there are almost 3 months to go

2) as per hotel maximum night per booking will be 7 nights Hence hotel also acknowledge that this is human error or system related issue

3) since the booking with hotel done by 3rd party agent agoda there unable to entertain any cancellations request from us . overall we feel 3rd party agent is not making an effort to sort out the issue in favor of us
Seek agoda’s help to find a suitable solution since the cost involved is sgd 8000 against actual value of 600

4) as per hotel there is no such rules has non refundable against this booking