Pentru o livrare cat mai rapida va recomandam sa alegeti produse cu stoc in Magazin fizic si in Depozit Online. Produsele cu Stoc furnizor au termen de livrare mai mare si pot intarzia comanda dvs.
articole de pescuit Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

transport gratuit Transport Gratuit

Comenzile peste 400 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

plata in rate Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

suport Suport 10-18

Suportul telefonic este 10-18. Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.

Vezi mai multe detalii

returnare Returnare simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Filtreaza

Exclusiv online!

Atasament Veranda Coleman Front Porch 6

2000037079
Livrare 24-48 ore

1.169,00Lei

Exclusiv online!

Atasament Veranda Coleman Front Porch 4

2000037078
Livrare 24-48 ore

949,00Lei

Exclusiv online!

698,99Lei

Adapost De Zi Filfishing 240x140x130cm

fil8154
Livrare imediată!

149,99Lei

Exclusiv online!

790,01Lei

Exclusiv online!

189,00Lei

Cort Coleman Rock Springs 4pers

204386
Livrare imediată!

1.128,00Lei

Exclusiv online!

Cort Coleman Rock Springs 3 Pers

205120
Livrare 24-48 ore

899,00Lei

Cort Coleman Coastline 3 Plus

205111
Livrare imediată!

1.180,00Lei

Exclusiv online!

Cort Coleman Cortes Octagon 8

2000019550
Livrare 24-48 ore

2.574,01Lei

Exclusiv online!

Cort Coleman Ridgeline 4 Plus

205114
Livrare 24-48 ore

1.774,00Lei

Extensie Cort Coleman Classic Awning

205081
Livrare imediată!

489,99Lei

Exclusiv online!

Pavilion Coleman Fastpitch Xl

2000032026
Livrare 24-48 ore

1.949,01Lei

Clipsuri Coghlans Pentru Prelata

c1014
Livrare imediată!

26,00Lei

Exclusiv online!

Cort Coleman Kobuk Valley 3 Plus

2000030280
Livrare 24-48 ore

999,01Lei

Cort Coleman Da Gama 4

2000012160
Livrare imediată!

2.399,00Lei

Exclusiv online!

Cort Coleman Rocky Mountain 5

2000030284
Livrare 24-48 ore

3.549,00Lei

Exclusiv online!

Cort Coleman Cortes Octagon Blue

2000030279
Livrare 24-48 ore

2.572,99Lei

Exclusiv online!

Cort Coleman Octagon Blackout

2000035195
Livrare 24-48 ore

3.249,00Lei

Exclusiv online!

Pavilion Coleman Fastpitch L

2000032027
Livrare 24-48 ore

1.609,00Lei

Afişare 1 - 20 din 76 (4 pagini)

Descoperă gama noastră de corturi pentru camping, ideale pentru aventuri în aer liber, indiferent de condiții.
Fabricate din materiale impermeabile și rezistente, acestea oferă protecție împotriva ploii, vântului și razelor UV.
Corturile camping ușor de montat asigură instalare rapidă și confort maxim în orice locație.
Disponibile în modele pentru 2 persoane, familie sau expediții, oferă spațiu generos și ventilație optimă.
Structura solidă și prelata impermeabilă garantează stabilitate și siguranță în timpul nopților petrecute în natură.
Modelele compacte și pliabile sunt ușor de transportat și depozitat.
Perfecte pentru drumeții, munte, excursii și festivaluri, corturile noastre se adaptează oricărui teren.
Protecția împotriva insectelor și rezistența la intemperii îți asigură un somn liniștit.
Alege corturi camping de calitate pentru o experiență relaxantă și fără griji în natură.
Profită de cele mai bune prețuri și bucură-te de camping la standarde superioare!

Queries: 19, Total time: 6.064 ms [By time] [By id] [By file]
1 (0.082)
SELECT data
FROM `oc_session`
WHERE session_id = '6984e7147e1319005db29eb234'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.119)
SELECT *
FROM oc_url_alias
WHERE keyword = 'corturi-si-accesorii'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.133)
SELECT *
FROM oc_url_alias
WHERE keyword = 'corturi-camping'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.093)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=680'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210
6 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210
7 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=680'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210
8 (0.367)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '680' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46
9 (1.462)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) ENGINE=InnoDB SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND p2c.category_id = '680' AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:857
10 (0.088)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1593
11 (0.465)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name DESC LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
12 (1.545)
SELECT a.attribute_group_id AS group_id, av.attribute_id AS attr_id, av.attribute_value_id AS val_id, ad.name AS attr_name, av.sort_order AS val_sort, av.value
FROM `oc_bf_product_attribute_value` AS af
INNER JOIN `oc_bf_tmp_product` AS p ON (af.product_id = p.product_id)
INNER JOIN `oc_bf_attribute_value` AS av ON (af.attribute_value_id = av.attribute_value_id)
INNER JOIN `oc_attribute` AS a ON (a.attribute_id = av.attribute_id)
INNER JOIN `oc_attribute_description` AS ad ON (ad.attribute_id = a.attribute_id)
WHERE ad.language_id = '2' AND av.language_id = '2' AND match_filters = 1 GROUP BY av.attribute_value_id
ORDER BY a.sort_order, ad.name, av.sort_order, CAST(av.value AS UNSIGNED), av.value
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1286
13 (0.188)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1393
14 (0.073)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1415
15 (0.094)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1180
16 (0.801)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1094
17 (0.141)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '1' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"680"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
18 (0.116)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '0' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"680"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
19 (0.071)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37