This is an amazing hotel for the Holiday Inn Express brand. It's right on the river near the bridge across the Columbia. Riverside rooms look out on the river as enormous ships pass by. On that side of the hotel is a footpath that goes into downtown Astoria as well as the riverfront trolley that goes to the Oregon Maritime Center.
The rooms are huge and well appointed. Most have in-room refrigerators and microwaves. Some have jacuzzis. Very clean. My only gripe is that they block the windows from opening more than a couple of inches and the rooms can get stuffy.
Decent enough free breakfast room in the morning. Pig 'n' Pancake is across the street as well.
For a comfortable, affordable stay in Astoria, this is easily my first choice.