Mermaid movie before 2007, she lives in a pool vent

After Hans Christian Andersen's heroine turned into sea foam, the fairies of the air took her to them with promises of receiving a human soul after 3,000 years of service.

Two carnies (Sewell and Gugino) abduct a mermaid in Ireland, circa 1900, and decide to transport her to America. As their ship loses its way and heads towards the mythical Forbidden Islands, the mermaid begins to display its deadly side.

A young mermaid comes to New York to pursue her dream and reach the Pacific Ocean. Guided by the music, she embarked on a journey of self-discovery across the United States. The people she meets on the way think her to be a muse and guide her to the stars of Hollywood. But what has become of the American dream?

Believing in the existence of mermaids, a 7-year-old girl drifts into her secret fantasy world as she observes her mother pine with wasted love.

There's something in the water.

A mermaid addicted to plastic finds herself trapped in an apartment building as she slowly disrupts the boring lives of two neighbors. Will they escape the hidden desires that are awakened by the Mermaid?

A mermaid is ripped from the Pacific, her tail is chopped off and she's thrown into a mental home where no one believes she is a mermaid.