Kortingen tot 85% * Bestel nu uw vuurwerk online! * Kwaliteitsvuurwerk tegen dumpprijzen! * 31 december tot 20.00 uur geopend *

Vuurwerk kopen in Sittard bij Sparkles Vuurwerk

Sparkles Vuurwerk is één van de officiële Vuurwerktoppers dealers in Limburg, Sparkles is gevestigd in Sittard. Sparkles Vuurwerk levert onder andere de bekende Crystal collectie, Red Dragon, Black Thunder, German Power en Showtime.

Ons assortiment bestaat uit kleine siercakes tot de grootste cakeboxen van Nederland! Hiermee creëer jij een eigen vuurwerkshow in jouw straat!

Het bestellen van vuurwerk gaat eenvoudig hier via de site. De collectie van vuurwerktoppers.nl zal namelijk niet helemaal in onze showroom aanwezig zijn. Wanneer u online besteld, dan zorgen wij ervoor dat de bestelling op het gewenste moment voor u klaar staat in onze winkel.

Vuurwerk kopen Sittard, Geleen, Brunssum, Nuth, Hoensbroek, Heerlen en Landgraaf

Ons afzetgebied bestaat onder andere uit: Sittard, Geleen, Brunssum, Nuth, Hoensbroek, Heerlen en Landgraaf. We zien veel mensen uit de omgeving al jaren in onze winkel terug. Dat is niet voor niets, bij ons bent u aan het juiste adres voor topkwaliteit vuurwerk tegen scherpe prijzen. Uw bent uiteraard van harte welkom voor advies bij uw vuurwerkbestelling in onze winkel aan de Oslostraat 80 in Sittard.

PowerPrijzen

Profi final

art. 2999
269,99
-26%
199,99

Excellent Box

art. 2993
129,99
-23%
99,99

Dream planet

art. 2320
99,99

Night hunter

art. 2315
84,99

Great sphinx

art. 3624
79,99

Quattro Pack

art. 3480
79,99

Black celebration cracker 100.000

art. 2067
69,99
-29%
49,99

Gold rush

art. 6220
59,99

Thunder shock bulk

art. 2329
49,99
-30%
34,99

WTF BOX

art. 3470
39,99

Willow fan

art. 3490
32,50

Record breaker

art. 6230
24,99

Magnolia spectacle

art. 2305
23,50

Stargate

art. 6212
23,49

Metersierpakket

art. 2980
22,99
-24%
17,49

Mysterious

art. 6240
19,99

Pijlpakket Air-attack 2

art. 2680
19,99

Midnight passion

art. 2310
19,99

Epic Shock XL

art. 2324
17,99
-28%
12,99

Typhoon

art. 6211
15,99

Thunder rockets 6 stuks

art. 2330
8,99
-22%
6,99

Thunder shock

art. 2325
2,99
-33%
1,99

Jumping jack

art. 2312
1,99

Epic Shocks

art. 2323
1,69
-30%
1,19

Grondbloemen

art. 2317
1,59
-19%
1,29

Mega bomb cracker

art. 2016
1,29
-23%
0,99
  BENCHMARKS  
Loading Time: Base Classes  0.0007
Controller Execution Time ( Products / Powerprices )  0.1020
  :  caff   QUERIES: 43  ()
0.0018   SELECT table_name FROM information_schema.tables WHERE table_schema 'public' 
0.0002   SET bytea_output=escape 
0.0008   SELECT id FROM delivery_addresses WHERE LOWER(webshop_slug) = LOWER('sparkles') 
0.0004  
            SELECT id
                 
dealer_id
                 
street
                 
house_number
                 
zip_code
                 
country
                 
city
                 
latitude
                 
longitude
                 
deleted
                 
webshop_active
                 
webshop_slug
                 
webshop_marquee_text
                 
webshop_information
                 
webshop_store_hours
                 
webshop_ordering_allowed
                 
webshop_twitter
                 
webshop_facebook
                 
max_kilo_per_timezone
                 
max_orders_per_timezone
                 
email_address
                 
webshop_order_cc_email_address
                 
logo_path
                 
webshop_online_folder_path
                 
name
                 
webshop_resell_enabled
                 
webshop_resell_discount_percentage
                 
seo_text
                 
api_key
              FROM delivery_addresses
             WHERE id 
'327' AND deleted 'f'
         
0.0003  
            SELECT phone_number
