Sport Clips Haircuts

Establishment and hair care at 3160-1971 Lougheed Highway, Port Coquitlam, BC V3B 1A6, Canada. Here you will find detailed information about Sport Clips Haircuts: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Hair care  

Address:
3160-1971 Lougheed Highway
Port Coquitlam
British Columbia V3B 1A6
Canada
Get directions

Phone:
+1 604-424-8945

Website:
sportclips.ca

Reviews of Sport Clips Haircuts

Sorry, but now we haven't any revews about Sport Clips Haircuts.

Add review

About sportclips.ca

Haircuts for Men Walk-Ins Welcome | Sport Clips
Would you like to get your haircut by a stylist who is an expert in haircuts for men while relaxing and watching the game? Then come visit Sport Clips.

1SELECT * FROM `item` WHERE url = 'sport-clips-haircuts' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('169') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14926') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('170069')
0SELECT * FROM `category` WHERE id IN ('96','131') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'port-coquitlam-bc' LIMIT 1
1SELECT * FROM `region` WHERE id = 169 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 170069 AND `date` < '2024-04-27 09:05:40' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('170069')
0SELECT * FROM `item` WHERE id IN ('170018','170070','170038','170294','170096','170410') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('169') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14739') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('170018','170038','170070','170096','170294','170410')
0SELECT * FROM `category` WHERE id IN ('96','128','103') LIMIT 3
0SELECT * FROM counts where updated="2024-04-27" and table_name like 'news'
1SELECT * FROM counts where updated="2024-04-27" and table_name like 'news'
1SELECT * FROM `category` ORDER BY name
2SELECT * 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 4
0SELECT * FROM `region` WHERE id IN ('178','169') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('18455','14934','18004','17843') LIMIT 4
1SELECT * FROM `photos` WHERE `item_id` IN ('419099','419100','419102','419103')
1SELECT * 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 7
0SELECT * FROM `region` WHERE id IN ('168') LIMIT 1