Water Pistol Clear Coloured Assorted

object(stdClass)#54 (194) { ["dis_id"]=> string(5) "63841" ["id"]=> string(5) "63841" ["code"]=> string(5) "59758" ["name"]=> string(36) "Water Pistol Clear Coloured Assorted" ["weight"]=> string(4) "0.15" ["unit"]=> string(1) "1" ["description"]=> string(648) "

Introducing our Mini Clear Coloured Water Pistol, a compact and visually vibrant addition to summer fun. Measuring a convenient 12 cm x 10 cm x 3 cm, these squirt guns are perfect for hot days, offering a classic and refreshing water play experience for kids.

The clear exterior showcases dynamic colors, adding an exciting visual element to every water fight. Despite their small size, these water pistols deliver ample entertainment, promising hours of laughter and enjoyment.

With an assorted mix of colors, each water gun becomes a lively surprise, turning the outdoor play into a memorable, dynamic experience.

" ["quantity"]=> string(2) "24" ["new_product"]=> string(0) "" ["feature_product"]=> string(0) "" ["on_special"]=> string(0) "" ["detail_page"]=> string(1) "0" ["group1_price"]=> string(4) "4.99" ["group2_price"]=> string(1) "0" ["group3_price"]=> string(1) "0" ["group1_special_price"]=> string(1) "0" ["group2_special_price"]=> string(1) "0" ["group1_special_discount"]=> string(1) "0" ["group2_special_discount"]=> string(1) "0" ["group3_special_discount"]=> string(1) "0" ["group3_special_price"]=> string(1) "0" ["product_option1"]=> string(1) "0" ["product_option2"]=> string(1) "0" ["product_option3"]=> string(1) "0" ["parent_id"]=> string(1) "0" ["web_ready"]=> string(1) "1" ["gst_applicable"]=> string(1) "1" ["image_small"]=> NULL ["image_medium"]=> NULL ["image_large"]=> NULL ["image_super"]=> NULL ["reg_date"]=> string(19) "2023-06-21 16:29:46" ["last_modified"]=> string(19) "2024-11-14 10:55:18" ["file_name"]=> string(36) "water-pistol-clear-coloured-assorted" ["specification1"]=> string(0) "" ["specification2"]=> string(0) "" ["specification3"]=> string(0) "" ["display_order"]=> string(1) "0" ["fixed_gst"]=> string(1) "0" ["consider_products"]=> NULL ["retail_qty"]=> string(1) "0" ["wholesale_qty"]=> string(1) "0" ["flex_id"]=> string(1) "0" ["short_description"]=> string(0) "" ["show_review"]=> string(1) "1" ["relation_ids"]=> NULL ["upsell_ids"]=> NULL ["carousel_ids"]=> NULL ["home_product"]=> string(0) "" ["enquire_only"]=> string(1) "0" ["style_notes"]=> string(0) "" ["prod_returns"]=> NULL ["details"]=> string(0) "" ["delivery"]=> NULL ["dimension"]=> string(0) "" ["comments"]=> NULL ["minimum_qty"]=> string(1) "0" ["combined_description"]=> NULL ["artist_id"]=> string(1) "0" ["portal_id"]=> string(3) ",1," ["sold"]=> string(1) "0" ["manufacturer"]=> string(8) "SY116CWG" ["rrp"]=> NULL ["delivery_perth"]=> NULL ["delivery_adelaide"]=> NULL ["delivery_nz"]=> NULL ["for_rent"]=> NULL ["capped_delivery"]=> NULL ["not_exportable"]=> NULL ["alcoholic"]=> NULL ["group2_description"]=> NULL ["group3_description"]=> NULL ["type"]=> string(1) "1" ["venue"]=> string(1) "0" ["start_date"]=> string(10) "0000-00-00" ["end_date"]=> string(10) "0000-00-00" ["subcatid"]=> string(1) "0" ["times"]=> NULL ["available"]=> NULL ["from_dt"]=> string(19) "0000-00-00 00:00:00" ["to_dt"]=> string(19) "0000-00-00 00:00:00" ["course_length"]=> NULL ["basic_description"]=> NULL ["start_hour"]=> string(1) "0" ["start_minute"]=> string(1) "0" ["start_am_pm"]=> string(2) "am" ["end_hour"]=> string(1) "0" ["end_minute"]=> string(1) "0" ["end_am_pm"]=> string(2) "am" ["custcat_id"]=> string(1) "0" ["new_product_portal_id"]=> NULL ["special_product_portal_id"]=> NULL ["quantity_portal_2"]=> string(1) "0" ["out_of_stock"]=> string(1) "0" ["quantity_portal_3"]=> string(1) "0" ["FT_CARTON_QTY"]=> string(1) "0" ["FT_CARTON_VOLUME"]=> string(4) "0.00" ["FT_LENGTH"]=> string(5) "12.00" ["FT_WIDTH"]=> string(4) "2.00" ["FT_HEIGHT"]=> string(5) "10.00" ["FT_WEIGHT"]=> string(4) "0.15" ["FT_DEFAULT"]=> string(1) "0" ["quantity_portal2"]=> string(1) "0" ["quantity_portal3"]=> string(1) "0" ["new_product_portal2"]=> string(1) "0" ["new_product_portal3"]=> string(1) "0" ["group1_special_price_portal2"]=> string(1) "0" ["group1_special_price_portal3"]=> string(1) "0" ["group1_special_discount_portal2"]=> string(1) "0" ["group1_special_discount_portal3"]=> string(1) "0" ["description_portal2"]=> string(0) "" ["description_portal3"]=> string(0) "" ["home_product_portal2"]=> string(0) "" ["home_product_portal3"]=> string(1) "0" ["feature_product_portal2"]=> string(1) "0" ["feature_product_portal3"]=> string(1) "0" ["qty_slab1"]=> string(1) "0" ["price_slab1"]=> string(1) "0" ["qty_slab1_portal2"]=> string(1) "0" ["price_slab1_portal2"]=> string(1) "0" ["qty_slab1_portal3"]=> string(1) "0" ["price_slab1_portal3"]=> string(1) "0" ["qty_slab2"]=> string(1) "0" ["price_slab2"]=> string(1) "0" ["qty_slab2_portal2"]=> string(1) "0" ["price_slab2_portal2"]=> string(1) "0" ["qty_slab2_portal3"]=> string(1) "0" ["price_slab2_portal3"]=> string(1) "0" ["discount_value"]=> string(4) "0.00" ["discount_type"]=> string(1) "1" ["valid_from"]=> string(10) "0000-00-00" ["valid_to"]=> string(10) "0000-00-00" ["group1_price_portal2"]=> string(1) "0" ["group1_price_portal3"]=> string(1) "0" ["group2_price_portal2"]=> string(1) "0" ["group2_price_portal3"]=> string(1) "0" ["group3_price_portal2"]=> string(1) "0" ["group3_price_portal3"]=> string(1) "0" ["expected_price"]=> string(1) "0" ["tool_tip"]=> string(0) "" ["cw_video"]=> string(0) "" ["rm_video"]=> string(0) "" ["PD_COLOUR"]=> NULL ["PD_SIZE"]=> NULL ["old_short_description"]=> string(0) "" ["home_displayorder"]=> NULL ["home_displayorder_portal2"]=> string(1) "0" ["home_displayorder_portal3"]=> NULL ["discount_value_portal2"]=> string(4) "0.00" ["discount_type_portal2"]=> string(1) "1" ["valid_from_portal2"]=> string(10) "0000-00-00" ["valid_to_portal2"]=> string(10) "0000-00-00" ["outofstock_level"]=> string(1) "1" ["stocksellingfast_level"]=> string(1) "0" ["almostsoldout_level"]=> string(1) "0" ["always_instock"]=> string(1) "0" ["shipping_au_only"]=> string(1) "0" ["location"]=> NULL ["totalamount_sold"]=> string(1) "0" ["tags"]=> string(34) ",392,391,91,101,115,452,380,4,5,6," ["fixed_price_stock"]=> string(1) "0" ["show_matrix"]=> string(1) "0" ["howtoshow_spec1"]=> string(1) "D" ["howtoshow_spec2"]=> string(1) "D" ["howtoshow_spec3"]=> string(1) "D" ["include_in_matrix_spec1"]=> string(1) "0" ["include_in_matrix_spec2"]=> string(1) "0" ["include_in_matrix_spec3"]=> string(1) "0" ["wish_qty"]=> string(1) "0" ["include_in_cron_email"]=> string(1) "1" ["nameCopy"]=> NULL ["is_dupe"]=> string(1) "0" ["similarity"]=> string(2) "-1" ["pos_product_id"]=> string(6) "189595" ["barcode"]=> string(13) "9319374061861" ["tags_2016"]=> string(1) "," ["tags_new"]=> string(1) "," ["tags_backup"]=> string(1) "," ["future_price"]=> string(1) "0" ["affiliate_commission"]=> string(1) "0" ["bin_number"]=> string(0) "" ["tip_count"]=> string(1) "0" ["a5_desc"]=> NULL ["apprentice_price"]=> string(1) "0" ["senior_price"]=> string(1) "0" ["master_price"]=> string(1) "0" ["was_price"]=> string(1) "0" ["instore_only"]=> string(1) "0" ["is_special"]=> string(1) "0" ["instore_stock_only"]=> string(1) "0" ["instore_stock_only_bak"]=> string(1) "0" ["brand_name"]=> string(5) "Other" ["ajax_text"]=> string(0) "" ["word_count"]=> string(2) "97" }