Regalia House

Establishment at Canada, Ottawa, ON K0A 2W0, Canada. Here you will find detailed information about Regalia House: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment  

Address:
Canada
Ottawa
Ontario K0A 2W0
Canada
Get directions

Phone:
+1 613-826-0089

Website:
regaliahouse.com

Reviews of Regalia House

Sorry, but now we haven't any revews about Regalia House.

Add review

About regaliahouse.com

Regalia House - Supplier of fine quality Military, Police and Institutional Regalia.
This Firm has been supplying the special needs of a number of organizations in many countries for more than 20 years. Items range from cap badges to blazer crests, to much more elaborate larger items such as, baldrics, banners and full size colours.
regalia, house, cap badges, military, police, institutional, blazer crests, baldrics, banners

0SELECT * FROM `item` WHERE url = 'regalia-house' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17033') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('310819')
0SELECT * FROM `category` WHERE id IN ('96') LIMIT 1
0SELECT * FROM `locality` WHERE url = 'ottawa-on' LIMIT 1
0SELECT * FROM `region` WHERE id = 176 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 310819 AND `date` < '2024-04-25 12:18:13' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('310819')
1SELECT * FROM `item` WHERE id IN ('310839','51132','392422','306920','392717','391957') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17033','16663') LIMIT 2
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('51132','306920','310839','391957','392422','392717')
0SELECT * FROM `category` WHERE id IN ('96','120','121','113','103','131') LIMIT 6
3SELECT * FROM counts where updated="2024-04-25" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-25" 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 ('168','169') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('14646','14840') LIMIT 2
0SELECT * FROM `photos` WHERE `item_id` IN ('258259','258261','258262','258263')
0SELECT * 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