When considering hotels in beautiful Downtown Charleston, The Courtyard by Marriott is the one to remember. This scenic waterfront hotel is situated downtown on the banks of the beautiful Ashley River just a short drive to The Historic District. The Courtyard by Marriott Downtown Riverview is a unique upscale hotel with 178 bright and spacious rooms.