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

Aanbiedingen

1 - 11 van 11
Sorteer op:
array(11) { [0]=> string(5) "29685" [1]=> string(5) "26349" [2]=> string(5) "26335" [3]=> string(5) "26321" [4]=> string(5) "26307" [5]=> string(5) "26279" [6]=> string(5) "17497" [7]=> string(4) "7436" [8]=> string(4) "7408" [9]=> string(4) "7268" [10]=> string(4) "7212" }
object(stdClass)#171 (25) { ["id"]=> string(5) "29685" ["children"]=> int(13) ["name"]=> string(26) "Braqeez 0011722-0520 Blauw" ["keyname"]=> string(26) "braqeez-0011722-0520-blauw" ["brand"]=> string(7) "Braqeez" ["label"]=> string(5) "ACTIE" ["label_color"]=> string(6) "rood " ["url"]=> string(0) "" ["path"]=> string(65) "./producten/jongens/laarzen/29685/braqeez-0011722-0520-blauw.html" ["img"]=> array(4) { ["small"]=> string(67) "./upload/products/small/7914/braqeez-braqeez-0011722-0520-blauw.jpg" ["medium"]=> string(68) "./upload/products/medium/7914/braqeez-braqeez-0011722-0520-blauw.jpg" ["large"]=> string(67) "./upload/products/large/7914/braqeez-braqeez-0011722-0520-blauw.jpg" ["extra_large"]=> string(73) "./upload/products/extra_large/7914/braqeez-braqeez-0011722-0520-blauw.jpg" } ["photoid"]=> string(4) "7914" ["price"]=> string(5) "41.97" ["price_alt"]=> string(5) "69.95" ["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" }
ACTIE
Braqeez 0011722-0520 Blauw
BraqeezBraqeez 0011722-0520 Blauw
€ 69,95€ 41,97
array(11) { [0]=> string(5) "29685" [1]=> string(5) "26349" [2]=> string(5) "26335" [3]=> string(5) "26321" [4]=> string(5) "26307" [5]=> string(5) "26279" [6]=> string(5) "17497" [7]=> string(4) "7436" [8]=> string(4) "7408" [9]=> string(4) "7268" [10]=> string(4) "7212" }
object(stdClass)#88 (25) { ["id"]=> string(5) "26349" ["children"]=> int(13) ["name"]=> string(30) "Braqeez 417856 529 Blauw/combi" ["keyname"]=> string(30) "braqeez-417856-529-blauw-combi" ["brand"]=> string(7) "Braqeez" ["label"]=> string(5) "ACTIE" ["label_color"]=> string(6) "rood " ["url"]=> string(0) "" ["path"]=> string(75) "./producten/jongens/veterschoenen/26349/braqeez-417856-529-blauw-combi.html" ["img"]=> array(4) { ["small"]=> string(71) "./upload/products/small/7023/braqeez-braqeez-417856-529-blauw-combi.jpg" ["medium"]=> string(72) "./upload/products/medium/7023/braqeez-braqeez-417856-529-blauw-combi.jpg" ["large"]=> string(71) "./upload/products/large/7023/braqeez-braqeez-417856-529-blauw-combi.jpg" ["extra_large"]=> string(77) "./upload/products/extra_large/7023/braqeez-braqeez-417856-529-blauw-combi.jpg" } ["photoid"]=> string(4) "7023" ["price"]=> string(5) "47.97" ["price_alt"]=> string(5) "79.95" ["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(11) { [0]=> string(5) "29685" [1]=> string(5) "26349" [2]=> string(5) "26335" [3]=> string(5) "26321" [4]=> string(5) "26307" [5]=> string(5) "26279" [6]=> string(5) "17497" [7]=> string(4) "7436" [8]=> string(4) "7408" [9]=> string(4) "7268" [10]=> string(4) "7212" }
object(stdClass)#172 (25) { ["id"]=> string(5) "26335" ["children"]=> int(13) ["name"]=> string(24) "Braqeez 417855 520 Blauw" ["keyname"]=> string(24) "braqeez-417855-520-blauw" ["brand"]=> string(7) "Braqeez" ["label"]=> string(5) "ACTIE" ["label_color"]=> string(6) "rood " ["url"]=> string(0) "" ["path"]=> string(67) "./producten/jongens/klittenband/26335/braqeez-417855-520-blauw.html" ["img"]=> array(4) { ["small"]=> string(65) "./upload/products/small/7019/braqeez-braqeez-417855-520-blauw.jpg" ["medium"]=> string(66) "./upload/products/medium/7019/braqeez-braqeez-417855-520-blauw.jpg" ["large"]=> string(65) "./upload/products/large/7019/braqeez-braqeez-417855-520-blauw.jpg" ["extra_large"]=> string(71) "./upload/products/extra_large/7019/braqeez-braqeez-417855-520-blauw.jpg" } ["photoid"]=> string(4) "7019" ["price"]=> string(5) "47.97" ["price_alt"]=> string(5) "79.95" ["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" }
ACTIE
Braqeez 417855 520 Blauw
BraqeezBraqeez 417855 520 Blauw
€ 79,95€ 47,97
array(11) { [0]=> string(5) "29685" [1]=> string(5) "26349" [2]=> string(5) "26335" [3]=> string(5) "26321" [4]=> string(5) "26307" [5]=> string(5) "26279" [6]=> string(5) "17497" [7]=> string(4) "7436" [8]=> string(4) "7408" [9]=> string(4) "7268" [10]=> string(4) "7212" }
object(stdClass)#177 (25) { ["id"]=> string(5) "26321" ["children"]=> int(13) ["name"]=> string(24) "Braqeez 417533 529 Blauw" ["keyname"]=> string(24) "braqeez-417533-529-blauw" ["brand"]=> string(7) "Braqeez" ["label"]=> string(5) "ACTIE" ["label_color"]=> string(6) "rood " ["url"]=> string(0) "" ["path"]=> string(69) "./producten/jongens/veterschoenen/26321/braqeez-417533-529-blauw.html" ["img"]=> array(4) { ["small"]=> string(65) "./upload/products/small/7015/braqeez-braqeez-417533-529-blauw.jpg" ["medium"]=> string(66) "./upload/products/medium/7015/braqeez-braqeez-417533-529-blauw.jpg" ["large"]=> string(65) "./upload/products/large/7015/braqeez-braqeez-417533-529-blauw.jpg" ["extra_large"]=> string(71) "./upload/products/extra_large/7015/braqeez-braqeez-417533-529-blauw.jpg" } ["photoid"]=> string(4) "7015" ["price"]=> string(5) "41.97" ["price_alt"]=> string(5) "69.95" ["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" }
ACTIE
Braqeez 417533 529 Blauw
BraqeezBraqeez 417533 529 Blauw
€ 69,95€ 41,97
array(11) { [0]=> string(5) "29685" [1]=> string(5) "26349" [2]=> string(5) "26335" [3]=> string(5) "26321" [4]=> string(5) "26307" [5]=> string(5) "26279" [6]=> string(5) "17497" [7]=> string(4) "7436" [8]=> string(4) "7408" [9]=> string(4) "7268" [10]=> string(4) "7212" }
object(stdClass)#171 (25) { ["id"]=> string(5) "26307" ["children"]=> int(13) ["name"]=> string(25) "Braqeez 417533 513 Cognac" ["keyname"]=> string(25) "braqeez-417533-513-cognac" ["brand"]=> string(7) "Braqeez" ["label"]=> string(5) "ACTIE" ["label_color"]=> string(6) "rood " ["url"]=> string(0) "" ["path"]=> string(70) "./producten/jongens/veterschoenen/26307/braqeez-417533-513-cognac.html" ["img"]=> array(4) { ["small"]=> string(66) "./upload/products/small/7011/braqeez-braqeez-417533-513-cognac.jpg" ["medium"]=> string(67) "./upload/products/medium/7011/braqeez-braqeez-417533-513-cognac.jpg" ["large"]=> string(66) "./upload/products/large/7011/braqeez-braqeez-417533-513-cognac.jpg" ["extra_large"]=> string(72) "./upload/products/extra_large/7011/braqeez-braqeez-417533-513-cognac.jpg" } ["photoid"]=> string(4) "7011" ["price"]=> string(5) "41.97" ["price_alt"]=> string(5) "69.95" ["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" }
ACTIE
Braqeez 417533 513 Cognac
BraqeezBraqeez 417533 513 Cognac
€ 69,95€ 41,97
array(11) { [0]=> string(5) "29685" [1]=> string(5) "26349" [2]=> string(5) "26335" [3]=> string(5) "26321" [4]=> string(5) "26307" [5]=> string(5) "26279" [6]=> string(5) "17497" [7]=> string(4) "7436" [8]=> string(4) "7408" [9]=> string(4) "7268" [10]=> string(4) "7212" }
object(stdClass)#88 (25) { ["id"]=> string(5) "26279" ["children"]=> int(13) ["name"]=> string(24) "Braqeez 417530 584 Grijs" ["keyname"]=> string(24) "braqeez-417530-584-grijs" ["brand"]=> string(7) "Braqeez" ["label"]=> string(5) "ACTIE" ["label_color"]=> string(6) "rood " ["url"]=> string(0) "" ["path"]=> string(69) "./producten/jongens/veterschoenen/26279/braqeez-417530-584-grijs.html" ["img"]=> array(4) { ["small"]=> string(65) "./upload/products/small/7003/braqeez-braqeez-417530-584-grijs.jpg" ["medium"]=> string(66) "./upload/products/medium/7003/braqeez-braqeez-417530-584-grijs.jpg" ["large"]=> string(65) "./upload/products/large/7003/braqeez-braqeez-417530-584-grijs.jpg" ["extra_large"]=> string(71) "./upload/products/extra_large/7003/braqeez-braqeez-417530-584-grijs.jpg" } ["photoid"]=> string(4) "7003" ["price"]=> string(5) "41.97" ["price_alt"]=> string(5) "69.95" ["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" }
ACTIE
Braqeez 417530 584 Grijs
BraqeezBraqeez 417530 584 Grijs
€ 69,95€ 41,97
array(11) { [0]=> string(5) "29685" [1]=> string(5) "26349" [2]=> string(5) "26335" [3]=> string(5) "26321" [4]=> string(5) "26307" [5]=> string(5) "26279" [6]=> string(5) "17497" [7]=> string(4) "7436" [8]=> string(4) "7408" [9]=> string(4) "7268" [10]=> string(4) "7212" }
object(stdClass)#172 (25) { ["id"]=> string(5) "17497" ["children"]=> int(13) ["name"]=> string(28) "Braqeez Bqz 416931 589 Zwart" ["keyname"]=> string(28) "braqeez-bqz-416931-589-zwart" ["brand"]=> string(11) "Braqeez BQZ" ["label"]=> string(5) "ACTIE" ["label_color"]=> string(6) "rood " ["url"]=> string(0) "" ["path"]=> string(73) "./producten/jongens/veterschoenen/17497/braqeez-bqz-416931-589-zwart.html" ["img"]=> array(4) { ["small"]=> string(73) "./upload/products/small/3680/braqeez-bqz-braqeez-bqz-416931-589-zwart.jpg" ["medium"]=> string(74) "./upload/products/medium/3680/braqeez-bqz-braqeez-bqz-416931-589-zwart.jpg" ["large"]=> string(73) "./upload/products/large/3680/braqeez-bqz-braqeez-bqz-416931-589-zwart.jpg" ["extra_large"]=> string(79) "./upload/products/extra_large/3680/braqeez-bqz-braqeez-bqz-416931-589-zwart.jpg" } ["photoid"]=> string(4) "3680" ["price"]=> string(5) "59.97" ["price_alt"]=> string(5) "99.95" ["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(11) { [0]=> string(5) "29685" [1]=> string(5) "26349" [2]=> string(5) "26335" [3]=> string(5) "26321" [4]=> string(5) "26307" [5]=> string(5) "26279" [6]=> string(5) "17497" [7]=> string(4) "7436" [8]=> string(4) "7408" [9]=> string(4) "7268" [10]=> string(4) "7212" }
object(stdClass)#177 (25) { ["id"]=> string(4) "7436" ["children"]=> int(13) ["name"]=> string(28) "Braqeez Bqz 416358 508 Taupe" ["keyname"]=> string(28) "braqeez-bqz-416358-508-taupe" ["brand"]=> string(11) "Braqeez BQZ" ["label"]=> string(5) "ACTIE" ["label_color"]=> string(6) "rood " ["url"]=> string(0) "" ["path"]=> string(70) "./producten/jongens/klittenband/7436/braqeez-bqz-416358-508-taupe.html" ["img"]=> array(4) { ["small"]=> string(72) "./upload/products/small/975/braqeez-bqz-braqeez-bqz-416358-508-taupe.jpg" ["medium"]=> string(73) "./upload/products/medium/975/braqeez-bqz-braqeez-bqz-416358-508-taupe.jpg" ["large"]=> string(72) "./upload/products/large/975/braqeez-bqz-braqeez-bqz-416358-508-taupe.jpg" ["extra_large"]=> string(78) "./upload/products/extra_large/975/braqeez-bqz-braqeez-bqz-416358-508-taupe.jpg" } ["photoid"]=> string(3) "975" ["price"]=> string(5) "50.97" ["price_alt"]=> string(5) "84.95" ["price_advise"]=> string(4) "0.00" ["price_from"]=> float(84.95) ["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(11) { [0]=> string(5) "29685" [1]=> string(5) "26349" [2]=> string(5) "26335" [3]=> string(5) "26321" [4]=> string(5) "26307" [5]=> string(5) "26279" [6]=> string(5) "17497" [7]=> string(4) "7436" [8]=> string(4) "7408" [9]=> string(4) "7268" [10]=> string(4) "7212" }
object(stdClass)#171 (25) { ["id"]=> string(4) "7408" ["children"]=> int(13) ["name"]=> string(34) "Braqeez Bqz 416441 529 Blauw/combi" ["keyname"]=> string(34) "braqeez-bqz-416441-529-blauw-combi" ["brand"]=> string(11) "Braqeez BQZ" ["label"]=> string(5) "ACTIE" ["label_color"]=> string(6) "rood " ["url"]=> string(0) "" ["path"]=> string(76) "./producten/jongens/klittenband/7408/braqeez-bqz-416441-529-blauw-combi.html" ["img"]=> array(4) { ["small"]=> string(78) "./upload/products/small/967/braqeez-bqz-braqeez-bqz-416441-529-blauw-combi.jpg" ["medium"]=> string(79) "./upload/products/medium/967/braqeez-bqz-braqeez-bqz-416441-529-blauw-combi.jpg" ["large"]=> string(78) "./upload/products/large/967/braqeez-bqz-braqeez-bqz-416441-529-blauw-combi.jpg" ["extra_large"]=> string(84) "./upload/products/extra_large/967/braqeez-bqz-braqeez-bqz-416441-529-blauw-combi.jpg" } ["photoid"]=> string(3) "967" ["price"]=> string(5) "53.97" ["price_alt"]=> string(5) "89.95" ["price_advise"]=> string(4) "0.00" ["price_from"]=> float(89.95) ["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(11) { [0]=> string(5) "29685" [1]=> string(5) "26349" [2]=> string(5) "26335" [3]=> string(5) "26321" [4]=> string(5) "26307" [5]=> string(5) "26279" [6]=> string(5) "17497" [7]=> string(4) "7436" [8]=> string(4) "7408" [9]=> string(4) "7268" [10]=> string(4) "7212" }
object(stdClass)#88 (25) { ["id"]=> string(4) "7268" ["children"]=> int(13) ["name"]=> string(34) "Braqeez Bqz 416304 508 Beige Combi" ["keyname"]=> string(34) "braqeez-bqz-416304-508-beige-combi" ["brand"]=> string(11) "Braqeez BQZ" ["label"]=> string(5) "ACTIE" ["label_color"]=> string(6) "rood " ["url"]=> string(0) "" ["path"]=> string(78) "./producten/jongens/veterschoenen/7268/braqeez-bqz-416304-508-beige-combi.html" ["img"]=> array(4) { ["small"]=> string(78) "./upload/products/small/928/braqeez-bqz-braqeez-bqz-416304-508-beige-combi.jpg" ["medium"]=> string(79) "./upload/products/medium/928/braqeez-bqz-braqeez-bqz-416304-508-beige-combi.jpg" ["large"]=> string(78) "./upload/products/large/928/braqeez-bqz-braqeez-bqz-416304-508-beige-combi.jpg" ["extra_large"]=> string(84) "./upload/products/extra_large/928/braqeez-bqz-braqeez-bqz-416304-508-beige-combi.jpg" } ["photoid"]=> string(3) "928" ["price"]=> string(5) "47.97" ["price_alt"]=> string(5) "79.95" ["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(11) { [0]=> string(5) "29685" [1]=> string(5) "26349" [2]=> string(5) "26335" [3]=> string(5) "26321" [4]=> string(5) "26307" [5]=> string(5) "26279" [6]=> string(5) "17497" [7]=> string(4) "7436" [8]=> string(4) "7408" [9]=> string(4) "7268" [10]=> string(4) "7212" }
object(stdClass)#172 (25) { ["id"]=> string(4) "7212" ["children"]=> int(13) ["name"]=> string(34) "Braqeez Bqz 416304 523 Blauw/combi" ["keyname"]=> string(34) "braqeez-bqz-416304-523-blauw-combi" ["brand"]=> string(11) "Braqeez BQZ" ["label"]=> string(5) "ACTIE" ["label_color"]=> string(6) "rood " ["url"]=> string(0) "" ["path"]=> string(78) "./producten/jongens/veterschoenen/7212/braqeez-bqz-416304-523-blauw-combi.html" ["img"]=> array(4) { ["small"]=> string(78) "./upload/products/small/912/braqeez-bqz-braqeez-bqz-416304-523-blauw-combi.jpg" ["medium"]=> string(79) "./upload/products/medium/912/braqeez-bqz-braqeez-bqz-416304-523-blauw-combi.jpg" ["large"]=> string(78) "./upload/products/large/912/braqeez-bqz-braqeez-bqz-416304-523-blauw-combi.jpg" ["extra_large"]=> string(84) "./upload/products/extra_large/912/braqeez-bqz-braqeez-bqz-416304-523-blauw-combi.jpg" } ["photoid"]=> string(3) "912" ["price"]=> string(5) "47.97" ["price_alt"]=> string(5) "79.95" ["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" }