Pijnenburg Schoenen maakt gebruik van cookies. ik accepteer cookies
SELECT * FROM ShopStoresSEO WHERE storeid = 1 AND page = 'new' AND categoryid = 46 AND manufacturerid = 0 LIMIT 1
Filter

Nieuwe producten

1 - 6 van 6
Sorteer op:
array(6) { [0]=> string(5) "67671" [1]=> string(5) "19363" [2]=> string(5) "19372" [3]=> string(5) "19354" [4]=> string(5) "19275" [5]=> string(5) "19266" }
object(stdClass)#193 (25) { ["id"]=> string(5) "67671" ["children"]=> int(8) ["name"]=> string(38) "Collonil 15100200 Stretchschuim N.v.t." ["keyname"]=> string(37) "collonil-15100200-stretchschuim-n-v-t" ["brand"]=> string(8) "COLLONIL" ["label"]=> string(0) "" ["label_color"]=> string(0) "" ["url"]=> string(0) "" ["path"]=> string(81) "./producten/onderhoud/waterproof/67671/collonil-15100200-stretchschuim-n-v-t.html" ["img"]=> array(4) { ["small"]=> string(80) "./upload/products/small/18991/collonil-collonil-15100200-stretchschuim-n-v-t.jpg" ["medium"]=> string(81) "./upload/products/medium/18991/collonil-collonil-15100200-stretchschuim-n-v-t.jpg" ["large"]=> string(80) "./upload/products/large/18991/collonil-collonil-15100200-stretchschuim-n-v-t.jpg" ["extra_large"]=> string(86) "./upload/products/extra_large/18991/collonil-collonil-15100200-stretchschuim-n-v-t.jpg" } ["photoid"]=> string(5) "18991" ["price"]=> string(4) "7.95" ["price_alt"]=> int(0) ["price_advise"]=> string(4) "0.00" ["price_from"]=> string(0) "" ["unit"]=> string(8) "per paar" ["unit_suffix"]=> string(0) "" ["unit_display"]=> string(1) "0" ["orderable"]=> string(1) "1" ["status"]=> string(11) "Op Voorraad" ["status_url"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["show_price"]=> string(1) "1" ["icons"]=> array(0) { } ["instock"]=> string(4) "0.00" }
array(6) { [0]=> string(5) "67671" [1]=> string(5) "19363" [2]=> string(5) "19372" [3]=> string(5) "19354" [4]=> string(5) "19275" [5]=> string(5) "19266" }
object(stdClass)#149 (25) { ["id"]=> string(5) "19363" ["children"]=> int(8) ["name"]=> string(24) "Comforta 15300700 N.v.t." ["keyname"]=> string(23) "comforta-15300700-n-v-t" ["brand"]=> string(8) "COMFORTA" ["label"]=> string(0) "" ["label_color"]=> string(0) "" ["url"]=> string(0) "" ["path"]=> string(67) "./producten/onderhoud/waterproof/19363/comforta-15300700-n-v-t.html" ["img"]=> array(4) { ["small"]=> string(65) "./upload/products/small/4528/comforta-comforta-15300700-n-v-t.jpg" ["medium"]=> string(66) "./upload/products/medium/4528/comforta-comforta-15300700-n-v-t.jpg" ["large"]=> string(65) "./upload/products/large/4528/comforta-comforta-15300700-n-v-t.jpg" ["extra_large"]=> string(71) "./upload/products/extra_large/4528/comforta-comforta-15300700-n-v-t.jpg" } ["photoid"]=> string(4) "4528" ["price"]=> string(5) "14.95" ["price_alt"]=> int(0) ["price_advise"]=> string(4) "0.00" ["price_from"]=> string(0) "" ["unit"]=> string(8) "per paar" ["unit_suffix"]=> string(0) "" ["unit_display"]=> string(1) "0" ["orderable"]=> string(1) "1" ["status"]=> string(11) "Op Voorraad" ["status_url"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["show_price"]=> string(1) "1" ["icons"]=> array(0) { } ["instock"]=> string(4) "0.00" }
array(6) { [0]=> string(5) "67671" [1]=> string(5) "19363" [2]=> string(5) "19372" [3]=> string(5) "19354" [4]=> string(5) "19275" [5]=> string(5) "19266" }
object(stdClass)#194 (25) { ["id"]=> string(5) "19372" ["children"]=> int(8) ["name"]=> string(24) "Collonil 14300100 N.v.t." ["keyname"]=> string(23) "collonil-14300100-n-v-t" ["brand"]=> string(8) "COLLONIL" ["label"]=> string(0) "" ["label_color"]=> string(0) "" ["url"]=> string(0) "" ["path"]=> string(56) "./producten/onderhoud/19372/collonil-14300100-n-v-t.html" ["img"]=> array(4) { ["small"]=> string(65) "./upload/products/small/4529/collonil-collonil-14300100-n-v-t.jpg" ["medium"]=> string(66) "./upload/products/medium/4529/collonil-collonil-14300100-n-v-t.jpg" ["large"]=> string(65) "./upload/products/large/4529/collonil-collonil-14300100-n-v-t.jpg" ["extra_large"]=> string(71) "./upload/products/extra_large/4529/collonil-collonil-14300100-n-v-t.jpg" } ["photoid"]=> string(4) "4529" ["price"]=> string(5) "12.00" ["price_alt"]=> int(0) ["price_advise"]=> string(4) "0.00" ["price_from"]=> string(0) "" ["unit"]=> string(8) "per paar" ["unit_suffix"]=> string(0) "" ["unit_display"]=> string(1) "0" ["orderable"]=> string(1) "1" ["status"]=> string(11) "Op Voorraad" ["status_url"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["show_price"]=> string(1) "1" ["icons"]=> array(0) { } ["instock"]=> string(4) "0.00" }
array(6) { [0]=> string(5) "67671" [1]=> string(5) "19363" [2]=> string(5) "19372" [3]=> string(5) "19354" [4]=> string(5) "19275" [5]=> string(5) "19266" }
object(stdClass)#199 (25) { ["id"]=> string(5) "19354" ["children"]=> int(8) ["name"]=> string(24) "Collonil 15300500 N.v.t." ["keyname"]=> string(23) "collonil-15300500-n-v-t" ["brand"]=> string(8) "COLLONIL" ["label"]=> string(0) "" ["label_color"]=> string(0) "" ["url"]=> string(0) "" ["path"]=> string(67) "./producten/onderhoud/waterproof/19354/collonil-15300500-n-v-t.html" ["img"]=> array(4) { ["small"]=> string(65) "./upload/products/small/4527/collonil-collonil-15300500-n-v-t.jpg" ["medium"]=> string(66) "./upload/products/medium/4527/collonil-collonil-15300500-n-v-t.jpg" ["large"]=> string(65) "./upload/products/large/4527/collonil-collonil-15300500-n-v-t.jpg" ["extra_large"]=> string(71) "./upload/products/extra_large/4527/collonil-collonil-15300500-n-v-t.jpg" } ["photoid"]=> string(4) "4527" ["price"]=> string(5) "15.99" ["price_alt"]=> int(0) ["price_advise"]=> string(4) "0.00" ["price_from"]=> string(0) "" ["unit"]=> string(8) "per paar" ["unit_suffix"]=> string(0) "" ["unit_display"]=> string(1) "0" ["orderable"]=> string(1) "1" ["status"]=> string(11) "Op Voorraad" ["status_url"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["show_price"]=> string(1) "1" ["icons"]=> array(0) { } ["instock"]=> string(4) "0.00" }
array(6) { [0]=> string(5) "67671" [1]=> string(5) "19363" [2]=> string(5) "19372" [3]=> string(5) "19354" [4]=> string(5) "19275" [5]=> string(5) "19266" }
object(stdClass)#193 (25) { ["id"]=> string(5) "19275" ["children"]=> int(8) ["name"]=> string(38) "Piggy Proof Borstel Piggy Proof N.v.t." ["keyname"]=> string(37) "piggy-proof-borstel-piggy-proof-n-v-t" ["brand"]=> string(11) "PIGGY PROOF" ["label"]=> string(0) "" ["label_color"]=> string(0) "" ["url"]=> string(0) "" ["path"]=> string(84) "./producten/onderhoud/schoenborstel/19275/piggy-proof-borstel-piggy-proof-n-v-t.html" ["img"]=> array(4) { ["small"]=> string(82) "./upload/products/small/4517/piggy-proof-piggy-proof-borstel-piggy-proof-n-v-t.jpg" ["medium"]=> string(83) "./upload/products/medium/4517/piggy-proof-piggy-proof-borstel-piggy-proof-n-v-t.jpg" ["large"]=> string(82) "./upload/products/large/4517/piggy-proof-piggy-proof-borstel-piggy-proof-n-v-t.jpg" ["extra_large"]=> string(88) "./upload/products/extra_large/4517/piggy-proof-piggy-proof-borstel-piggy-proof-n-v-t.jpg" } ["photoid"]=> string(4) "4517" ["price"]=> string(4) "4.00" ["price_alt"]=> int(0) ["price_advise"]=> string(4) "0.00" ["price_from"]=> string(0) "" ["unit"]=> string(8) "per paar" ["unit_suffix"]=> string(0) "" ["unit_display"]=> string(1) "0" ["orderable"]=> string(1) "1" ["status"]=> string(11) "Op Voorraad" ["status_url"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["show_price"]=> string(1) "1" ["icons"]=> array(0) { } ["instock"]=> string(4) "0.00" }
array(6) { [0]=> string(5) "67671" [1]=> string(5) "19363" [2]=> string(5) "19372" [3]=> string(5) "19354" [4]=> string(5) "19275" [5]=> string(5) "19266" }
object(stdClass)#149 (25) { ["id"]=> string(5) "19266" ["children"]=> int(8) ["name"]=> string(21) "Piggy Proof 02 N.v.t." ["keyname"]=> string(20) "piggy-proof-02-n-v-t" ["brand"]=> string(11) "PIGGY PROOF" ["label"]=> string(0) "" ["label_color"]=> string(0) "" ["url"]=> string(0) "" ["path"]=> string(64) "./producten/onderhoud/waterproof/19266/piggy-proof-02-n-v-t.html" ["img"]=> array(4) { ["small"]=> string(65) "./upload/products/small/4516/piggy-proof-piggy-proof-02-n-v-t.jpg" ["medium"]=> string(66) "./upload/products/medium/4516/piggy-proof-piggy-proof-02-n-v-t.jpg" ["large"]=> string(65) "./upload/products/large/4516/piggy-proof-piggy-proof-02-n-v-t.jpg" ["extra_large"]=> string(71) "./upload/products/extra_large/4516/piggy-proof-piggy-proof-02-n-v-t.jpg" } ["photoid"]=> string(4) "4516" ["price"]=> string(5) "17.95" ["price_alt"]=> int(0) ["price_advise"]=> string(4) "0.00" ["price_from"]=> string(0) "" ["unit"]=> string(8) "per paar" ["unit_suffix"]=> string(0) "" ["unit_display"]=> string(1) "0" ["orderable"]=> string(1) "1" ["status"]=> string(11) "Op Voorraad" ["status_url"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["show_price"]=> string(1) "1" ["icons"]=> array(0) { } ["instock"]=> string(4) "0.00" }