What Conditions of the Property Drop the Deal?

[Parker Staten Rish]

I am brand new to real estate investing, and I have already assembled my team, and I am looking to purchase my first house hacking. I was wondering what other investors thought about purchasing conditions for housing. When you buy a rental what scares you away? For example, I found a home in an ok neighborhood that cash flows at 300 dollars a month with an ROI of 30%; however, would slight foundation issues (which are really common in my area on 99% of housing here) scare you away? Also, when you do purchase a rental what kind of inspections are done or do you do them yourselves?