EXTREMELY UNHAPPY NON-REFUNDED CLIENT!!!!!!!!

We got married on 6 August and my husband made a booking for us for 2 nights in Mosselbay at Hotel Porteo Diaz. We were so excited for this stay in Mosselbay. When we arrived in the town, we google'ed the location of the hotel and it took us straight into the rural area of Mosselbay. The "hotel" was located next to a local shebeen/tavern and a meat store. We could not stay there. When I complained about this Booking.com said I should have seen that the area is D'Al****a in Mosselbay - how would I know this??? Should I google each area? The photos are misleading.

I phoned the reservations dept of the hotel and informed them that I am not able to spend my honeymoon there and they assured me that it is okay and we could cancel and we should visit the premises the next day to collect our refund. The next day came and they said they cannot refund us as they have not received the funds yet. We then contacted Booking.com who said they were unable to help as the booking was made through a 3rd party - how should be have known this if we booked on Booking.com???? It has been 3 weeks and neither Booking.com or the hotel can assist with giving us a refund?? They keep saying a 3rd party is involved, but who is the 3rd party?

And each email from Booking.com says the same DAMN thing!! We cannot win