To have a solid return on this project; I don’t want to spend more than 300k on the foundation.

I have a pier and beam foundation and have had Texas fair plan for two years but they are refusing to renew it unless 3 other companies turn me down. 

If you're novice then it will give you a good basic foundation.

You know the house exists (don't ask, there is a story there), can see the roof, foundation, windows, siding, etc.  

Sounds like you are coming from a very strong financial foundation (HUGE achievement in itself).

It already has new carpet, new appliances, AC was replaced only 2 years ago, foundation was leveled out (raised foundation), and a few other repairshave already been made.  

I want to work as an agent to help build my foundation, create contacts, and establish a reputation.

Nothing major though, no foundation, roof, or large system replacements but we are capable DIY'ers and don't mind pouring sweat equity into a property to increase the value.Our plan is to do a modified BRRRR. 

You have a great foundation to build from.

The 2 things you need to be looking for are 1) Water damage and 2) foundation damage, with foundation damage being the worse of the two.