INVALID SQL: 144 : Table './mb411/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:SELECT COUNT(*) FROM xcart_sessions_data WHERE sessid='d3d7ee37039547713e76e763b9aabf5f'
INVALID SQL: 144 : Table './mb411/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:SELECT sessid FROM xcart_sessions_data WHERE expiry < '1734787478'
INVALID SQL: 144 : Table './mb411/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:SELECT * FROM xcart_sessions_data WHERE sessid='d3d7ee37039547713e76e763b9aabf5f'
INVALID SQL: 144 : Table './mb411/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:REPLACE INTO xcart_sessions_data (sessid, start, expiry, data) VALUES('d3d7ee37039547713e76e763b9aabf5f', '1734787478', '1734791078', 'a:1:{s:17:\"_saved_session_fg\";s:32:\"fac378ac3b3d3886829021b3309d4fd1\";}')
INVALID SQL: 144 : Table './mb411/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:SELECT data FROM xcart_sessions_data WHERE sessid = 'd3d7ee37039547713e76e763b9aabf5f'
INVALID SQL: 144 : Table './mb411/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:UPDATE xcart_sessions_data SET data = 'a:2:{s:11:\"is_location\";s:0:\"\";s:9:\"adaptives\";a:1:{s:14:\"is_first_start\";s:1:\"Y\";}}' WHERE sessid = 'd3d7ee37039547713e76e763b9aabf5f'
INVALID SQL: 144 : Table './mb411/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:SELECT data FROM xcart_sessions_data WHERE sessid = 'd3d7ee37039547713e76e763b9aabf5f'
INVALID SQL: 144 : Table './mb411/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:UPDATE xcart_sessions_data SET data = 'a:23:{s:14:\"is_new_session\";b:1;s:11:\"editor_mode\";s:0:\"\";s:8:\"is_robot\";s:1:\"N\";s:5:\"robot\";s:0:\"\";s:11:\"is_location\";s:0:\"\";s:9:\"adaptives\";a:1:{s:14:\"is_first_start\";s:1:\"Y\";}s:11:\"logout_user\";s:0:\"\";s:26:\"session_failed_transaction\";s:0:\"\";s:16:\"add_to_cart_time\";s:0:\"\";s:17:\"always_allow_shop\";s:0:\"\";s:11:\"search_data\";s:0:\"\";s:22:\"https_redirect_counter\";i:0;s:24:\"https_redirect_forbidden\";b:0;s:4:\"wlid\";s:0:\"\";s:10:\"js_enabled\";s:1:\"Y\";s:11:\"top_message\";s:0:\"\";s:15:\"referer_session\";s:51:\"http://secure.miamibeach411.com/airport-hotels.html\";s:5:\"login\";s:0:\"\";s:10:\"login_type\";s:0:\"\";s:11:\"identifiers\";a:0:{}s:6:\"logged\";s:0:\"\";s:14:\"remember_login\";b:0;s:13:\"remember_data\";s:0:\"\";}' WHERE sessid = 'd3d7ee37039547713e76e763b9aabf5f'
INVALID SQL: 144 : Table './mb411/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:SELECT data FROM xcart_sessions_data WHERE sessid = 'd3d7ee37039547713e76e763b9aabf5f'
INVALID SQL: 144 : Table './mb411/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:UPDATE xcart_sessions_data SET data = 'a:28:{s:14:\"is_new_session\";b:1;s:11:\"editor_mode\";s:0:\"\";s:8:\"is_robot\";s:1:\"N\";s:5:\"robot\";s:0:\"\";s:11:\"is_location\";s:0:\"\";s:9:\"adaptives\";a:1:{s:14:\"is_first_start\";s:1:\"Y\";}s:11:\"logout_user\";s:0:\"\";s:26:\"session_failed_transaction\";s:0:\"\";s:16:\"add_to_cart_time\";s:0:\"\";s:17:\"always_allow_shop\";s:0:\"\";s:11:\"search_data\";s:0:\"\";s:22:\"https_redirect_counter\";i:0;s:24:\"https_redirect_forbidden\";b:0;s:4:\"wlid\";s:0:\"\";s:10:\"js_enabled\";s:1:\"Y\";s:11:\"top_message\";s:0:\"\";s:15:\"referer_session\";s:51:\"http://secure.miamibeach411.com/airport-hotels.html\";s:5:\"login\";s:0:\"\";s:10:\"login_type\";s:0:\"\";s:11:\"identifiers\";a:0:{}s:6:\"logged\";s:0:\"\";s:14:\"remember_login\";b:0;s:13:\"remember_data\";s:0:\"\";s:7:\"old_lng\";s:0:\"\";s:20:\"is_switched_language\";s:0:\"\";s:4:\"cart\";s:0:\"\";s:23:\"require_change_password\";s:0:\"\";s:16:\"login_antibot_on\";s:0:\"\";}' WHERE sessid = 'd3d7ee37039547713e76e763b9aabf5f'
Miami Airport Hotels Directions to Dowtown - Miami Beach 411 Travel Store
Main Site» Miami Beach 411 Travel Store » Miami Airport Hotels Directions to Dowtown

Miami Airport Hotels Directions to Dowtown


View Miami Airport Hotels To Downtown Miami in a larger map

Taking the bus to Downtown Miami

Are you staying near Miami airport? Want to go sightseeing with us? it's easy to take the city bus to our main pick-up location. Here's how:

Hotels South of the Airport

Doubletree, Spring Hill Suites, Homestead Studios, Hampton Inn, Sofitel, Hyatt Summerfield, Homewood Suites, Hilton, Airport Regency, Crowne Plaza, Fairfield Inn, Miami Princess.

  • On NW 7 St., board the "Route 7" Bus, eastbound

  • Get off the bus in Downtown Miami at NE 3 St.

  • Walk two blocks east to our main pick-up location at the Holiday Inn Hotel (340 Biscayne Blvd.) Route schedule

The ride takes about 45 minutes. Contact us for help.

Hotels North of the Airport

Embassy Suites, La Quinta Inn, Holiday Inn, Red Roof Inn, Sleep Inn, Homestead Studio, Comfort Inn, Days Inn, Runway Inn, Hotel Aladdin, Fantasy Inn

  • On NW 36 St., board the "Route 36" Bus, eastbound

  • Transfer to the "Route 2" Bus at NW 2 Ave., southbound

  • Get off the bus in Downtown Miami at NE 4 St.

  • Walk three blocks east to our main pick-up location at the Holiday Inn Hotel (340 Biscayne Blvd.) Route schedules

The ride takes about 55 minutes. Contact us for help.

Driving directions to Downtown Miami

Take the Dolphin Expressway East to I-395 East. Exit at Biscayne Blvd. At the end of the off ramp, continue eastbound, turn right (South) onto Biscayne Blvd. and continue until you reach NE 2nd Street. Make a U-turn at NE 2nd Street onto Biscayne Blvd., North. Go one block to NE 3rd Street and turn right (East) into Bayside Marketplace -- immediately veer left to the parking garage. After parking your vehicle, walk across the street to the Holiday Inn and meet the bus.

Where to park your car

There is a parking garage at the entrance to Bayside Marketplace, next to the American flags. An early bird parking special is available - if you arrive before 10:00 AM - you can park until 6:00 PM for $5. On Saturday and Sunday, the garage accepts cash only, payable in advance. Parking can also be found adjacent to to the mall, and along Biscayne Boulevard. See the parking map below.

After the tour, guests often ask these questions

Where to go shopping?

Within walking distance to Bayside Marketplace, there is Ross and Marshall's discount clothing store. In Miami Beach, there is a Best Buy electronics store, along with with Ross and Publix supermarket. There is a Target in Mid-Town Miami. For the Aventura Mall and Dolphin Mall, follow the instructions listed below.

What restaurants do you recommended?

At Bayside Marketplace, Bubba Gump Shrimp is good, and Chili's restaurant has the best view.

For a casual meal in Miami Beach, we recommended, Puerto Sagua, Cardozo, Rice, Grill Fish, Doraku Sushi, San Loco Tacos, and Big Pink.

Other good restaurants include, Micheal's Genuine, Mr Chow, Prime 112, and either Smith & Wollensky or Monyt's in Miami Beach, to watch the sunset.

How to take the city bus to Miami Beach

There are two city buses that will pick you up in front of Bayside Marketplace, going northbound on Biscayne Boulevard, and take you to Miami Beach:

  • "Route C" Bus - This bus will cross MacArthur Causeway, headed east, go north on Washington Ave., east on Lincoln Road, then north on Collins Ave. to 44th St. Take this route to go to Ocean Dr., or anywhere along the beach, from 1st to 15th St. The ride to South Beach takes approximately 15 minutes. Route map (PDF)

  • "Route S" Bus - This bus will cross MacArthur Causeway, headed east, go north on Alton Road, turn east on 17th St., then north on Collins Ave., traveling through Sunny Isles. The bus then heads West on 192nd St., arriving to the Aventura Mall. The ride to Aventura Mall takes approximately 2 hours. Route map (PDF)

How to take the city bus to Dolphin Mall, International Mall, and Mall of the Americas.

From Bayside Marketplace, walk to NE 3rd Street and take the "Route 7" Bus. The ride to Dolphin Mall takes approximately 90 minutes. Route map (PDF)