Charles A. Cannon, Jr Memorial Hospital: Emergency Room

Full information about place - Establishment "Charles A. Cannon, Jr Memorial Hospital: Emergency Room" at 434 Hospital Drive, Linville, NC 28646. You may find here reviews, address, phone number, website, work hours and etc.

Contacts

Phone number:
+1 828-737-7449

Address:
434 Hospital Drive, Linville, NC 28646
Get directions

Categories:
Establishment  

Suggest changes

Opening times

Sunday 12:00am — 11:59pm
Monday 12:00am — 11:59pm
Tuesday 12:00am — 11:59pm
Wednesday 12:00am — 11:59pm
Thursday 12:00am — 11:59pm
Friday 12:00am — 11:59pm
Saturday 12:00am — 11:59pm
Click to load full map
 

Reviews about Charles A. Cannon, Jr Memorial Hospital: Emergency Room

Sorry, but now we haven't any revews.

Add new review

Photos and maps

Charles A. Cannon, Jr Memorial Hospital: Emergency Room

Nearest places

Weather in Linville, NC

2SELECT * FROM `item` WHERE url = 'charles-cannon-jr-memorial-hospital-emergency-room' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
2SELECT * FROM `locality` WHERE id IN ('30867') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('134890')
0SELECT * FROM `category` WHERE id IN ('189') LIMIT 1
0SELECT * FROM `locality` WHERE url = 'linville-nc' LIMIT 1
0SELECT * FROM `region` WHERE id = 66 LIMIT 1
0SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 134890 AND `date` < '2024-05-09 14:51:58' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('134890')
2SELECT * FROM `item` WHERE id IN ('100264','135438','256871','97013','134793','134891') LIMIT 6
1SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('30867','30965') LIMIT 2
1SELECT * FROM `photos` WHERE `item_id` IN ('97013','100264','134793','134891','135438','256871')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('97013','100264','134793','134891','135438','256871')
0SELECT * FROM `category` WHERE id IN ('189','191','256','194') LIMIT 4
0SELECT * FROM counts where updated="2024-05-09" and table_name like 'news'
0SELECT * FROM counts where updated="2024-05-09" and table_name like 'news'
0SELECT * FROM `category` ORDER BY name
6SELECT * FROM `item` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `item`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 8
0SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('30962','30958','30942','31218') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('22084','22085','22086','22087','22088','22089','22090','22091')
0SELECT * FROM `locality` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `locality`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 12
0SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0SELECT * FROM counts where updated="2024-05-09" and table_name like 'locality'
0SELECT * FROM counts where updated="2024-05-09" and table_name like 'item'
0SELECT * FROM counts where updated="2024-05-09" and table_name like 'reviews'
0SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos'