string(1349) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '2' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 4 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (3810, 3859, 3910, 3966, 4127, 4498, 4535, 3828, 23799, 23841)) ORDER BY FIELD(e.entity_id,3810,3859,3910,3966,4127,4498,4535,3828,23799,23841) " string(1349) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '2' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 4 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (3810, 3859, 3910, 3966, 4127, 4498, 4535, 3828, 23799, 23841)) ORDER BY FIELD(e.entity_id,3810,3859,3910,3966,4127,4498,4535,3828,23799,23841) " Consegna Rapida di Gioielli - Gioiello in Consegna Espressa Dhl | Gemperles
Offerta di Giugno: -5% su Fedi Nuziali Coppia con il codice DUO
  • Confronta Prodotti
Cerca
Toggle Nav
  • Aiuto
Cambia lingua
it
Cambia valuta
EUR
Carrello
Empty Cart
Menu
Toggle Nav
Aiuto
  • Aiuto
    • Il mio Account
    Crea Account

    Create a Gemperles account to manage your contact details, track the status of your orders and save time on your next purchases.

    Crea Account

    Consegna Rapida

    Ora acquista per
    1. Tipo
      Collana
    2. Gemme
      Perle Akoya
    3. Gemme
      Miste
    4. Fili di perle
      1 filo
    Cancella tutto
    Opzioni di acquisto
    In magazzino
    1. 7 giorni 8 elementi
    2. 15 giorni 3 elementi
    3. 23 giorni 1 elemento
    Tipo
    1. Collana 10 elementi
    2. Braccialetto 2 elementi
    3. Parure 4 elementi
    Gemme
    1. Miste 1 elemento
    2. Perle acqua dolce 18 elementi
    3. Perle Akoya 9 elementi
    4. Perle di Tahiti 16 elementi
    5. Perle dei Mari del Sud 6 elementi
    Prezzo
    Qualità 123
    1. GEMMA 4 elementi
    2. AAA 8 elementi
    Fili di perle
    1. 1 filo 10 elementi
    2. 2 fili 3 elementi
    3. 3 fili 1 elemento
    Colore
    1. Bianco 8 elementi
    2. Nero 1 elemento
    3. Multicolore 1 elemento
    Diametro (mm)
    1. 6/6.5 1 elemento
    2. 6.5/7 2 elementi
    3. 7/7.5 1 elemento
    4. 7.5/8 1 elemento
    5. 8/8.5 1 elemento
    6. 8.5/9 2 elementi
    7. 9/9.5 1 elemento
    8. 10/13 1 elemento
    9. 11/13 1 elemento
    Mostra meno
    string(1349) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '2' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 4 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (3810, 3859, 3910, 3966, 4127, 4498, 4535, 3828, 23799, 23841)) ORDER BY FIELD(e.entity_id,3810,3859,3910,3966,4127,4498,4535,3828,23799,23841) " string(1349) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '2' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 4 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (3810, 3859, 3910, 3966, 4127, 4498, 4535, 3828, 23799, 23841)) ORDER BY FIELD(e.entity_id,3810,3859,3910,3966,4127,4498,4535,3828,23799,23841) "
    string(1349) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '2' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 4 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (3810, 3859, 3910, 3966, 4127, 4498, 4535, 3828, 23799, 23841)) ORDER BY FIELD(e.entity_id,3810,3859,3910,3966,4127,4498,4535,3828,23799,23841) " string(1349) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '2' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 4 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (3810, 3859, 3910, 3966, 4127, 4498, 4535, 3828, 23799, 23841)) ORDER BY FIELD(e.entity_id,3810,3859,3910,3966,4127,4498,4535,3828,23799,23841) "
    Filtro

    10 elementi

    Imposta la direzione decrescente
    1. Collana Chizuka - Perle Akoya Bianche Giappone - 7.5/8mm, AAA Collana Chizuka - Perle Akoya Bianche Giappone - 7.5/8mm, AAA

      Chizuka Collana Chizuka - Perle Akoya Bianche Giappone - 7.5/8mm, AAA

      Valutazione:
      100%
      4  Recensioni
      2.150 €
      Aggiungi alla lista desideri
    2. Collana Akira - Perle Bianche Akoya Giapponesi 6.5/7mm Collana Akira - Perle Bianche Akoya Giapponesi 6.5/7mm

      Akira

      Collana di perle Akoya bianche. Diametro 6.5/7mm. Qualità AAA

      Valutazione:
      100%
      5  Recensioni
      1.150 €
      Aggiungi alla lista desideri
    3. Collana Montjo - Perle Miste di Tahiti e Mari del Sud Collana Montjo - Perle Miste di Tahiti e Mari del Sud

      Montjo

      Collana Montjo - Perle Miste di Tahiti e Mari del Sud

      14.500 €
      Aggiungi alla lista desideri
    4. Collana Shimotsuke - Grosse Perle Bianche Akoya - 8.5/9mm, GEMMA / HANADAMA Collana Shimotsuke - Grosse Perle Bianche Akoya - 8.5/9mm, GEMMA / HANADAMA

      Shimotsuke Collana Shimotsuke - Grosse Perle Bianche Akoya - 8.5/9mm, GEMMA / HANADAMA

      Valutazione:
      100%
      2  Recensioni
      4.650 €
      Aggiungi alla lista desideri
    5. Collana Aguri - Grosse Perle Bianche Akoya - 8/8.5mm, AAA / HANADAMA Collana Aguri - Grosse Perle Bianche Akoya - 8/8.5mm, AAA / HANADAMA

      Aguri Collana Aguri - Grosse Perle Bianche Akoya - 8/8.5mm, AAA / HANADAMA

      Valutazione:
      100%
      4  Recensioni
      2.700 €
      Aggiungi alla lista desideri
    6. Collana Ninkasi Kao - Grosse Perle Bianche Akoya - 9/9.5mm, AAA / HANADAMA Collana Ninkasi Kao - Grosse Perle Bianche Akoya - 9/9.5mm, AAA / HANADAMA

      Ninkasi Kao

      Collana di perle Akoya bianche. Diametro 9/9.5mm. Qualità AAA

      Valutazione:
      100%
      2  Recensioni
      5.885 €
      Aggiungi alla lista desideri
    7. Collana di Perle Akoya Amiko - Giapponesi Nere, Verdi - 6/6.5mm, AAA | Gemperles Collana di Perle Akoya Amiko - Giapponesi Nere, Verdi - 6/6.5mm, AAA | Gemperles

      Amiko Collana di Perle Akoya Amiko - Giapponesi Nere, Verdi - 6/6.5mm, AAA | Gemperles

      550 €
      Aggiungi alla lista desideri
    8. Collana di perle Akoya bianche - 8.5/9mm - AA+ Collana di perle Akoya bianche - 8.5/9mm - AA+

      Wakasa

      Collana di perle Akoya bianche. Diametro 8.5/9mm. Qualità AA+

      Valutazione:
      100%
      2  Recensioni
      3.860 €
      Aggiungi alla lista desideri
    9. Collana di perle Akoya Giappone bianche - 6.5/7mm, GEMMA / HANADAMA Collana di perle Akoya Giappone bianche - 6.5/7mm, GEMMA / HANADAMA

      Dewa Collana di perle Akoya Giappone bianche - 6.5/7mm, GEMMA / HANADAMA

      Valutazione:
      100%
      2  Recensioni
      Prezzo speciale 500 € Prezzo normale 1.350 €
      Aggiungi alla lista desideri
    10. Collana EMA Collana Di Perle Ema - Akoya Giappone Bianche - 7/7.5mm, GEMMA / HANADAMA

      Ema

      Collana di perle Akoya bianche. Diametro 7/7.5mm. Qualità GEMMA

      1.800 €
      Aggiungi alla lista desideri
    per pagina