Gama variata de produse

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

Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

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 simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Oferte speciale


Mulineta Fox Eos 10000

Cod produs: crl059
Livrare imediată!

401,76Lei(-10%) 361,58Lei

Rod Pod Fox Horizon Dual Pod 4 Posturi

Cod produs: crp028
Livrare imediată!

1.028,95Lei(-10%) 926,05Lei

Set 4 Swingere Fox Mk2 Illuminated

Cod produs: csi055
Livrare imediată!

1.175,95Lei(-10%) 1.058,36Lei

Scaun Solar Undercover Camo Recliner

Cod produs: CA04
Livrare imediată!

431,15Lei(-10%) 388,04Lei

Lanseta Fox Eos 3.90m 3,5lbs 2 Segmente

Cod produs: crd255
Livrare imediată!

367,45Lei(-10%) 330,71Lei

Exclusiv online!

Mulineta Colmic W-beach 6500 10+1rul

Cod produs: mulwb01
Livrare 48-72 ore

672,00Lei(-30%) 471,00Lei

Mulineta Colmic Typon Fd 6000

Cod produs: multy60
Livrare imediată!

1.170,00Lei(-40%) 702,00Lei

Gamakatsu Carlige Forjate G-carp Method Bl 10b.pl,nr.2

Cod produs: gk.146824.2
Livrare imediată!

18,80Lei(-20%) 15,04Lei

Rod Pod Fox Horizon Dual 3 Posturi

Cod produs: crp027
Livrare imediată!

955,45Lei(-10%) 859,91Lei

Swinger Fox Mk2 Illuminated Culoare Neagra

Cod produs: csi053
Livrare imediată!

269,45Lei(-10%) 242,51Lei

Degetar Fox

Cod produs: cac572
Livrare imediată!

53,85Lei(-10%) 48,47Lei

Racheta De Nadire Spomb Mare Negru

Cod produs: dsm001
Livrare imediată!

88,16Lei(-10%) 79,34Lei

Brolly Mivardi Easy / 5000mm/ 215 X 225 X 145 Cm

Cod produs: m-broea
Livrare imediată!

698,99Lei(-20%) 559,20Lei

Mulineta Crap Spro Salerno 7500 / 9 Rulmenti

Cod produs: 001307-00975-00000
Livrare imediată!

577,50Lei(-31%) 399,90Lei

Exclusiv online!

Lanseta Carp Zoom Crap Fanatic Plus 50 12ft 3.66m 3.50lbs

Cod produs: cz1633
Livrare 48-72 ore

463,01Lei(-40%) 278,00Lei

Rod Pod Fox Ranger Mk2 4 Posturi

Cod produs: crp031
Livrare imediată!

2.106,95Lei(-10%) 1.896,27Lei

Racheta De Nadire Fox Impact Medium

Cod produs: CAC639
Livrare imediată!

83,25Lei(-10%) 74,93Lei

Kit Pentru Presa Bulgari Advance Fishing 45mm

Cod produs: adv75560
Livrare imediată!

89,90Lei(-20%) 71,92Lei

Pat Fox Royale Camo Compact

Cod produs: cbc054
Livrare imediată!

1.028,95Lei(-10%) 926,05Lei

Aditiv Praf Carp Zoom Special Black Halibut 250gr

Cod produs: CZ3063
Livrare imediată!

8,29Lei(-30%) 5,80Lei

But Rest Advance Fishing Italy Inox Easy Claw Culoare Verde

Cod produs: adv75044
Livrare imediată!

64,00Lei(-20%) 51,21Lei

Set Avertizori Fox Rx Plus 4buc Plus Statie

Cod produs: cei158
Livrare imediată!

4.630,44Lei(-10%) 4.167,42Lei

Exclusiv online!

Bluza Colmic Micro Fleece 2xl

Cod produs: abf004e
Livrare 48-72 ore

118,00Lei(-40%) 71,00Lei

Racheta De Nadire Spomb Mediu Negru

Cod produs: DSM003
Livrare imediată!

69,00Lei(-10%) 62,09Lei

Agrafa Cross Lock Colmic Cu Vartej Dublu Nr 18

Cod produs: gm303518
Livrare imediată!

19,00Lei(-30%) 13,30Lei

Cort Fox Retreat Plus 2 Man Bivy

Cod produs: cum202
Livrare imediată!

3.870,95Lei(-10%) 3.483,86Lei

Fox Bivvy Table

Cod produs: cac053
Livrare imediată!

293,95Lei(-10%) 264,56Lei

Cort Fox Eos 2 Man Bivvy

Cod produs: cum257
Livrare imediată!

1.298,44Lei(-10%) 1.168,62Lei

Exclusiv online!

Lanseta Colmic Wind Blade Match 3.90m 18gr 3seg

Cod produs: cbwi01a
Livrare 48-72 ore

450,00Lei(-30%) 315,00Lei

Racheta De Nadire Fox Impact Large

Cod produs: cac640
Livrare imediată!

90,59Lei(-10%) 81,54Lei

