SELECT * FROM ShopStoresSEO WHERE storeid = 1 AND page = 'new' AND categoryid = 0 AND manufacturerid = 12 LIMIT 1
Filter

Nieuwe producten Footnotes

1 - 2 van 2
Sorteer op:
FOOTNOTES KIRSTEN 44CM - 95.018.8
object(stdClass)#167 (46) { ["id"]=> string(3) "195" ["children"]=> string(1) "0" ["photoid"]=> string(3) "276" ["serial_number"]=> string(0) "" ["article_number"]=> string(8) "95.018.8" ["price"]=> string(6) "239.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(33) "FOOTNOTES KIRSTEN 44CM - 95.018.8" ["keyname"]=> string(12) "kirsten-44cm" ["label"]=> string(0) "" ["path"]=> string(14) "/dames/laarzen" ["manufacturer_id"]=> string(2) "12" ["manufacturer_name"]=> string(9) "Footnotes" ["manufacturer_keyname"]=> string(9) "footnotes" ["discount_type"]=> NULL ["discount_value"]=> NULL ["discount_color"]=> NULL ["discount_label"]=> NULL ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> NULL ["value"]=> NULL ["price_lowest"]=> string(6) "239.95" }
FootnotesFOOTNOTES KIRSTEN 44CM - 95.018.8
€ 239,95
FOOTNOTES MARA - 15.012-0011-1200 Wij
object(stdClass)#162 (46) { ["id"]=> string(3) "193" ["children"]=> string(1) "0" ["photoid"]=> string(3) "272" ["serial_number"]=> string(0) "" ["article_number"]=> string(20) "15.012-0011-1200 Wij" ["price"]=> string(6) "219.95" ["price_single"]=> string(4) "0.00" ["price_purchase"]=> string(4) "0.00" ["price_dealer"]=> string(4) "0.00" ["price_advise"]=> string(4) "0.00" ["price_display"]=> string(6) "public" ["tax"]=> string(2) "21" ["url"]=> string(0) "" ["unit_content"]=> string(4) "1.00" ["unit_orderamount"]=> string(4) "1.00" ["name"]=> string(37) "FOOTNOTES MARA - 15.012-0011-1200 Wij" ["keyname"]=> string(4) "mara" ["label"]=> string(0) "" ["path"]=> string(14) "/dames/laarzen" ["manufacturer_id"]=> string(2) "12" ["manufacturer_name"]=> string(9) "Footnotes" ["manufacturer_keyname"]=> string(9) "footnotes" ["discount_type"]=> NULL ["discount_value"]=> NULL ["discount_color"]=> NULL ["discount_label"]=> NULL ["icons"]=> NULL ["unit_single"]=> NULL ["unit_multi"]=> NULL ["unit_label"]=> NULL ["unit_suffix"]=> NULL ["unit_display"]=> NULL ["promo_name"]=> NULL ["promo_keyname"]=> NULL ["promo_label"]=> NULL ["promo_color"]=> NULL ["catalog"]=> string(1) "1" ["orderable"]=> string(1) "1" ["show_price"]=> string(1) "1" ["status"]=> string(11) "Op voorraad" ["status_label"]=> string(0) "" ["button"]=> string(21) "Plaats in winkelwagen" ["status_url"]=> string(0) "" ["type"]=> NULL ["value"]=> NULL ["price_lowest"]=> string(6) "219.95" }
FootnotesFOOTNOTES MARA - 15.012-0011-1200 Wij
€ 219,95