Sorry this happened to you, Guirigay & Sweetie Pie.
We get asked quite regularly about areas around town, actual street/lane locations and are always happy to share what we know...Rob of course being better informed than I am.
It is good advice to find people that you feel you can trust here...but that takes time as it's a learning process and can't be done in a few visits or even years of visits. We have given our opinions about certain rougher locations (just the same as we would with family/friends we care about) & some will still choose to stay. They've either decided to take a chance or trusted someone else's opinion that everything was cool there...some turned out just fine, others not so much.
But as I said above...it's a learning process & you really don't know the motivation behind someone's comments/opinions until you get to know them. Same as with anyone you've grown to trust it can take years of daily interaction.
The outcome could be just fine anywhere...but if you don't have the connections yet...I would always want to go with the odds & stay at places that are well known, registered with the JTB and have legitimate security. There is a reason the JTB requires proper security on all their licensed properties!
You both deserve big credit for how you've dealt with this crappy situation!! We both find it amazing!!