The Naked Detective(1996)

Low-rent private dick Sam Drake is called on to identify which heir is trying to kill a wealthy old man. At the old gentleman's mansion, he encounters an assortment of beautiful women who in turn engage him in all sorts of unpredictable and zany sexual situations spoofing the detective genre clichés.