The story in this movie is about granddaughter who was separated from her Grandmother as a young girl by her mother. Later on in life the granddaughter has became successful in her own way, but also having nightmares about her child hood past. She becomes aware that her grandmother dies and leaves a rundown hotel-bed and breakfast type place, I think on the Cape, she returns to this place where she was token away as a child and she must find a key that is found inside the piano keys that pertains to the lock box that has the will or wishes of her Grandmother and explains the truth of her mother's break away, as well starting to piece together the past that has been haunting her from childhood. Then turns out she finds the truth in a situation that takes place while she is there and falls back in Love with her childhood sweetheart that was involved with a misconception of her haunting and takes over the place of her grandmothers They start a new generation of life and family and business at this place.
Thank you anyone for your help... Great Movie

Finding Home (http://portlandme.about.com/od/entertainment/a/FindingHome.htm) looks a likely candidate.