Residents in coastal areas of southern Queensland and northern New South Wales are facing long queues to stock up on sandbags to prepare for the arrival of Tropical Cyclone Alfred in the coming days.