All types
 
Français

Riverhaven Acres

Establishment and food at 1R4, 115 Sunbury Drive, Fredericton Junction, NB E5L 1R1, Canada. Here you will find detailed information about Riverhaven Acres: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Food  

Address:
1R4
115 Sunbury Drive
Fredericton Junction
New Brunswick E5L 1R1
Canada
Get directions

Photos

Riverhaven Acres

Reviews of Riverhaven Acres

Sorry, but now we haven't any revews about Riverhaven Acres.

Add review

Share this page

Additional actions

Today's weather in Fredericton Junction

04:00 -1 ℃ 1021 hPa 69 % 2 m/s 07:00 3 ℃ 1022 hPa 52 % 4 m/s 10:00 10 ℃ 1022 hPa 38 % 6 m/s 13:00 12 ℃ 1020 hPa 39 % 7 m/s 16:00 10 ℃ 1018 hPa 48 % 6 m/s 19:00 3 ℃ 1019 hPa 62 % 4 m/s 22:00 2 ℃ 1018 hPa 63 % 3 m/s

Nearest places

2SELECT * FROM `item` WHERE url = 'riverhaven-acres' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15466') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('47492')
1SELECT * FROM `category` WHERE id IN ('96','99') LIMIT 2
1SELECT * FROM `locality` WHERE url = 'fredericton-junction-nb' LIMIT 1
0SELECT * FROM `region` WHERE id = 171 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 47492 AND `date` < '2024-04-23 17:30:02' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('47492')
2SELECT * FROM `item` WHERE id IN ('122288','122204','122295','122193','122256','122245') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15466') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('122193','122204','122245','122256','122288','122295')
0SELECT * FROM `category` WHERE id IN ('96','120','121','97','98','167') LIMIT 6
0SELECT * FROM counts where updated="2024-04-23" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-23" and table_name like 'news'
1SELECT * FROM `category` ORDER BY name
4SELECT * 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 ('178','176') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('17828','17340','17968') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('315325','315326','315327','315328')
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 ('176') LIMIT 1