I changed some positions and now my brokerage account is showing a $30,000 capital gain for this year, any way to offset this? Either through an opportunity fund investment or by accelerating depreciation on my 4 unit...

Are there any multi family real estate investors and multi family brokers that can help me  determine the average 2 bedroom rent range, average 1 bedroom rent range, price per unit, and cap rates for the following Kansas City B neighborhoods:SOUTH KANSAS CITY64137Excelsior Springs64024Kansas City64131Belton64012Downtown Kansas Ciity64108Grandview64030North Kansas City64116North Kansas City64117North Kansas City64120Ruskin Heights64134Kansas City64129Independence64050Independence64051Independence64052Independence64053Independence64054

Or some other feature that isn't as "good" as a conventional loan.  

Like a lot of people on this site I was drawn to multifamily house hacking because it allowed for the purchase of a multi family property with very favorable financing options (3-5% down) as long as you occupied one of the units as your primary residence.After speaking with multiple lenders they are all telling me that this is only through the Freddie Mac Home Possible program which has an income cap that I, unfortunately, do not meet.

Sounds like the seller is trying to give a cap rate of somewhere around 10% (just doing the math in my head). 

In NYC, there are MFs for sale. the problems are: they are expensive... like a 2% cap rate if you're really lucky, and many are rent stabilized. 

If you haven’t been to it already, the Bigger Pockets blog features links to their fantastic podcast and many great articles: https://www.biggerpockets.com/renewsblog/The site has quite a few tools that can be helpful for new members.

For example, if you are looking to connect with other members near you, want to learn from people in a specific area you’d like to invest in, or have a desire to find people interested in certain topics, you could use the search feature here: https://www.biggerpockets.com/search/usersI really like the alerts feature that can quickly guide you to current topics that may be of interest: http://www.biggerpockets.com/alerts

I really like the alerts feature that can quickly guide you to current topics that may be of interest: http://www.biggerpockets.com/alertsThere are a few self-contained guides that you can access here: https://www.biggerpockets.com/guides

The functions/features that I liked the best are now either gone or hidden so well that I can't find them.