The Returning (1990)

A successful city lawyer abandons his practice and heads out to the country. There he comes upon a stately, but neglected, homestead. He moves in, and during his first night a beautiful ghostly woman makes love to him, in his sleep. Soon his dreams become more engrossing than his everyday world and girlfriend. Gradually he unravels the tragedy of his spirit lovers' past. To respond to her call, he needs to embrace the hearafter.

Horror, Thriller