If you are visiting a patient and need overnight accommodations, below is a list of local hotels offering Johnson Memorial Hospital a discounted rate for patients, families, guests and staff: Hampton Inn by Hilton, 20 Phoenix Avenue, Enfield, CT 06082. Located 10.6 miles from Johnson Memorial Hospital. Hotel Main: (860) 741-3111..