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

Scaune Modulare Feeder

Filtreaza

Scaun Feeder Cresta Blackthorne 92x62x19 Cm

Cod produs: 006402-00500-00000
Livrare imediată!

770,70Lei

Scaun Trabucco Genius Box S1 Light-promo

Cod produs: 116-70-100
Livrare imediată!

565,00Lei

Scaun Genlog Seat Feeder Chair

Cod produs: ggfs-01
Livrare imediată!

1.015,00Lei

Scaun Matrix F25 Seatbox Mkii System

Cod produs: gmb156
Livrare imediată!

2.302,95Lei(-10%) 2.072,66Lei

Scaun Matrix Deluxe Accessory Chair

Cod produs: gbc002
Livrare imediată!

734,94Lei(-10%) 661,45Lei

Exclusiv online!

Scaun Ron Thompson Ontario

Cod produs: A8.THO.47407
Livrare 24-48 ore

535,73Lei

Exclusiv online!

Scaun Modular Colmic Hurricane Plus Tava Laterala

Cod produs: pa1004
Livrare 48-72 ore

2.204,00Lei

Exclusiv online!

Platforma Colmic Pro Pliabila 95x75cm

Cod produs: pa0900a76
Livrare 48-72 ore

1.098,00Lei

Exclusiv online!

Scaun Daiwa Stationar 40

Cod produs: d.15811.540
Livrare 24-48 ore

656,92Lei

Exclusiv online!

Scaun Colmic Modular Delta Jf Blue

Cod produs: pa0804c
Livrare 48-72 ore

4.445,00Lei

Scaun Matrix S25 Super Box Black Inc 1 X Shallow Trays

Cod produs: gmb147
Livrare imediată!

2.111,95Lei(-19%) 1.710,68Lei

Exclusiv online!

Scaun Modular Colmic Iros Special 100

Cod produs: pa10100a
Livrare 48-72 ore

927,00Lei

Fotoliu Team Feeder By Dome

Cod produs: 7141-001
Livrare imediată!

555,00Lei

Exclusiv online!

Platforma Garbolino Panier Competition Gold D36-51

Cod produs: 90330GOMEH3715-BL
Livrare 48-72 ore

2.896,10Lei(-25%) 2.169,08Lei

Exclusiv online!

Scaun Carp Zoom Feeder Competition 54x45x47/100cm

Cod produs: CZ0510
Livrare 48-72 ore

410,00Lei

Scaun Modular Trakko New Method Feeder Tr14659

Cod produs: tr14659
Livrare imediată!

345,00Lei

Exclusiv online!

Scaun Modular Trabucco Genius Box S1 H40

Cod produs: 116-70-200
Livrare 48-72 ore

670,01Lei

Afişare 1 - 17 din 17 (1 pagini)


Queries: 14, Total time: 17.718 ms [By time] [By id] [By file]
1 (0.293)
SELECT `data`
FROM `oc_session`
WHERE session_id = '405a8ee319cd75a70481894712'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/session/db.php:23
2 (0.188)
SELECT *
FROM oc_platforma_promovari
/home/ffbro/public_html/magazindepescuitro.ro/index.php:74
3 (13.123)
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.265)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/ffbro/public_html/magazindepescuitro.ro/index.php:237
5 (0.171)
SELECT *
FROM oc_currency
/home/ffbro/public_html/magazindepescuitro.ro/system/library/currency.php:13
6 (0.623)
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.434)
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.202)
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.188)
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.148)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/openbay.php:116
11 (0.136)
SELECT *
FROM oc_event
/home/ffbro/public_html/magazindepescuitro.ro/index.php:338
12 (0.270)
SELECT *
FROM oc_url_alias
WHERE keyword = 'pescuit-la-feeder'
/home/ffbro/public_html/magazindepescuitro.ro/catalog/controller/common/seo_url.php:71
13 (0.183)
SELECT *
FROM oc_url_alias
WHERE keyword = 'scaune-modulare-feeder'
/home/ffbro/public_html/magazindepescuitro.ro/catalog/controller/common/seo_url.php:71
14 (1.494)
SELECT *
FROM oc_setting
WHERE `code` = 'facebook'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/model/extension/facebooksetting.php:30