smsfaxfor_webshop
              FROM delivery_address_phone_numbers
             WHERE delivery_address_id 
'327'
         
0.0004  
              SELECT start_time
end_timeactiveid
                FROM delivery_address_time_zones
               WHERE delivery_address_id 
'327'
            
ORDER BY start_time ASC
             
0.0004  
              SELECT id
                   
name
                   
internal_name
                   
active
                   
remark
                   
debtor_number
                   
prepay
                   
automatic_reservations
                   
invoice_email_address
                   
invoice_address_street
                   
invoice_address_house_number
                   
invoice_address_zip_code
                   
invoice_address_country
                   
invoice_address_city
                   
price_list_id
                   
free_products
                   
free_products_cash_register
                   
product_set_id
                   
pin_enabled
                   
wants_newsletter
                   
has_price_control
                   
allow_minus_sales
                   
is_platinum
                FROM dealers
               WHERE deleted 
false
                 
AND id '293'
            
ORDER BY name ASC
         
0.0004  
            SELECT id
                 
dealer_id
                 
street
                 
house_number
                 
zip_code
                 
country
                 
city
                 
latitude
                 
longitude
                 
deleted
                 
webshop_active
                 
webshop_slug
                 
webshop_marquee_text
                 
webshop_information
                 
webshop_store_hours
                 
webshop_ordering_allowed
                 
webshop_twitter
                 
webshop_facebook
                 
max_kilo_per_timezone
                 
max_orders_per_timezone
                 
email_address
                 
webshop_order_cc_email_address
                 
logo_path
                 
webshop_online_folder_path
                 
name
                 
webshop_resell_enabled
                 
webshop_resell_discount_percentage
                 
driving_time
                 
api_key
              FROM delivery_addresses
             WHERE 
'293' IS NULL OR dealer_id '293' AND deleted 'f'
          
ORDER BY city ASC
         
0.0002  
            SELECT phone_number
smsfaxfor_webshop
              FROM delivery_address_phone_numbers
             WHERE delivery_address_id 
'327'
         
0.0005  
              SELECT start_time
end_timeactiveid
                FROM delivery_address_time_zones
               WHERE delivery_address_id 
'327'
            
ORDER BY start_time ASC
             
0.0003  
            SELECT id
image_path FROM dealer_webshop_slider_images WHERE dealer_id '293'
         
0.0003  
            SELECT id
                 
name
                 
active
                 
invoice_email_address
                 
remark
                 
debtor_number
                 
prepay
                 
automatic_reservations
                 
invoice_address_street
                 
invoice_address_house_number
                 
invoice_address_zip_code
                 
invoice_address_country
                 
invoice_address_city
                 
deleted
                 
price_list_id
                 
free_products
                 
product_set_id
                 
wants_newsletter
                 
pin_enabled
                 
has_price_control
                 
free_products_cash_register
              FROM dealers
             WHERE id IN 
('293')
         
0.0003  
            SELECT product_id
maximum FROM dealer_product_maximums WHERE dealer_id '293'
         
0.0002  
            SELECT id FROM product_sets WHERE id 
'11'
         
0.0010  
                    SELECT product_id FROM product_set_products WHERE product_set_id 
'11'
                 
0.0006  
                SELECT id
image_pathproduct_iddescriptionsort_order
                FROM product_set_slides
                WHERE product_set_id 
'11'
             
0.0017  
               SELECT p
.id
                    
p.namep.description
                    
p.brand_idb.name AS brand_name
                    
p.active
                    
p.gross_weight_per_boxp.weight_per_article
                    
p.barcode_boxp.barcode_productp.skup.article_number
                    
p.ce_numberp.ce_categoryp.nem_per_box
                    
p.hazard_code_class_numberp.hazard_code_compatibility_group
                    
p.sales_price_per_articlep.sales_price_per_article_for_discountp.power_price
                    
p.burn_timep.effect_height
                    
p.articles_per_boxp.packed_by
                    
p.warehouse_locationp.warehouse_sublocation
                    
p.shots_per_cakep.is_fan
                    
p.primary_image_id
                    
p.slug
                    
p.is_safety_product
                    
p.expose_in_api
                    
p.min_main_warehouse_stock
                    
p.cbm
                    
p.is_rocket
                 FROM products 
AS p

            LEFT JOIN product_brands 
AS b
                   ON b
.id p.brand_id            

                WHERE p
