Genest Jean-Rock Avocat Inc

Establishment and lawyer at 625 Boulevard Laflèche, Baie-Comeau, QC G5C 1C5, Canada. Here you will find detailed information about Genest Jean-Rock Avocat Inc: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lawyer  

Address:
625 Boulevard Laflèche
Baie-Comeau
Quebec G5C 1C5
Canada
Get directions

Phone:
+1 418-589-7007

Website:
jrgenestavocat.com

Reviews of Genest Jean-Rock Avocat Inc

Sorry, but now we haven't any revews about Genest Jean-Rock Avocat Inc.

Add review

About jrgenestavocat.com

Jean-Rock Genest avocat Inc. | Avocat Baie-Comeau | Accueil
Jean-Rock Genest avocat Inc. à Baie-Comeau intervient pour tout ce qui concerne le droit familial, de droit criminel et pénal, le droit civil et plus encore.
Genest Jean-Rock Avocat

1SELECT * FROM `item` WHERE url = 'genest-jean-rock-avocat-inc' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('178') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17441') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('151460')
0SELECT * FROM `category` WHERE id IN ('96','166') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'baie-comeau-qc' LIMIT 1
0SELECT * FROM `region` WHERE id = 178 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 151460 AND `date` < '2024-04-25 07:37:31' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('151460')
1SELECT * FROM `item` WHERE id IN ('130990','131197','151301','431121','151520','348617') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('178') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17441') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('130990','131197','151301','151520','348617','431121')
0SELECT * FROM `category` WHERE id IN ('96','133','148','129') LIMIT 4
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'
0SELECT * FROM `category` ORDER BY name
1SELECT * 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','174') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('17643','18405','16283','18365') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('64094','64095','64096','64097')
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