I'm also getting the sense that most real estate investors think putting money into an 401k, IRA, or Roth IRA is a loser's game – and I can definitely see the logic behind that argument as well. 

You transfer other IRAs or former employer plans to the solo 401k plan. 3.

Rodney,depending on how the syndication is setup the leveraged might be distributed to your IRA and therefore will make the income subject to UBIT.

We have about 100k  in retirement accounts (401k, IRA).  

As disqualified person you can't be involved in a transaction with your IRA.

A lot of forum members are very knowledgeable in their respective fields related to real estate investing, whether that is real estate sales, wholesaling, flipping, rentals, lending, self-directed IRA and Solo 401k investing, or tax and legal guidance.The site has quite a few tools that can be helpful for new members.

Just got out the barracks, in which during that time I built my credit, saved for retirement (TSP and Roth IRA) and set up an emergency fund.

IRA can't get loan any way. thanks

Can I move my money to a traditional IRA or a Roth IRA to take advantage of this provision? 

You will not be able to rollover those funds in any other retirement account.When you become eligible for a rollover, you can open self-directed IRA or Solo 401k.