Warm Water Under a Red Bridge(2001)

When a dying friend tells out-of-work salaryman Yosuke about a hidden treasure, he sets off in search of the only clue about its location: a house by a red bridge. What he finds instead is a woman who transcends all his fantasies.