Not sure whether this question has been posted yet. Couldn't find it on a search. Does anyone have information on an inexpensive short stay hotel/ motel in manhattan or brooklyn?

http://www.dayuse-hotels.com/en/US/

Try there, they should have a good list of choices.  This question is asked a lot.

Have fun!!

The short stays work, but are not your best option in most situations.