All types
 
Français

County Windshield Svc

Establishment, car repair and home goods store at 55 Marble Street, Four Corners, NB E4E 3P8, Canada. Here you will find detailed information about County Windshield Svc: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Car repair   Home goods store  

Address:
55 Marble Street
Four Corners
New Brunswick E4E 3P8
Canada
Get directions

Phone:
+1 506-432-5230

Opening hours

Monday 08:00am — 05:30pm
Tuesday 08:00am — 05:30pm
Wednesday 08:00am — 05:30pm
Thursday 08:00am — 05:30pm
Friday 08:00am — 05:30pm
Saturday 08:00am — 02:00pm

Reviews of County Windshield Svc

Sorry, but now we haven't any revews about County Windshield Svc.

Add review

Share this page

Additional actions

Today's weather in Four Corners

22:00 1 ℃ 1027 hPa 53 % 1 m/s

Nearest places

2SELECT * FROM `item` WHERE url = 'county-windshield-svc' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15464') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('46839')
0SELECT * FROM `category` WHERE id IN ('96','100','128') LIMIT 3
1UPDATE locality SET weather = '{\"date\":\"2024-04-26\",\"data\":{\"2024-04-25\":{\"22\":{\"temp\":1,\"pressure\":1027,\"humidity\":53,\"icon\":\"03n\",\"wind\":1}},\"2024-04-26\":{\"01\":{\"temp\":-1,\"pressure\":1028,\"humidity\":60,\"icon\":\"03n\",\"wind\":1},\"04\":{\"temp\":-3,\"pressure\":1030,\"humidity\":69,\"icon\":\"04n\",\"wind\":1},\"07\":{\"temp\":3,\"pressure\":1031,\"humidity\":42,\"icon\":\"03d\",\"wind\":3},\"10\":{\"temp\":7,\"pressure\":1031,\"humidity\":29,\"icon\":\"03d\",\"wind\":4},\"13\":{\"temp\":9,\"pressure\":1030,\"humidity\":25,\"icon\":\"04d\",\"wind\":4},\"16\":{\"temp\":8,\"pressure\":1029,\"humidity\":28,\"icon\":\"04d\",\"wind\":4},\"19\":{\"temp\":2,\"pressure\":1031,\"humidity\":55,\"icon\":\"04n\",\"wind\":2},\"22\":{\"temp\":-1,\"pressure\":1033,\"humidity\":73,\"icon\":\"03n\",\"wind\":1}},\"2024-04-27\":{\"01\":{\"temp\":-2,\"pressure\":1033,\"humidity\":76,\"icon\":\"02n\",\"wind\":1},\"04\":{\"temp\":-3,\"pressure\":1033,\"humidity\":77,\"icon\":\"01n\",\"wind\":1},\"07\":{\"temp\":3,\"pressure\":1035,\"humidity\":49,\"icon\":\"01d\",\"wind\":2},\"10\":{\"temp\":9,\"pressure\":1033,\"humidity\":32,\"icon\":\"01d\",\"wind\":3},\"13\":{\"temp\":12,\"pressure\":1031,\"humidity\":27,\"icon\":\"01d\",\"wind\":3},\"16\":{\"temp\":11,\"pressure\":1029,\"humidity\":30,\"icon\":\"01d\",\"wind\":3},\"19\":{\"temp\":2,\"pressure\":1030,\"humidity\":58,\"icon\":\"01n\",\"wind\":2},\"22\":{\"temp\":-1,\"pressure\":1031,\"humidity\":63,\"icon\":\"01n\",\"wind\":1}}}}' WHERE id = 15464 LIMIT 1
0SELECT * FROM `locality` WHERE url = 'four-corners-nb' LIMIT 1
0SELECT * FROM `region` WHERE id = 171 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 46839 AND `date` < '2024-04-26 00:38:55' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('46839')
2SELECT * FROM `item` WHERE id IN ('46809','46770','46780','46822','37299','37064') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15657','15464') LIMIT 2
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('37064','37299','46770','46780','46809','46822')
0SELECT * FROM `category` WHERE id IN ('96','124','99','115','110') LIMIT 5
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'
0SELECT * FROM `category` ORDER BY name
0SELECT * 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 ('172','176') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('15796','17033') LIMIT 2
0SELECT * FROM `photos` WHERE `item_id` IN ('464865','464866','464867','464868')
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