Buffalo 7

Full information about Establishment Buffalo 7 at 75 The Mount, York, England YO24 1AX. Find the address of the company, the phone for communication, opening hours, feedback from customers and employees, as well as other information.

Contacts

Address:
75 The Mount, York, England YO24 1AX
Get directions

Phone number:
+44 1904 405700

Website:
buffalo7.co.uk

Types:
Establishment  

Suggest changes

Opening times

Monday 09:00 — 18:00
Tuesday 09:00 — 18:00
Wednesday 09:00 — 18:00
Thursday 09:00 — 18:00
Friday 09:00 — 18:00
Click to view full map
 

Images of Buffalo 7

Buffalo 7

Reviews about Buffalo 7

Sorry, we haven't any reviews about company Buffalo 7.

Add new review

The nearest companies

Weather in York, England

29.10.2020 04:00 7
29.10.2020 07:00 6
29.10.2020 10:00 8
29.10.2020 13:00 9
29.10.2020 16:00 12
29.10.2020 19:00 13
29.10.2020 22:00 13
30.10.2020 01:00 14
30.10.2020 04:00 14
30.10.2020 07:00 15
30.10.2020 10:00 15
30.10.2020 13:00 16
30.10.2020 16:00 15
30.10.2020 19:00 14
30.10.2020 22:00 14
31.10.2020 01:00 14
31.10.2020 04:00 13
31.10.2020 07:00 14
31.10.2020 10:00 14
31.10.2020 13:00 16
31.10.2020 16:00 15
31.10.2020 19:00 12
31.10.2020 22:00 12
1SELECT * FROM `item` WHERE url = 'buffalo-7' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('9076') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('864896')
0SELECT * FROM `category` WHERE id IN ('1') LIMIT 1
0SELECT * FROM `locality` WHERE url = 'york-eng' LIMIT 1
0SELECT * FROM `region` WHERE id = 1 LIMIT 1
0SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 864896 AND `date` < '2020-10-29 10:11:04' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('864896')
2SELECT * FROM `item` WHERE id IN ('864827','576343','864941','383201','208517','823354') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('9076') LIMIT 1
0SELECT * FROM `photos` WHERE `item_id` IN ('208517','383201','576343','823354','864827','864941')
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('208517','383201','576343','823354','864827','864941')
0SELECT * FROM `category` WHERE id IN ('1','4','62','17') LIMIT 4
0SELECT * FROM counts where updated="2020-10-29" and table_name like 'news'
0SELECT * FROM counts where updated="2020-10-29" and table_name like 'news'
1SELECT * FROM `category` ORDER BY name
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
4SELECT * FROM `item` WHERE `id` IN ('808039','294961','437059','340931','567152','396168','88675','749165','79303','847099','734634','532463')
0SELECT * FROM `region` WHERE id IN ('1','4','3') LIMIT 3
1SELECT * FROM `locality` WHERE id IN ('2777','11275','10918','4149','8608','4833','2554','4595','8230','8226','9919') LIMIT 11
0SELECT * FROM `photos` WHERE `item_id` IN ('79303','88675','294961','340931','396168','437059','532463','567152','734634','749165','808039','847099')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('79303','88675','294961','340931','396168','437059','532463','567152','734634','749165','808039','847099')
0SELECT * FROM `category` WHERE id IN ('1','12','16','11','33','7','31','50','17','83','4','18') LIMIT 12
0SELECT * FROM counts where updated="2020-10-29" and table_name like 'locality'
0SELECT MIN(id) FROM `locality`
0SELECT * FROM `locality` WHERE id IN ('4616','9770','1990','6563','5112','1673','8144','9786','5249','1004','8620','8454','10503','3264','2735','6332','3790','5077','7492','6158','8154','6527') LIMIT 12
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM counts where updated="2020-10-29" and table_name like 'locality'
0SELECT * FROM counts where updated="2020-10-29" and table_name like 'item'
0SELECT * FROM counts where updated="2020-10-29" and table_name like 'reviews'
0SELECT * FROM counts where updated="2020-10-29" and table_name like 'photos'