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

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. 

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.

Each unit is individually owned, with some owners holding multiple units.A few things I’m trying to understand better:Pros and Cons: What are the main benefits and challenges of owning multiple units in a property like this with a condo setup?

Did you witness the noise violations yourself, or did your tenants provide documentation?

Appreciated reading every response on this post. 

This would be purchased as a primary home and then probably turn into a secondary home as their job would probably require a move over the years.

Read your PM Agreement to see if this is addressed.

Only cashflow about $100 at the moment, hopefully will increase after this year.

You got this!