Firehouse Subs

Full information about place - Establishment, food and restaurant "Firehouse Subs" at 14039 Hwy 74 E, Indian Trail, NC 28079. You may find here reviews, address, phone number, website, work hours and etc.

Contacts

Website:
locations.firehousesubs.com

Price level:
Inexpensive

Phone number:
+1 704-893-2888

Address:
14039 Hwy 74 E, Indian Trail, NC 28079
Get directions

Categories:
Establishment Food Restaurant

Suggest changes

Reviews about Firehouse Subs

Sorry, but now we haven't any revews.

Add new review

Photos and maps

Nearest places

T-Mobile
Establishment, Electronics store

308 Unionville Indian Trail Road, Indian Trail, NC 28079

+1 704-893-5320

t-mobile.com
7-Eleven
Establishment, Convenience store

304 Unionville Indian Trail Road, Indian Trail, NC 28079

+1 980-245-9191

7-eleven.com
Exxon
Establishment, Gas station

304 Unionville Indian Trail Road West, Indian Trail, NC 28079

+1 980-245-9191

exxon.com
Cardtronics
Establishment, Atm, Finance

304 Unionville Indian Trail Road West, Indian Trail, NC 28079

cardtronics.com
Jes Flooring
Establishment, Home goods store

248 Unionville Indian Trail Road, Indian Trail, NC 28079
Precise Builders Inc
Establishment, General contractor

287 Unionville Indian Trail Road, Indian Trail, NC 28079

+1 704-821-2638

2	SELECT * FROM `item` WHERE url = 'firehouse-subs-494' LIMIT 1
3	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
1	SELECT * FROM `locality` WHERE id IN ('30804') LIMIT 1
0	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('282157')
0	SELECT * FROM `category` WHERE id IN ('189','219','228') LIMIT 3
1	SELECT * FROM `locality` WHERE url = 'indian-trail-nc' LIMIT 1
1	SELECT * FROM `region` WHERE id = 66 LIMIT 1
1	SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 282157 AND `date` < '2024-05-10 02:27:35' ORDER BY `date` DESC
0	SELECT * FROM `photos` WHERE `item_id` IN ('282157')
2	SELECT * FROM `item` WHERE id IN ('479068','228209','364678','374774','200512','200463') LIMIT 6
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30804') LIMIT 1
1	SELECT * FROM `photos` WHERE `item_id` IN ('200463','200512','228209','364678','374774','479068')
2	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('200463','200512','228209','364678','374774','479068')
0	SELECT * FROM `category` WHERE id IN ('189','193','197','223','206','207','208','222') LIMIT 8
0	SELECT * FROM counts where updated="2024-05-10" and table_name like 'news'
2	SELECT * FROM counts where updated="2024-05-10" and table_name like 'news'
1	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
1	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30592','30661') LIMIT 2
1	SELECT * FROM `photos` WHERE `item_id` IN ('491747','491748','491749','491750','491751','491752','491753','491754')
1	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
0	SELECT * FROM counts where updated="2024-05-10" and table_name like 'locality'
0	SELECT * FROM counts where updated="2024-05-10" and table_name like 'item'
0	SELECT * FROM counts where updated="2024-05-10" and table_name like 'reviews'
0	SELECT * FROM counts where updated="2024-05-10" and table_name like 'photos'

Contacts

Reviews about Firehouse Subs

Photos and maps

Nearest places

Weather in Indian Trail, NC