.id '1178'
         
0.0006  
                SELECT c
.namec.idc.slug
                  FROM product_categories 
AS c
                  JOIN product_categorizations 
AS cz
                    ON cz
.category_id c.id
                 WHERE cz
.product_id '1178'
             
0.0003  
            SELECT 
*
              
FROM product_assets
             WHERE product_id 
'1178'
         
0.0003  
              SELECT ps
.id,
                     
ps.name,
                     
ps.logo_path,
                     
ps.slug,
                     
ps.description
                FROM product_brands ps
               WHERE id 
'20'
         
0.0008  
               SELECT p
.id
                    
p.namep.description
                    
p.brand_idb.name AS brand_name
                    
p.active
                    
p.gross_weight_per_boxp.weight_per_article
                    
p.barcode_boxp.barcode_productp.skup.article_number
                    
p.ce_numberp.ce_categoryp.nem_per_box
                    
p.hazard_code_class_numberp.hazard_code_compatibility_group
                    
p.sales_price_per_articlep.sales_price_per_article_for_discountp.power_price
                    
p.burn_timep.effect_height
                    
p.articles_per_boxp.packed_by
                    
p.warehouse_locationp.warehouse_sublocation
                    
p.shots_per_cakep.is_fan
                    
p.primary_image_id
                    
p.slug
                    
p.is_safety_product
                    
p.expose_in_api
                    
p.min_main_warehouse_stock
                    
p.cbm
                    
p.is_rocket
                 FROM products 
AS p

            LEFT JOIN product_brands 
AS b
                   ON b
.id p.brand_id            

                WHERE p
.id '475'
         
0.0007  
                SELECT c
.namec.idc.slug
                  FROM product_categories 
AS c
                  JOIN product_categorizations 
AS cz
                    ON cz
.category_id c.id
                 WHERE cz
.product_id '475'
             
0.0004  
            SELECT 
*
              
FROM product_assets
             WHERE product_id 
'475'
         
0.0004  
              SELECT ps
.id,
                     
ps.name,
                     
ps.logo_path,
                     
ps.slug,
                     
ps.description
                FROM product_brands ps
               WHERE id 
'18'
         
0.0009  
               SELECT p
.id
                    
p.namep.description
                    
p.brand_idb.name AS brand_name
                    
p.active
                    
p.gross_weight_per_boxp.weight_per_article
                    
p.barcode_boxp.barcode_productp.skup.article_number
                    
p.ce_numberp.ce_categoryp.nem_per_box
                    
p.hazard_code_class_numberp.hazard_code_compatibility_group
                    
p.sales_price_per_articlep.sales_price_per_article_for_discountp.power_price
                    
p.burn_timep.effect_height
                    
p.articles_per_boxp.packed_by
                    
p.warehouse_locationp.warehouse_sublocation
                    
p.shots_per_cakep.is_fan
                    
p.primary_image_id
                    
p.slug
                    
p.is_safety_product
                    
p.expose_in_api
                    
p.min_main_warehouse_stock
                    
p.cbm
                    
p.is_rocket
                 FROM products 
AS p

            LEFT JOIN product_brands 
AS b
                   ON b
.id p.brand_id            

                WHERE p
.id '476'
         
0.0005  
                SELECT c
.namec.idc.slug
                  FROM product_categories 
AS c
                  JOIN product_categorizations 
AS cz
                    ON cz
.category_id c.id
                 WHERE cz
.product_id '476'
             
0.0003  
            SELECT 
*
              
FROM product_assets
             WHERE product_id 
'476'
         
0.0003  
              SELECT ps
.id,
                     
ps.name,
                     
ps.logo_path,
                     
ps.slug,
                     
ps.description
                FROM product_brands ps
               WHERE id 
'18'
         
0.0006  
               SELECT p
.id
                    
p.namep.description
                    
p.brand_idb.name AS brand_name
                    
p.active
                    
p.gross_weight_per_boxp.weight_per_article
                    
p.barcode_boxp.barcode_productp.skup.article_number
                    
p.ce_numberp.ce_categoryp.nem_per_box
                    
p.hazard_code_class_numberp.hazard_code_compatibility_group
                    
p.sales_price_per_articlep.sales_price_per_article_for_discountp.power_price
                    
p.burn_timep.effect_height
                    
p.articles_per_boxp.packed_by
                    
