Aloha Tourist Home

Establishment and lodging at 234 Sydney Street, Charlottetown, PE C1A 1H1 Canada, Sydney Street, Charlottetown, Charlottetown, PE C1A 1H1, Canada. Here you will find detailed information about Aloha Tourist Home: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lodging  

Address:
234 Sydney Street
Charlottetown
PE C1A 1H1 Canada
Sydney Street
Charlottetown
Charlottetown
Prince Edward Island C1A 1H1
Canada
Get directions

Phone:
+1 902-892-5642

Website:
alohapei.com

Rating

5 /5

Based on 1 reviews

Add review

Photos

Reviews of Aloha Tourist Home

  •  
    Sergio M Added 2018-05-22
    Beautiful rooms, short walk to the core of Charlottown, and very accommodating staff!
    The floor is not level in some areas, which didn't bother me but my friends couldn't get past it

Add review

About alohapei.com

Home - Aloha Tourist Home

1SELECT * FROM `item` WHERE url = 'aloha-tourist-home' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('177') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17367') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('71631')
0SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'charlottetown-pe' LIMIT 1
0SELECT * FROM `region` WHERE id = 177 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 71631 AND `date` < '2024-04-26 13:10:38' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('71631')
1SELECT * FROM `item` WHERE id IN ('71705','321660','71679','71864','72035','321803') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('177') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17367') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('71679','71705','71864','72035','321660','321803')
0SELECT * FROM `category` WHERE id IN ('96','99','144','140','157','159','129') LIMIT 7
0SELECT * FROM counts where updated="2024-04-26" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-26" and table_name like 'news'
1SELECT * 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 ('169','170') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('14871','14892','14725','15348') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('271993','271994','271995','271996')
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