u/Beginning-Reserve-18

I am moving to Charleston from New York for work and am having trouble finding a place due to breed restrictions. I am NOT getting rid of my dog (who is super friendly,sweet and loving)and I HAVE to move bc of work. It seems insane any decent place I can find won’t allow my dog and then the places that do allow him don’t always seem in the nicest of neighborhoods or have terrible reviews of infestations or maintenance issues,etc. I can’t be the only one this has happened to? I also cannot seem to find regular landlords renting out houses with apartments in them? When I search I just see lots of complexes. Any help is appreciated thank you!