Sterlings Steakhouse

Establishment, food and bar at 165 Promenade Du Centropolis, Laval, QC H7T 0B3, Canada. Here you will find detailed information about Sterlings Steakhouse: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Food   Bar  

Address:
165 Promenade Du Centropolis
Laval
Quebec H7T 0B3
Canada
Get directions

Phone:
+1 450-682-4800

Website:
sterlingsrestaurant.com

Opening hours

Sunday 04:00pm — 11:00pm
Monday 11:00am — 11:00pm
Tuesday 11:00am — 11:00pm
Wednesday 11:00am — 11:00pm
Thursday 11:00am — 11:00pm

Photos

Reviews of Sterlings Steakhouse

Sorry, but now we haven't any revews about Sterlings Steakhouse.

Add review

About sterlingsrestaurant.com

Sterlings Steakhouse | Laval, QC | (450) 682-4800
Lorsqu’il s'agit de steaks, poissons et fruits de mer, Sterling Steakhouse est l'endroit tout indiqué. Classé parmi les 3 meilleurs steakhouses de la région, Sterling Steakhouse propose une ambia...
sterlings, steakhouse, laval, quebec, restaurant, grillades, fruits de mer, steaks, chomedey, saint martin, centropolis, grande liste des vins, haute cuisine, reunions privees, reunions de groupe, lounge, terrasse, pour emporter, accessible aux fauteuils roulants, stationnement gratuit

1SELECT * FROM `item` WHERE url = 'sterlings-steakhouse' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('178') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17757') LIMIT 1
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('64568')
0SELECT * FROM `category` WHERE id IN ('96','99','144') LIMIT 3
0SELECT * FROM `locality` WHERE url = 'laval-qc' LIMIT 1
0SELECT * FROM `region` WHERE id = 178 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 64568 AND `date` < '2024-04-18 11:16:17' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('64568')
1SELECT * FROM `item` WHERE id IN ('325993','64412','64174','64471','64248','64244') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('178') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17757') LIMIT 1
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('64174','64244','64248','64412','64471','325993')
0SELECT * FROM `category` WHERE id IN ('96','128','152','153','97','126','127','99','118','174','144') LIMIT 11
0SELECT * FROM counts where updated="2024-04-18" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-18" and table_name like 'news'
1SELECT * FROM `category` ORDER BY name
3SELECT * 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 ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('16832','16524','17033','16891') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('23955','23956','23957','23958')
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