For a "meet the people" experience, often we use craigstlist.org in sublets for the city we are looking at and have had some awesome experiences in Moscow and Argentina. We actually rent our garage apt out in Tulsa for the short term traveller and have had some great people.

When in Ireland we have just mooched off the family.

Mike