We use to live at Lakeside at Campeche, near the west end of Seawall. We had a large two bedroom, two bathroom apartment for $650/month. We liked living there.
If you're looking in a higher price range, there are many beautiful condos in Galveston that overlook the water.