p.warehouse_locationp.warehouse_sublocation
                    
p.shots_per_cakep.is_fan
                    
p.primary_image_id
                    
p.slug
                    
p.is_safety_product
                    
p.expose_in_api
                    
p.min_main_warehouse_stock
                    
p.cbm
                    
p.is_rocket
                 FROM products 
AS p

            LEFT JOIN product_brands 
AS b
                   ON b
.id p.brand_id            

                WHERE p
.id '1180'
         
0.0006  
                SELECT c
.namec.idc.slug
                  FROM product_categories 
AS c
                  JOIN product_categorizations 
AS cz
                    ON cz
.category_id c.id
                 WHERE cz
.product_id '1180'
             
0.0003  
            SELECT 
*
              
FROM product_assets
             WHERE product_id 
'1180'
         
0.0003  
              SELECT ps
.id,
                     
ps.name,
                     
ps.logo_path,
                     
ps.slug,
                     
ps.description
                FROM product_brands ps
               WHERE id 
'20'
         
0.0012  
                SELECT product_id 
AS id
                  FROM dealer_product_exceptions
                 WHERE dealer_id 
'293'

                 
UNION

                SELECT psp
.product_id AS id
                  FROM product_set_products 
AS psp
                 WHERE psp
.product_set_id ( SELECT d.product_set_id
                                                FROM dealers 
AS d
                                               WHERE d
.id '293'
                                            
)
             
0.0029  
               SELECT p
.*, b.name AS brand_name
                 FROM products 
AS p

            LEFT JOIN product_brands 
AS b
                   ON b
.id p.brand_id            

                WHERE p
.id IN (48535118410814774815503045521461172190107516234155448336417019217616911743303091805471067156197117568947511674704544826931734781493293111171108523523942025732815314748011663383587031170349116868716011766913243103573311070116510772493531713073661651068151116454630517968636132168111734661084325216174472484107116316869037321935210581753633434673623271676923121177231340158108646015548719510764596992074883683691180194339326360476367107320636511783551571083413308107215035910801911591087495154316709474177107454911791852151781082145148486)
                
ORDER BY p.name
         
0.0032  
                SELECT c
.namec.idc.slugcz.product_id
                  FROM product_categories 
AS c
                  JOIN product_categorizations 
AS cz
                    ON cz
.category_id c.id
                 WHERE cz
.product_id IN (48535118410814774815503045521461172190107516234155448336417019217616911743303091805471067156197117568947511674704544826931734781493293111171108523523942025732815314748011663383587031170349116868716011766913243103573311070116510772493531713073661651068151116454630517968636132168111734661084325216174472484107116316869037321935210581753633434673623271676923121177231340158108646015548719510764596992074883683691180194339326360476367107320636511783551571083413308107215035910801911591087495154316709474177107454911791852151781082145148486)
             
0.0007  
              SELECT 
*
                
FROM product_brands
               WHERE id IN 
(2933202717221815191432212623)
         
0.0025  
            SELECT 
*
              
FROM product_assets
             WHERE product_id IN 
(48535118410814774815503045521461172190107516234155448336417019217616911743303091805471067156197117568947511674704544826931734781493293111171108523523942025732815314748011663383587031170349116868716011766913243103573311070116510772493531713073661651068151116454630517968636132168111734661084325216174472484107116316869037321935210581753633434673623271676923121177231340158108646015548719510764596992074883683691180194339326360476367107320636511783551571083413308107215035910801911591087495154316709474177107454911791852151781082145148486)
         
0.0058  
            SELECT p
.id,
                  ( CASE
                     
WHEN p.power_price
                       THEN coalesce
( ( SELECT pp.price
                                        FROM powerprices 
AS pp
                                        WHERE pp
.dealer_id '293'
                                              
AND pp.product_id p.id
                                      
)
                       , 
p.sales_price_per_article
                       
)
            
                     ELSE 
p.sales_price_per_article
                     END
                   
) AS price
            FROM products 
AS p
            WHERE p
.id IN (48535118410814774815503045521461172190107516234155448336417019217616911743303091805471067156197117568947511674704544826931734781493293111171108523523942025732815314748011663383587031170349116868716011766913243103573311070116510772493531713073661651068151116454630517968636132168111734661084325216174472484107116316869037321935210581753633434673623271676923121177231340158108646015548719510764596992074883683691180194339326360476367107320636511783551571083413308107215035910801911591087495154316709474177107454911791852151781082145148486)
            
