added third query to showByGeo method to ensure that expired rooms aren't shown to users