McCrystal Fine Furnishings

Full information about Establishment, home goods store, furniture store and store McCrystal Fine Furnishings at 32C Scotch Street, Dungannon, Northern Ireland BT70 1BD. Find the address of the company, the phone for communication, opening hours, feedback from customers and employees, as well as other information.

Contacts

Address:
32C Scotch Street, Dungannon, Northern Ireland BT70 1BD
Get directions

Phone number:
+44 28 8772 5004

Website:
mccrystalfinefurnishings.co.uk

Types:
Establishment   Home goods store   Furniture store   Store  

Suggest changes

Click to view full map
 

Images of McCrystal Fine Furnishings

McCrystal Fine Furnishings

Reviews about McCrystal Fine Furnishings

  • Teresa McKernan
    16.07.2018
    ★ ★ ★ ★ ★
    Great choice of sofas at McCrystals. I was spoilt for choice. Helpful and friendly staff to answer all my endless questions. Highly recommended this shop in terms of quality, affordability and selection.
Add new review

The nearest companies

  • Tom Morrow & Co. Ltd.
    Establishment Clothing store Store
    26 Scotch Street, Dungannon, NIR BT70 1AR
    +44 28 8772 3281
  • K9 Bonus
    Establishment Pet store Store
    42 Scotch Street, Dungannon, NIR BT70 1BD
    +44 28 8772 7850
  • Hiscuts Barber Shop
    Establishment Health Hair care
    Scotch Street, Dungannon, NIR BT70 1BJ
  • Pattersons
    Establishment Shoe store
    35 Scotch Street, Dungannon, NIR BT70 1AR
    +44 28 8772 2389
  • Droz Pol Delicatessan
    Establishment Food Supermarket
    42 Scotch Street, Dungannon, NIR BT70 1BD
    +44 28 8723 8039
  • 55 Scotch Street, Dungannon, NIR BT70 1BD
    +44 28 8775 2046

Weather in Dungannon, Northern Ireland

23.09.2020 04:00 8
23.09.2020 07:00 6
23.09.2020 10:00 9
23.09.2020 13:00 12
23.09.2020 16:00 11
23.09.2020 19:00 8
23.09.2020 22:00 5
24.09.2020 01:00 4
24.09.2020 04:00 4
24.09.2020 07:00 6
24.09.2020 10:00 8
24.09.2020 13:00 9
24.09.2020 16:00 9
24.09.2020 19:00 7
24.09.2020 22:00 5
25.09.2020 01:00 5
25.09.2020 04:00 7
25.09.2020 07:00 7
25.09.2020 10:00 9
25.09.2020 13:00 11
25.09.2020 16:00 11
25.09.2020 19:00 8
25.09.2020 22:00 5
2SELECT * FROM `item` WHERE url = 'mccrystal-fine-furnishings' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('2') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('9229') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('57323')
0SELECT * FROM `category` WHERE id IN ('1','11','39','46') LIMIT 4
0SELECT * FROM `locality` WHERE url = 'dungannon-nir' LIMIT 1
0SELECT * FROM `region` WHERE id = 2 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 57323 AND `date` < '2020-09-23 17:09:58' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('57323')
4SELECT * FROM `item` WHERE id IN ('57320','461813','57342','924534','821899','376795') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('2') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('9229') LIMIT 1
0SELECT * FROM `photos` WHERE `item_id` IN ('57320','57342','376795','461813','821899','924534')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('57320','57342','376795','461813','821899','924534')
0SELECT * FROM `category` WHERE id IN ('1','33','46','28','4','44','83','17','48') LIMIT 9
0SELECT * FROM counts where updated="2020-09-23" and table_name like 'news'
0SELECT * FROM counts where updated="2020-09-23" 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
5SELECT * FROM `item` WHERE `id` IN ('150540','795754','490018','586652','388128','904281','38196','86148','904031','433619','409412','496385')
0SELECT * FROM `region` WHERE id IN ('1','3') LIMIT 2
1SELECT * FROM `locality` WHERE id IN ('647','10436','6095','4833','5766','732','1091','7270','7700','5772','5762','968') LIMIT 12
0SELECT * FROM `photos` WHERE `item_id` IN ('38196','86148','150540','388128','409412','433619','490018','496385','586652','795754','904031','904281')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('38196','86148','150540','388128','409412','433619','490018','496385','586652','795754','904031','904281')
0SELECT * FROM `category` WHERE id IN ('1','69','23','49','4','24','54','17','18','31','43') LIMIT 11
0SELECT * FROM counts where updated="2020-09-23" and table_name like 'locality'
0SELECT MIN(id) FROM `locality`
1SELECT * FROM `locality` WHERE id IN ('3571','7353','1352','4853','7562','8054','10956','1023','8176','8908','8464','3036','9215','3764','2772','1870','4373','10559','4467','6273','3128','9464') LIMIT 12
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM counts where updated="2020-09-23" and table_name like 'locality'
0SELECT * FROM counts where updated="2020-09-23" and table_name like 'item'
0SELECT * FROM counts where updated="2020-09-23" and table_name like 'reviews'
0SELECT * FROM counts where updated="2020-09-23" and table_name like 'photos'