I know someone who does this but they won’t give up the secret.  

I am wondering if anyone has been and this situation and has ideas on how to handle this.

@Rene Hosman will be able to help you figure this out.

You can easily do this on a spreadsheet and it will take less time to track than it would to find and learn a new software.

When it comes time to sell this property, what will happen then?

Most municipalities have different mix-use categories which dictate the precise commercial use that's allowed.A few additional observations on mix-use assets and how I approach them (1) they are generally more difficult to finance than multi-family assets so expect lower leverage terms even if the property performs just as well if not better than a multi-family property and therefore price this into your acquisition (2) I focus on mix-use assets where at least 80% of the income is generated through the residential component.

We meet on the first Tuesday of every month and I've made a lot of great connections and done deals with a lot of people I've met in the room (I've been going for over 3 years now and only started co-hosting it this year).

I wanted to bump this thread.

So if this means that a person without license can PRIVATELY market an equitable interest?

From this CT information, it looks like it is an offset against your capital gains from other property, so you would have to find investors with significant capital gains and/or have them yourself.