A good site to check out for availability and reservations is www.booking.com

Some hotels we could recommend you:

The Mansion

Ibis

New Station Hotel (if you're keen on David Lynch-like experiences)

We recommend you to book your rooms upfront, as Aalst is a small town with a small amount of hotels.