Lots of people in NYC use Trusted Sitter which is exactly that - you get to stay (for free) in someone's apartment and take care of their pets. It's a great gig.