If you value proximity to the airport for 1 night then the noise of the planes flying right over the house shouldn't be an issue for you and this is the place for you.
But if you value your sleep maybe bring some ear plugs or it may not be the right place for you.
Needs a good makeover and refresh.