Crestwood Motel

Establishment and lodging at 527 Plains Road East, Burlington, ON L7T 2E2, Canada. Here you will find detailed information about Crestwood Motel: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment Lodging

Address:
527 Plains Road East
Burlington
Ontario L7T 2E2
Canada
Get directions

Phone:
+1 905-634-6119

Rating

2 /5

Based on 1 reviews

Add review

Photos

Reviews of Crestwood Motel

Patrick McMillan Added 2017-09-02

★ ★ ☆ ☆ ☆

Pretty much a run down roadside motel. The seemingly drunk front desk attendant wouldn't stop rambling on. I just wanted to get some rest. Throughout the night every 3 min I'd hear a loud bang like a hammer on a plumbing pipe. Extremely irritating! Not worth the price! I've paid far less for far better. An out of place motel for the nice city of Burlington.

1	SELECT * FROM `item` WHERE url = 'crestwood-motel' LIMIT 1
0	SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('16525') LIMIT 1
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('3508')
0	SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
1	SELECT * FROM `locality` WHERE url = 'burlington-on' LIMIT 1
0	SELECT * FROM `region` WHERE id = 176 LIMIT 1
1	SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 3508 AND `date` < '2024-04-26 14:21:04' ORDER BY `date` DESC
0	SELECT * FROM `photos` WHERE `item_id` IN ('3508')
1	SELECT * FROM `item` WHERE id IN ('3397','5517','3247','57924','3245','3303') LIMIT 6
0	SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('16525') LIMIT 1
0	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('3245','3247','3303','3397','5517','57924')
0	SELECT * FROM `category` WHERE id IN ('96','100','124','111','107','99','116') LIMIT 7
0	SELECT * FROM counts where updated="2024-04-26" and table_name like 'news'
0	SELECT * FROM counts where updated="2024-04-26" and table_name like 'news'
0	SELECT * FROM `category` ORDER BY name
3	SELECT * 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
0	SELECT * FROM `region` WHERE id IN ('179','169') LIMIT 2
0	SELECT * FROM `locality` WHERE id IN ('18897','14740') LIMIT 2
0	SELECT * FROM `photos` WHERE `item_id` IN ('143002','143004','143005','143006')
0	SELECT * 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
0	SELECT * FROM `region` WHERE id IN ('178') LIMIT 1

Crestwood Motel

Contacts

Rating

Photos

Reviews of Crestwood Motel

Share this page

Additional actions

Today's weather in Burlington

Nearest places