I have friends who live on a shallow canal (less than 3' at winter low tide).
They bought a newer beneteau 31 with a centerboard and twin rudders because they could keep the boat at their home. It sails pretty good when the board is down and could do the Gulf O.K. I think they paid around 65k a few years back and you might be able to get one a little less than that now.
It would be a little cramped for a couple for even a weekend but do-able. You could look into one of these they may even make a 34 in this configuration not sure.