Rouge Resto Club

Establishment, bar and night club at 189 Robinson Street, Moncton, NB E1C 5C3, Canada. Here you will find detailed information about Rouge Resto Club: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Bar   Night club  

Address:
189 Robinson Street
Moncton
New Brunswick E1C 5C3
Canada
Get directions

Phone:
+1 506-229-2317

Website:
rouge.ca

Photos

Reviews of Rouge Resto Club

Sorry, but now we haven't any revews about Rouge Resto Club.

Add review

About rouge.ca

Night Clubs | Dance | Premier Lounge | Club in Moncton
Amongst Night clubs in Moncton, Premier Lounge in Moncton is the best club in Moncton with a fantastic ambiance with great music and floor for dance in Moncton.
Club in Moncton, Dance in Moncton, Night clubs in Moncton, Premier lounge in Moncton

1SELECT * FROM `item` WHERE url = 'rouge-resto-club' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15537') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('59081')
0SELECT * FROM `category` WHERE id IN ('96','144','161') LIMIT 3
0SELECT * FROM `locality` WHERE url = 'moncton-nb' LIMIT 1
0SELECT * FROM `region` WHERE id = 171 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 59081 AND `date` < '2024-04-25 10:40:15' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('59081')
1SELECT * FROM `item` WHERE id IN ('59170','325295','59224','59050','59318','58946') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15537') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('58946','59050','59170','59224','59318','325295')
0SELECT * FROM `category` WHERE id IN ('96','139','118','141','130','140','99') LIMIT 7
0SELECT * 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 ('169','178') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('15021','18192') LIMIT 2
0SELECT * FROM `photos` WHERE `item_id` IN ('443900','443901','443902','443903')
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 ('178') LIMIT 1