There are two airports that will get there. Tampa (TPA) and Clearwater (PIE). Both are about 30-40 minutes from Madeira Beach ($40-$60 Uber/Lift). You can rent a car if you want, but once you arrive at the hotel, you most likely won't need one. Everything is within walking distance.
John's Pass is 2 blocks to the South. There are souvenir shops, restaurants and bars.
Circle K is 2 blocks to the North. This will have all your snacks and alcoholic and non-alcoholic needs.
Winn Dixie Grocery is 1 1/2 miles North
There is a trolley that runs every 30 minutes up and down Gulf Blvd (everywhere you need to go). There is an app you can download to see where the trolley is on route.
Alcohol is allowed on Madeira Beach, but no glass containers.
The Hotel has a ice machine and a coin laundry
Bring a floaty for floating!