ORDER BY p.id        
         
0.0046  
            SELECT
              products
.id,
              
products.name,
              
products.article_number,
              
alternative_products.original_product_article
              FROM alternative_products
              JOIN products on products
.article_number alternative_products.article_number
                WHERE alternative_products
.original_product_article IN (9259233622342734322688250540503612404726202065206720662014207120252479248026182326202734258030407520542056205034212452206036072215408034423423911341980452320244959823232324351029933307341523623303802580608035299122063585341762053505912500362203624231722122570246924563606299723653305231225699323500251725168015354822312222220834472319230520162080298023102367353522213431251124676240231535503618246829922680268226842670935922224935302630299529994060802034806230407033013408340936058040298529542955296025502360352061303525299825188065621280102547254025432545807034602220362020752454617023302325232934452512621134202022237034369319103610354634902458347080462560) 
                AND 
alternative_products.article_number IN (9259233622342734322688250540503612404726202065206720662014207120252479248026182326202734258030407520542056205034212452206036072215408034423423911341980452320244959823232324351029933307341523623303802580608035299122063585341762053505912500362203624231722122570246924563606299723653305231225699323500251725168015354822312222220834472319230520162080298023102367353522213431251124676240231535503618246829922680268226842670935922224935302630299529994060802034806230407033013408340936058040298529542955296025502360352061303525299825188065621280102547254025432545807034602220362020752454617023302325232934452512621134202022237034369319103610354634902458347080462560)
              
0.0006  
                  SELECT id
parent_idnameimage_pathactiveslug
                    FROM product_categories
                   WHERE active 
't'
             
0.0003  
                    SELECT condition FROM admin_settings
                    WHERE name 
'overview_check_stocks'
         
0.0004  
            SELECT product_id 
              FROM delivery_address_manual_out_of_stock_products
             WHERE delivery_address_id 
'327' 
               
AND product_id IN (15847845910673554707031851844751451954766914773384825524725471531514606906991180)
         
0.0006  
            SELECT is_platinum
              FROM dealers 
             WHERE id 
'293' 
         
    
$_GET['dealer']   sparkles
  POST DATA  
Er is geen POST data
    
4,603,192 bytes
    
webshops
    
products/powerprices
    ()
HTTP_ACCEPT  text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_USER_AGENT  CCBot/2.0 (https://commoncrawl.org/faq/)
HTTP_CONNECTION  Keep-Alive
SERVER_PORT  443
SERVER_NAME  infovuurwerk.nl
REMOTE_ADDR  3.90.56.90
SERVER_SOFTWARE  nginx/1.15.3
HTTP_ACCEPT_LANGUAGE  en-US,en;q=0.5
SCRIPT_NAME  /index.php
REQUEST_METHOD  GET
HTTP_HOST  
REMOTE_HOST  
CONTENT_TYPE  
SERVER_PROTOCOL  HTTP/1.1
QUERY_STRING  dealer=sparkles
HTTP_ACCEPT_ENCODING  gzip
HTTP_X_FORWARDED_FOR  
    ()
base_url  https://infovuurwerk.nl/
index_page  
uri_protocol  AUTO
url_suffix  
language  dutch
charset  UTF-8
enable_hooks  
subclass_prefix  CAFF_
permitted_uri_chars  a-z 0-9~%.,|:_\-\ä\ü\ö\ë\ï\á\ú\ó\é\í
allow_get_array  1
enable_query_strings  
controller_trigger  c
function_trigger  m
directory_trigger  d
log_threshold  0
log_path  
log_date_format  Y-m-d H:i:s
cache_path  
encryption_key  some random string
jwt_secret_key  MxKkIS87PgIxB7UAuT3oBFthO8PG3AiPkD6FSlAETQ
sess_cookie_name  ci_session
sess_expiration  86400
sess_expire_on_close  
sess_encrypt_cookie  
sess_use_database  
sess_table_name  ci_sessions
sess_match_ip  
sess_match_useragent  1
sess_time_to_update  300
cookie_prefix  
cookie_domain  
cookie_path  /
cookie_secure  
global_xss_filtering  
csrf_protection  
csrf_token_name  csrf_test_name
csrf_cookie_name  csrf_cookie_name
csrf_expire  7200
compress_output  
time_reference  local
rewrite_short_tags  
proxy_ips