Colima Mexican Restaurant

Full information about place - Establishment, food and restaurant "Colima Mexican Restaurant" at 62 East Sylva Shopping Center, Sylva, NC 28779. You may find here reviews, address, phone number, website, work hours and etc.

Contacts

Phone number:
+1 828-586-9999

Address:
62 East Sylva Shopping Center, Sylva, NC 28779
Get directions

Categories:
Establishment Food Restaurant

Suggest changes

Reviews about Colima Mexican Restaurant

Sorry, but now we haven't any revews.

Add new review

Photos and maps

Nearest places

Jones Thomas W
Establishment, Lawyer

90 East Main Street, Sylva, NC 28779

+1 828-586-5589
Kirby Gary E
Establishment, Lawyer

21 Colonial Square, Sylva, NC 28779

+1 828-586-9299
Krismart Fashions
Establishment, Clothing store

56 East Main Street, Sylva, NC 28779

+1 828-586-6144
Robert D. Kelley, RPH
Establishment, Pharmacy

Sylva, Sylva, NC 28779

+1 828-586-2213
Bryson Christy C
Establishment, Health, Pharmacy

38 East Main Street, Sylva, NC 28779

+1 828-586-2213
Ted's Laundromat
Establishment, Laundry

114 East Main Street, Sylva, NC 28779

+1 828-586-2910

Open now: Until 09:00pm

Weather in Sylva, NC

May, 09 2024 03:00am	19 ^℃
May, 09 2024 06:00am	19 ^℃
May, 09 2024 09:00am	17 ^℃
May, 09 2024 12:00pm	18 ^℃
May, 09 2024 03:00pm	20 ^℃
May, 09 2024 06:00pm	18 ^℃
May, 09 2024 09:00pm	23 ^℃
May, 10 2024 12:00am	20 ^℃
May, 10 2024 03:00am	16 ^℃
May, 10 2024 06:00am	15 ^℃
May, 10 2024 09:00am	13 ^℃
May, 10 2024 12:00pm	15 ^℃
May, 10 2024 03:00pm	20 ^℃
May, 10 2024 06:00pm	23 ^℃
May, 10 2024 09:00pm	21 ^℃
May, 11 2024 12:00am	14 ^℃
May, 11 2024 03:00am	12 ^℃
May, 11 2024 06:00am	9 ^℃
May, 11 2024 09:00am	6 ^℃
May, 11 2024 12:00pm	8 ^℃
May, 11 2024 03:00pm	16 ^℃
May, 11 2024 06:00pm	20 ^℃
May, 11 2024 09:00pm	20 ^℃

4	SELECT * FROM `item` WHERE url = 'colima-mexican-restaurant' LIMIT 1
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('31163') LIMIT 1
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('277703')
0	SELECT * FROM `category` WHERE id IN ('189','219','228') LIMIT 3
0	SELECT * FROM `locality` WHERE url = 'sylva-nc' LIMIT 1
0	SELECT * FROM `region` WHERE id = 66 LIMIT 1
0	SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 277703 AND `date` < '2024-05-09 16:05:45' ORDER BY `date` DESC
0	SELECT * FROM `photos` WHERE `item_id` IN ('277703')
1	SELECT * FROM `item` WHERE id IN ('240056','326389','205224','326392','163304','163477') LIMIT 6
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('31163') LIMIT 1
0	SELECT * FROM `photos` WHERE `item_id` IN ('163304','163477','205224','240056','326389','326392')
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('163304','163477','205224','240056','326389','326392')
0	SELECT * FROM `category` WHERE id IN ('189','221','229','227','191','224') LIMIT 6
0	SELECT * FROM counts where updated="2024-05-09" and table_name like 'news'
1	SELECT * FROM counts where updated="2024-05-09" and table_name like 'news'
0	SELECT * FROM `category` ORDER BY name
4	SELECT * 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
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30593') LIMIT 1
0	SELECT * FROM `photos` WHERE `item_id` IN ('481735','481736','481737','481738','481739','481740','481741','481742')
0	SELECT * 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
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
1	SELECT * FROM counts where updated="2024-05-09" and table_name like 'locality'
1	SELECT * FROM counts where updated="2024-05-09" and table_name like 'item'
2	SELECT * FROM counts where updated="2024-05-09" and table_name like 'reviews'
0	SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos'