USA
ROM
|
People
Articles
Regions
Download
Lists
Schools
News
Movies
Sites & Blogs
Couples
Questions
Quotes
Born Today
Born Where
Fame Schooling
Movies
Famous Lists
SHOCK!
Quotes
Zodiac
Sites/Blogs
Couples
Famous Movies
Comedy
Short
Family
Animation
Crime
Film-Noir
Drama
Biography
Adventure
Documentary
Musical
Romance
Action
Mystery
Western
Music
War
Fantasy
Western
History
Thriller
Sci-Fi
Sport
Horror
Game-Show
comedy
horror
thriller
News
Reality-TV
Action/Adventure
Kids
and
Adaptation
action
adventure
science fiction
fantasy
adaption
Adventure
Fantasy
Talk-Show
Romance
Kids/Family
Sequel
Art/Foreign
Drama
Science Fiction/Fantasy
Acion
Action,
Comedy
Family
Thriller
Crime
Mystery
Comedy
Sci-Fi
Action
Crime
Aquamarine
Short Info
No plot avaivable
Genre
Comedy
Family
Fantasy
Release Date
2006
Duration
104 minutes
Produced By
Susan Cartsonis, Steven R. McGlothen
Directed By
Written By
Cast
Related Movies
Related Links
Elizabeth Allen
John Quaintance
Jessica Bendinger
Alice Hoffman
Emma Roberts
Joanna 'JoJo' Levesque
Sara Paxton
Jake McDorman
Arielle Kebbel
Claudia Karvan
Bruce Spence
Tammin Sursok
Roy Billing
Julia Blake
Shaun Micallef
Lulu McClatchy
Natasha Cunningham
Dichen Lachman
Lincoln Lewis
Matthew Okine
Regis Broadway
Robbie Parkin
Joey Massey
Dillon Stephensen
Donna Fox
Alice Hunter
Adam King
Nathan Lockwood
Jess Smith
Chris Brady
Dave Gilbert
A Bad Day
2006
A Bad Day
2007
A Bad Day ...
2009
A Bad Spel
2001
A Bakery S
2009
A Balancin
2007
A Ball and...
2008
A Balmy Kn
1966
A Banana
1997
A Bear for...
a_bear_for_punishment_picture.jpg
1951
A Beating
1991
0
Seen it
0
people
Love it
0
people
Hate it
0
people
Ask a Question
Tell a friend
Create a Poll
Edit this page
Movie Quotes
Add a trailer
Ask a Question about Aquamarine
Search a movie
reviews
popular
box office
Error at line:
1055 : Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'famousw_famousdata.movie_reviews.mr_entry_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Sql
SELECT m_name,m_id FROM movies,movie_reviews WHERE m_id = mr_movie_id GROUP BY m_id ORDER BY mr_entry_date DESC LIMIT 10