Sure, no problem.
I have two TVs, one in my basement bar (60" Vizio) and one upstairs mounted on the wall (47" Vizio)
I have an antenna mounted in a closet upstairs to pick up ABC, NBC, CBS, FOX, IPTV, etc. This signal is distributed thoughout the house via coax cable in the walls.
Connected to Basement TV and Why:
Coax from antenna to get local channels
Xbox One to watch SlingTV (ESPN, TNT, TBS, etc), any of the apps on Xbox One and play games
Apple TV to watch NBC Sports Network (there's an app on there) or any other apps. I also use the Apple TV to airplay music to the sound system in my basement bar area
All of these devices are wired into my internet (50 MBps connection, not great but definitely solid for what I'm doing)
Connected to upstairs TV and Why:
Apple TV to watch NBC Sports Network, WatchESPN app, AirPlay anything from iPad
Fire TV to watch SlingTV and Fox Sports Go app and also Kodi (formerly XBMC)
These devices are connected to my wireless network
At the moment, I use the Fire TV and Apple TV to get just about any of the streaming apps I need. Unfortunatley, the Apple TV has some apps the Fire doesn't (NBC Sports net) and the Fire TV has apps the Apple TV doesn't (SlingTV, Fox Sports Go). Hopefully someday I can cut down to just one box or the other, but for now I'm set with what I need for sports.
Oh, and for Cyclones.TV I usually just hook a PC up to either of my TVs and go to the website. You can also AirPlay to watch as well.
I should make a video of my setup and share it - it's hard to type
To answer your multiple TVs question. The only thing that I can't do at the same time on both TVs is Sling. This usually isn't an issue though because my wife can watch Sling HGTV or whatever and I can use the WatchESPN app or do something that isn't on Sling. The rest of the apps don't care how many simultaneous streams you do and my connection handles it without a hitch.
If you have a large family then things can get trickier I'm sure.