Need advice on booking.com

I booked a last minute non-refundable stay on booking.com but I had accidentally booked it in the wrong state. I immediately let booking.com know ad I tried to get a hold of the hotel but no answer. I had gotten a message from booking.com 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.