Uncovering the Potential of Indoor Localization: Role of Deep and Transfer Learning