The Flandria is well-located for a few nights walking around (and drinking) in central Ghent. It is off the noisy strip, but just a 2-3 minute walk to the Belfry (and the rest of the pubs, sights).
The building isn't the newest, but our room -- and partiuclarily our bed -- was clean and in good condition. For the price, we have no complaints.
Would recommend if you spend most of the day out and just use the place to crash & clean up.