Ke Iki Beach Bungalows has the best location of any vacation rental on the island of Oahu. Located on part of Sunset Beach this one of the rare legal vaction rentals on the water in Hawaii. keikibeach.com
Looking for other vacational rentals or other fun stuff to do on the North Shore check out northshore.com
If you don't want to go for the big ones and/or can't afford to go deap sea fishing maybe a two to three hour trip on the Nani Kai is best for you. gofishinghawaii.com