Its a film from 1990 with Melanie Griffith and Michael Keaton.
A yuppie couple buy a large house in an exclusive San Fransisco neighbourhood. They renovate it and plan to rent two apartments on the first floor to cover the costs. A prosperous looking man moves in but is not the ideal tenant. He never pays any rent, drives the other tenants away and systematically ruins the lives of his landlords.
Ive searched for a couple of weeks now but may have missed somewhere, any help appreciated.