I also write music for TV/film/video and generate a modest supplementary income from that, but I want to have a cash flow to fall back on/fund bigger and bigger deals. 

If you mean construction cost, the elements of that line item alone is composed of two major sub-line items being hard cost (slab up) and site work which is further bifurcated into on and off site costs.

The food, art, music, craft beverage scenes are all flourishing as well.

I'm just starting out in real estate and real estate investing and I'm anticipating doing a fair amount of driving. as much as I love music, I know that my time behind the wheel would be better spent listening to audio books. that being said, any recommendations?

Play your own music.

The city council is also going to vote this evening on allowing for a 5 year contract for Superfly Productions to take over Overland Golf Course for 5 weeks (think Coachella Music Festival).  

I've done my reading and practice on analyzing properties and Im more confident than ever in moving forward with the next move, purchasing the first rental property (releases the doves and plays the holy music).

We are house hacking a 4 plex and have one tenant who once a week or so plays music loudly, with (I assume) a subwoofer.  

I know it is kind of confusing, but it will look something like this:Wife sells to LLC------------------> Partnership LLCWife receives SOME cash to balance out the 'equity' shares.Partnership LLC is composed of the following, all equal partners:AG SD Roth CashAG CashPartner 1 CashPartner 2 CashWife ~ Equity shareWould this be considered a 'prohibited' transaction for my SD-IRA?

On a side note I was an audio engineer/music business person in a past life too :)