@Alia Ali congrats on making the decision to jump in!
For a house hack, I think primarily you want to find a neighborhood you're comfortable in, then try to find the best deal possible within that neighborhood. If you're not comfortable you won't last long. When you find several neighborhoods that could work, maybe try reaching out to owners of houses you're interested in to see if they're willing to sell. If I were you, I'd try Midtown/ Ventura Village/ Phillips/ Powderhorn in Minneapolis, or Midway/ West St Paul/ Payne Phalen in St Paul. I recently went to Dayton's Bluff and it was amazingly nice with relatively low prices.
I'm not a wholesaler and would never never never plan to be but off top of my head I'd think about what type of ppl would want to sell their houses cheap - ex areas with lots of run down rentals owned by out of state owners, lots of retirees with equity, etc. A neighborhood full of young millennial families who put 3.5% down on a 400k mortgage 2 years ago would not be the neighborhood to look..