It is a horror movie where a man enters a house trying to solve a supernatural activity disturbing the people living there.
However, it turns out that all those people are actually ghosts that had been trying to attract him to kill him
This man loves the girl there without knowing that she is a ghost actually, and she pretends to have a jealous husband who is always angry with everything she does but turned out to be her brother
Another good spirit tries to help him face them and helps him actually overcome their evil
Nevertheless, the last scene reshows the girl that seduced him as a mark that she will keep chasing him or others

I forgot the actors, the name of the movie and everything else, but it is not new release
it was produced something like late 1990s
please help me find its name
many thanks in advance

Unselected an answer