Lenses

Lenses
Shop By
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`.`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 = '1' LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_1` ON mst_sorting_index_1.product_id = e.entity_id AND mst_sorting_index_1.store_id = 1 LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_0` ON mst_sorting_index_0.product_id = e.entity_id AND mst_sorting_index_0.store_id = 0 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id LEFT JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE (e.entity_id IN (614468, 614466, 576507, 554720, 554718, 537245, 537240, 535942, 535939, 535702, 535701, 15647, 15648, 15649, 14551, 14683, 14684, 14702, 14703, 12829, 10874, 7334, 8010, 8901, 8902, 5305, 2951, 2959, 2965, 9146)) ORDER BY IFNULL(mst_sorting_index_1.factor_2_score, IFNULL(mst_sorting_index_0.factor_2_score, 0)) * 50 desc, FIELD(e.entity_id,614468,614466,576507,554720,554718,537245,537240,535942,535939,535702,535701,15647,15648,15649,14551,14683,14684,14702,14703,12829,10874,7334,8010,8901,8902,5305,2951,2959,2965,9146)
View as Grid List

Items 1-30 of 92

Page
per page
Set Ascending Direction
  1. 15mm f/1.4 DG DN Diagonal Fisheye Art (L Mount)
    Sigma 15mm f/1.4 DG DN Diagonal Fisheye Art (L Mount) [PREORDER]
    Special Price No Charge To Preorder Expected Retail Price of USD $1,999.00
    SKU: PRE-SIG-00051
    Model: 478969
    Condition: Preorder
    Mount Type: L Mount
  2. 15mm f/1.4 DG DN Diagonal Fisheye Art (Sony E)
    Sigma 15mm f/1.4 DG DN Diagonal Fisheye Art (Sony E) [PREORDER]
    Special Price No Charge To Preorder Expected Retail Price of USD $1,999.00
    SKU: PRE-SIG-00050
    Model: 478965
    Condition: Preorder
    Mount Type: Sony E
  3. 23mm f/1.4 DC DN | C (Fujifilm X)
    Sigma 23mm f/1.4 DC DN | C (Fujifilm X)
    USD $549.00
    SKU: SIG-00158F
    Model: 348975
    Condition: New-In-Box
    Mount Type: Fujifilm X-Mount
  4. 14mm f/1.4 DG DN | Art (L-Mount)
    Sigma 14mm f/1.4 DG DN | Art (L-Mount)
    USD $1,599.00
    Out of stock
    SKU: SIG-00048L
    Model: 451969
    Condition: New-In-Box
    Mount Type: L Mount
  5. 14mm f/1.4 DG DN | Art (Sony E)
    Sigma 14mm f/1.4 DG DN | Art (Sony E)
    USD $1,599.00
    SKU: SIG-00048
    Model: 451965
    Condition: New-In-Box
    Mount Type: Sony E
  6. Summilux-M 50 f/1.4 ASPH. (Silver)
    Leica Summilux-M 50 f/1.4 ASPH. (Silver)
    USD $4,795.00
    Out of stock
    SKU: LEI-11729
    Model: 11729
    Condition: New-In-Box
    Mount Type: Leica M
  7. Summilux-M 50 f/1.4 ASPH. (Black)
    Leica Summilux-M 50 f/1.4 ASPH. (Black)
    USD $4,495.00
    Out of stock
    SKU: LEI-11728
    Model: 11728
    Condition: New-In-Box
    Mount Type: Leica M
  8. 56mm f/1.4 DC DN | C (Nikon Z)
    Sigma 56mm f/1.4 DC DN | C (Nikon Z)
    Special Price USD $449.00 After USD $50.00 Savings
    SKU: SIG-00265N
    Model: 351973
    Condition: New-In-Box
    Mount Type: Nikon Z
  9. 16mm f/1.4 DC DN | C (Nikon Z)
    Sigma 16mm f/1.4 DC DN | C (Nikon Z)
    Special Price USD $449.00 After USD $50.00 Savings
    SKU: SIG-00059N
    Model: 402973
    Condition: New-In-Box
    Mount Type: Nikon Z
  10. 23mm f/1.4 DC DN | C (Sony E)
    Sigma 23mm f/1.4 DC DN | C (Sony E)
    USD $549.00
    SKU: SIG-00158S
    Model: 348965
    Condition: New-In-Box
    Mount Type: Sony E
  11. 23mm f/1.4 DC DN | C (L Mount)
    Sigma 23mm f/1.4 DC DN | C (L Mount)
    USD $549.00
    Out of stock
    SKU: SIG-001579
    Model: 348969
    Condition: New-In-Box
    Mount Type: L Mount
  12. 30mm f/1.4 DC HSM | A (Canon)
    Sigma 30mm f/1.4 DC HSM | A (Canon)
    USD $499.00
    Out of stock
    SKU: SIG-00192
    Model: 301101
    Condition: New-In-Box
    Mount Type: Canon EOS (EF-S)
  13. 30mm f/1.4 DC HSM | A (Nikon)
    Sigma 30mm f/1.4 DC HSM | A (Nikon)
    USD $499.00
    SKU: SIG-00194
    Model: 301306
    Condition: New-In-Box
    Mount Type: Nikon F (DX)
  14. 30mm f/1.4 DC HSM | A (Sony)
    Sigma 30mm f/1.4 DC HSM | A (Sony)
    USD $499.00
    Out of stock
    SKU: SIG-00196
    Model: 301205
    Condition: New-In-Box
  15. FUJINON XF 35mm f/1.4
    Fujifilm FUJINON XF 35mm f/1.4
    USD $599.95
    Out of stock
    SKU: FUJ-31314
    Model: 1352
    Condition: New-In-Box
    Mount Type: Fujifilm X-Mount
  16. Rokinon 35mm f/1.4 (Canon)
    USD $499.00
    Out of stock
    SKU: ROK-03510
    Model: 2584
    Condition: New-In-Box
    Mount Type: Canon EOS (EF)
  17. Rokinon 35mm f/1.4 (Nikon with Automatic Chip)
    USD $549.00
    Out of stock
    SKU: ROK-03520
    Model: 2577
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  18. 85mm f/1.4 Aspherical Portrait Lens (Canon)
    Rokinon 85mm f/1.4 Aspherical Portrait Lens (Canon)
    USD $299.00
    Out of stock
    SKU: ROK-08510
    Model: 2472
    Condition: New-In-Box
    Mount Type: Canon EOS (EF)
  19. 85mm f/1.4 Aspherical Portrait Lens (Nikon)
    Rokinon 85mm f/1.4 Aspherical Portrait Lens (Nikon)
    USD $299.00
    Out of stock
    SKU: ROK-08520
    Model: 2668
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  20. SUMMILUX-M 50mm f/1.4 ASPH (Black)
    Leica SUMMILUX-M 50mm f/1.4 ASPH (Black)
    USD $4,495.00
    Out of stock
    SKU: LEI-30258
    Model: 11891
    Condition: New-In-Box
    Mount Type: Leica M
  21. Leica DG Summilux 25mm f/1.4 ASPH Lens
    Panasonic Leica DG Summilux 25mm f/1.4 ASPH Lens
    USD $599.99
    Out of stock
    SKU: PAN-00327G
    Model: H-X025
    Condition: New-In-Box
    Mount Type: Micro Four-Thirds
  22. Leica SUMMILUX-M 35mm f/1.4 ASPH (Black)
    USD $5,995.00
    Out of stock
    SKU: LEI-30242
    Model: 11663
    Condition: New-In-Box
    Mount Type: Leica M
  23. EF 50mm f/1.4 USM
    Canon EF 50mm f/1.4 USM
    USD $399.00
    Out of stock
    SKU: CAN-12198
    Model: 2515A003
    Condition: New-In-Box
    Mount Type: Canon EOS (EF)
  24. 50mm f/1.4 ZE PLANAR T* (Canon)
    Zeiss 50mm f/1.4 ZE PLANAR T* (Canon)
    USD $725.00
    Out of stock
    SKU: ZEI-1677817
    Model: 1762-851
    Condition: New-In-Box
    Mount Types: Canon EOS (EF), Canon EOS (EF-S)
  25. 85mm f/1.4 ZE PLANAR T* (Canon)
    Zeiss 85mm f/1.4 ZE PLANAR T* (Canon)
    USD $1,283.00
    Out of stock
    SKU: ZEI-1677838
    Model: 1677-851
    Condition: New-In-Box
    Mount Types: Canon EOS (EF), Canon EOS (EF-S)
  26. AF-S NIKKOR 35mm f/1.4G
    Nikon AF-S NIKKOR 35mm f/1.4G
    USD $1,696.95
    Out of stock
    SKU: NIK-12240
    Model: 2198
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  27. AF-S NIKKOR 24mm f/1.4G ED
    Nikon AF-S NIKKOR 24mm f/1.4G ED
    USD $1,996.95
    Out of stock
    SKU: NIK-12190
    Model: 2184
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  28. AF-S NIKKOR 50mm f/1.4G
    Nikon AF-S NIKKOR 50mm f/1.4G
    USD $446.95
    SKU: NIK-12260
    Model: 2180
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  29. AF-S NIKKOR 85mm f/1.4G
    Nikon AF-S NIKKOR 85mm f/1.4G
    USD $1,596.95
    Out of stock
    SKU: NIK-12390
    Model: 2195
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  30. 50mm f/1.4 ZF.2 PLANAR T* (Nikon)
    Zeiss 50mm f/1.4 ZF.2 PLANAR T* (Nikon)
    USD $725.00
    Out of stock
    SKU: ZEI-1767825
    Model: 1762-825
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
View as Grid List

Items 1-30 of 92

Page
per page
Set Ascending Direction