SELECT id,latitude,longitude FROM centers WHERE (latitude BETWEEN '42.2973' AND '42.7473') AND (longitude BETWEEN '-83.2074' AND '-82.7574')