Mulineta Spro Lc Power 700 8+1bb

Cod produs: 001308-00970-00000
Livrare imediată!

651,00Lei(-31%) 449,90Lei

Rod Pod Fox Stalker Pod Plus

Cod produs: crp022
Livrare imediată!

636,95Lei(-10%) 573,26Lei

Exclusiv online!

Cort Tip Umbrela Jaxon 240x180x130cm

Cod produs: ak-kzs038
Livrare 48-72 ore

619,00Lei(-30%) 433,01Lei

Racheta De Nadire Spomb Mini Negru

Cod produs: dsm005
Livrare imediată!

52,00Lei(-10%) 46,80Lei

Brolly Fox Supa Brolley 50 System

Cod produs: cum174
Livrare imediată!

1.619,96Lei(-20%) 1.299,90Lei

Exclusiv online!

Cobra Carbon Fox Rangemaster 20mm Plus Husa

Cod produs: cac608
Livrare 7-14 zile

538,95Lei(-10%) 485,06Lei

Racheta De Nadire Spomb Mini Alb

Cod produs: dsm006
Livrare imediată!

52,00Lei(-10%) 46,80Lei

Anouri Fox Edges 3.2mm 25buc

Cod produs: cac544
Livrare imediată!

24,45Lei(-10%) 22,02Lei

Racheta De Nadire Spomb Mediu Alb

Cod produs: csm004
Livrare imediată!

69,00Lei(-10%) 62,09Lei

Aditiv Csl Carp Zoom Turbo Sauce 500ml Hot Spice

Cod produs: cz4894
Livrare imediată!

19,00Lei(-30%) 13,30Lei

Afişare 1 - 40 din 5435 (136 pagini)
Queries: 26, Total time: 1,065.727 ms [By time] [By id] [By file]
1 (0.282)
SELECT `data`
FROM `oc_session`
WHERE session_id = '5476833ac95ccc135002c0940d'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/session/db.php:23
2 (0.153)
SELECT *
FROM oc_platforma_promovari
/home/ffbro/public_html/magazindepescuitro.ro/index.php:74
3 (14.779)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/ffbro/public_html/magazindepescuitro.ro/index.php:159
4 (0.266)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/ffbro/public_html/magazindepescuitro.ro/index.php:237
5 (0.161)
SELECT *
FROM oc_currency
/home/ffbro/public_html/magazindepescuitro.ro/system/library/currency.php:13
6 (0.562)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/ffbro/public_html/magazindepescuitro.ro/system/library/tax.php:27
7 (0.453)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/ffbro/public_html/magazindepescuitro.ro/system/library/tax.php:55
8 (0.342)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/weight.php:9
9 (0.180)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/length.php:9
10 (0.155)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/openbay.php:116
11 (0.139)
SELECT *
FROM oc_event
/home/ffbro/public_html/magazindepescuitro.ro/index.php:338
12 (0.931)
SELECT *
FROM oc_setting
WHERE `code` = 'facebook'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/model/extension/facebooksetting.php:30
13 (0.164)
DROP TABLE IF EXISTS oc_bf_tmp_product
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/module/brainyfilter.php:641
14 (990.898)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) SELECT p.product_id, p.sort_order, "1" AS match_filters, (ps.price * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER 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`
WHERE customer_group_id = '1' AND ((based = 'store' AND country_id = '175' AND zone_id IN ('0', '0')) OR (based = 'shipping' AND country_id = '175' AND zone_id IN ('0', '0'))) GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE f.out_of_stock = 0 GROUP BY p.product_id
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/module/brainyfilter.php:642
15 (1.839)
SELECT COUNT(*) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/catalog/product.php:1480
16 (52.495)
SELECT p.*, pp.viewed
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 pp.viewed DESC, pd.name ASC LIMIT 0, 40
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/catalog/product.php:142
17 (0.366)
SELECT *
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/design/layout.php:4
18 (0.174)
SELECT *
FROM oc_layout_module
WHERE layout_id = '16' AND position = 'column_left'
ORDER BY sort_order
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/design/layout.php:14
19 (0.205)
SELECT *
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/design/layout.php:4
20 (0.165)
SELECT *
FROM oc_layout_module
WHERE layout_id = '16' AND position = 'column_right'
ORDER BY sort_order
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/design/layout.php:14
21 (0.199)
SELECT *
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/design/layout.php:4
22 (0.163)
SELECT *
FROM oc_layout_module
WHERE layout_id = '16' AND position = 'content_top'
ORDER BY sort_order
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/design/layout.php:14
23 (0.147)
SELECT *
FROM oc_platforma_promovari
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/common/platforma.php:4
24 (0.209)
SELECT *
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/design/layout.php:4
25 (0.160)
SELECT *
FROM oc_layout_module
WHERE layout_id = '16' AND position = 'content_bottom'
ORDER BY sort_order
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/design/layout.php:14
26 (0.140)
SELECT *
FROM oc_platforma_promovari
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/common/platforma.php:4