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

Căutare - vu.2.5878

Produse ce potrivesc criteriilor de căutare


KIT INSTALARE CORT TRAKKO
Exclusiv online!

KIT INSTALARE CORT TRAKKO

tr3278
Livrare 48-72 ore

79,00Lei

Cuie Cort Baracuda Standard

Cuie Cort Baracuda Standard

cuie standard pt. cort
Livrare imediată!

65,90Lei

Cort Prologic Utilitar 1 Persoana Fulcrum 260 x 210cm -29%

Cort Prologic Utilitar 1 Persoana Fulcrum 260 x 210cm

a8.pro.72681
Livrare imediată!

1.699,00Lei(-29%) 1.199,00Lei

Cort Coleman Rocky Mountain 5 -18%
Exclusiv online!

Cort Coleman Rocky Mountain 5

2000030284
Livrare 24-48 ore

3.549,00Lei(-18%) 2.898,99Lei

CORT PROLOGIC INSPIRE BIVVY CONDENSER WRAP 1 PERS -20%
Exclusiv online!

CORT PROLOGIC INSPIRE BIVVY CONDENSER WRAP 1 PERS

a8.pro.64148
Livrare 24-48 ore

2.628,48Lei(-20%) 2.102,78Lei

CORT PROLOGIC AVENGER BIVVY OVERWRAP 2 PERS
Exclusiv online!

CORT PROLOGIC AVENGER BIVVY OVERWRAP 2 PERS

a8.pro.64156
Livrare 24-48 ore

2.209,28Lei

CORT JRC DEFENDER SHELTER 280x200x135cm

CORT JRC DEFENDER SHELTER 280x200x135cm

1441620
Livrare imediată!

749,95Lei

CORT PROLOGIC AVENGER 65 -25%

CORT PROLOGIC AVENGER 65

a8.pro.72683
Livrare imediată!

1.474,90Lei(-25%) 1.099,00Lei

Cort JRC Rova Peak 2 Men Bivvy Camo, 150x300x295cm -32%

Cort JRC Rova Peak 2 Men Bivvy Camo, 150x300x295cm

1537848
Livrare imediată!

1.400,00Lei(-32%) 950,00Lei

Lampa Cort si Barca Black Cat Fishing Light Red White
Exclusiv online!

Lampa Cort si Barca Black Cat Fishing Light Red White

9895034
Livrare 7-14 zile

49,28Lei

Cort Prologic C-Series Bivvy 2 Persoane

Cort Prologic C-Series Bivvy 2 Persoane

a8.pro.72788
Livrare imediată!

1.257,98Lei

LAMPA PROLOGIC CORT C-SERIES 150LM -20%

LAMPA PROLOGIC CORT C-SERIES 150LM

a8.pro.70717
Livrare imediată!

180,78Lei(-20%) 144,62Lei

Cort Coleman Festival Octagon 8 -20%
Exclusiv online!

Cort Coleman Festival Octagon 8

2000032323
Livrare 24-48 ore

2.572,99Lei(-20%) 2.050,00Lei

CORT KORUM DAY SHELTER LITE 140X195X170CM
Exclusiv online!

CORT KORUM DAY SHELTER LITE 140X195X170CM

k0370003
Livrare 7-14 zile

629,96Lei

CORT PROLOGIC AVENGER BIVVY/CONDENSER WARP 1PERS

CORT PROLOGIC AVENGER BIVVY/CONDENSER WARP 1PERS

a8.pro.64155
Livrare imediată!

1.529,50Lei

Cort Coleman OctaGO 3
Exclusiv online!

Cort Coleman OctaGO 3

2000035194
Livrare 24-48 ore

1.499,00Lei

Cort Coleman Ridgeline 6 Plus
Exclusiv online!

Cort Coleman Ridgeline 6 Plus

205108
Livrare 24-48 ore

2.350,00Lei

Cort Fast Pitch Pop up Coleman Galiano 4 -18%
Exclusiv online!

Cort Fast Pitch Pop up Coleman Galiano 4

2000035213
Livrare 24-48 ore

849,01Lei(-18%) 698,99Lei

Cort Coleman Castle Pines 4 -15%
Exclusiv online!

Cort Coleman Castle Pines 4

2000037062
Livrare 24-48 ore

3.999,00Lei(-15%) 3.399,00Lei

Cort Fast Pitch Pop up Coleman Galiano 2 -20%
Exclusiv online!

Cort Fast Pitch Pop up Coleman Galiano 2

200035212
Livrare 24-48 ore

690,00Lei(-20%) 548,99Lei

Afişare 181 - 200 din 342 (18 pagini)
Queries: 4, Total time: 8.900 ms [By time] [By id] [By file]
1 (0.088)
SELECT data
FROM `oc_session`
WHERE session_id = '9120d39d3ffec212a2b341f107'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.097)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (8.597)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY 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_description` AS pd ON (pd.product_id = p.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 (MATCH(pd.tag) AGAINST('+cort' IN BOOLEAN MODE)) 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:737
4 (0.118)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38