YO-257 and San Pedro are 50 yards apart.. and you can dive thru both of them on a single dive.
The YO-257 is 99fsw in the sand, 80fsw at the deck, 60fsw at the wheelhouse.
The San Pedro is 80fsw in the sand, 60fsw at the deck, and the wheelhouse has collapsed at 60fsw.
However, another Waikiki shipwreck you may consider is the Sea Tiger.. 120fsw in the sand, 99fsw at the deck, 70fsw at the wheelhouse.
I prefer the YO-257/San Pedro wrecks.. because they're just a bit shallower so you get more bottom time.. there are usually sharks within the San Pedro.. it's fun watching the submarines do laps around you.. plus, you get two-for-one
The Sea Tiger is cool too.. if you like to penetrate deep wrecks.. and shoot thru all the corridors and holds.
Dive Oahu has a boat and shop out of Kewalo Basin.. and they go to either all the time.