select statement for housing application list implemented