Buckwheat Point Estates

Establishment, campground, lodging and park at 152 Maclean Road, Cumberland Bay, NB E4A 3K4, Canada. Here you will find detailed information about Buckwheat Point Estates: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Campground   Lodging   Park  

Address:
152 Maclean Road
Cumberland Bay
New Brunswick E4A 3K4
Canada
Get directions

Phone:
+1 506-260-2030

Website:
buckwheatpointestates.ca

Photos

Reviews of Buckwheat Point Estates

Sorry, but now we haven't any revews about Buckwheat Point Estates.

Add review

About buckwheatpointestates.ca

Seasonal Cottage, Seasonal RV Lots, Grand Lake New Brunswick
Welcome to your new vacation home that has a great view with direct beach front access. RV and Park Model Park lots on Grand Lake in New Brunswick Canada.

1SELECT * FROM `item` WHERE url = 'buckwheat-point-estates' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15444') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('88540')
0SELECT * FROM `category` WHERE id IN ('96','106','107','108') LIMIT 4
0SELECT * FROM `locality` WHERE url = 'cumberland-bay-nb' LIMIT 1
0SELECT * FROM `region` WHERE id = 171 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 88540 AND `date` < '2024-04-27 03:34:15' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('88540')
2SELECT * FROM `item` WHERE id IN ('37087','37197','37057','37016','190554','190641') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15444','15532') LIMIT 2
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('37016','37057','37087','37197','190554','190641')
0SELECT * FROM `category` WHERE id IN ('96','103','120','121','106','107','108','100') LIMIT 8
2SELECT * FROM counts where updated="2024-04-27" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-27" 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 ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17337','16466','16726') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('16242','16243','16245','16246')
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