Hi @Michael Douglas,
I'm biased, but Raleigh-Durham-Chapel Hill is a great area! Congrats on your impending move! There is a BP meet up that occurs once a month - once you're here, I'd encourage you to get involved to build the network!
I don't want to come across as negative, but just know that STRs within Raleigh City Limits is difficult as the outgoing City Council passed some incredibly restrictive covenants in the summer of last year specifically in regards to STRs. Further, as of the end of 2019, some additional restrictions were:
1) The homeowner must live onsite of the STR (no living next door or somewhere else in the city); 2) You can only rent out up to 2 BRs max of your home to 2 adults and accompanying minor children; 3) No whole-house rentals; 4) STRs cannot have their own kitchen space; 5) Homeowner must keep a record of all renters over the past 3 years; 6) Backyard cottages (or other Accessory Dwelling units (ADUs)) can NOT be used as STRs; 7) You must notify your neighbors and apply for a permit to operate as a STR. Google "Raleigh Homestay Rules" for a full list.
Now like I said, this was the outgoing City Council at the end of 2019. The newly elected City Council held a preliminary vote in March 2020 to change and modify these rules to be more in favor of STRs, and decided at that meeting to review the rules at a later date. To my understanding, this included allowing ADUs to be used as STRs and no longer requiring you to notify your neighbors of applying for a STR permit. However, you still need to apply for a permit. Interestingly, there was some fierce infighting going on, but then Governor Cooper signed an update to the state's Vacation Rental Act (VRA) which prohibits local cities/governments from requiring STR owners to get a permit. Now the City of Raleigh is still requiring you to apply for a permit...how that jives with the Governor's update to the VRA....well, that will be decided in courts, eventually.
Of course, that March 2020 vote was just a Preliminary vote to determine if there was a desire to change those rules. By the end of March (1 month after that vote) COVID was in full swing, and I haven't seen or heard anything since. So as of now, the restrictive covenants are still in place.
That was a very long winded way of saying: the STR market in Raleigh is in flux and is currently not very favorable to investors. Be aware that there's no telling what's going to happen. You may consider looking in Chapel Hill/Carrboro, as that has traditionally been, and continues to be, a market that looks much more favorably on STRs. I don't know as much about Durham, but some of my network told me they tend to follow what Raleigh does.
Quick disclaimer - I don't currently own any STRs (I own LTRs), but it's a market area I've been exploring and researching extensively. Again, not trying to be a Debbie-Downer, but just wanted to make you aware that the STR policy in Raleigh is tough.