Need advice on

I booked a last minute non-refundable stay on but I had accidentally booked it in the wrong state. I immediately let know ad I tried to get a hold of the hotel but no answer. I had gotten a message from saying that they would work on getting my refund because they could see the it was in completely different state. I waited over a week and they tell me that the hotel themselves wouldn’t release the refund so they can’t refund me the money. Is this Fair? Is there any way for me to like get a credit towards another stay possibly? I just don’t want to feel like I wasted my money.