"Do these areas actually have 'good' cycling infrastructure? And public transportation?"

Aye, LIC-NYC is ok on both. It's a mixed residential and commercial zone.
And if the building is tall enough; nice views of Manhattan:

Long Island City, NYC by 1nterceptor, on Flickr