All types
 
Français

Barrett Honda Yamaha

Establishment at 1470 British Columbia 3B, Fruitvale, BC V1R 4W6, Canada. Here you will find detailed information about Barrett Honda Yamaha: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment  

Address:
1470 British Columbia 3B
Fruitvale
British Columbia V1R 4W6
Canada
Get directions

Phone:
+1 250-367-6216

Website:
barretthondayamaha.com

Opening hours

Tuesday 09:00am — 05:00pm
Wednesday 09:00am — 05:00pm
Thursday 09:00am — 05:00pm
Friday 09:00am — 05:00pm
Saturday 09:00am — 05:00pm

Rating

5 /5

Based on 1 reviews

Add review

Reviews of Barrett Honda Yamaha

  •  
    A Google User Added 2017-06-30
    ★ ★ ★ ★ ★
    Fantastic service and very reasonable pricing

Add review

Share this page

Additional actions

Today's weather in Fruitvale

22:00 14 ℃ 1008 hPa 65 % 1 m/s

Nearest places

1SELECT * FROM `item` WHERE url = 'barrett-honda-yamaha' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('169') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14787') LIMIT 1
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('163851')
0SELECT * FROM `category` WHERE id IN ('96') LIMIT 1
0SELECT * FROM `locality` WHERE url = 'fruitvale-bc' LIMIT 1
0SELECT * FROM `region` WHERE id = 169 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 163851 AND `date` < '2024-04-25 11:10:05' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('163851')
0SELECT * FROM `item` WHERE id IN ('352010','351967','354673','350902','354850','354819') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('169') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14894') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('350902','351967','352010','354673','354819','354850')
0SELECT * FROM `category` WHERE id IN ('96','99','110','115','124','125','97','98') LIMIT 8
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 ('180','173') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('18937','15977','15988') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('285824','285825','285826','285827')
1SELECT * 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