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 (7451, 8324, 8343, 8522, 10766, 10767, 11698, 11700, 11741, 4690, 2943, 2944, 2949, 2951, 2955, 2956, 2959, 2965, 3036, 14423, 14681, 14684, 14703, 14708, 15090, 9146, 9147, 10476, 5254, 5256)) 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,7451,8324,8343,8522,10766,10767,11698,11700,11741,4690,2943,2944,2949,2951,2955,2956,2959,2965,3036,14423,14681,14684,14703,14708,15090,9146,9147,10476,5254,5256)
View as Grid List

Items 1-30 of 66

Page
per page
Set Ascending Direction
  1. AF-S DX NIKKOR 10-24mm f/3.5-4.5G ED
    Nikon AF-S DX NIKKOR 10-24mm f/3.5-4.5G ED
    USD $896.95
    SKU: NIK-12060
    Model: 2181
    Condition: New-In-Box
    Mount Type: Nikon F (DX)
  2. AF 12-24mm f/4.5-5.6 II DG HSM Aspherical Lens (Nikon)
    SKU: SIG-00044
    Model: 204-306
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  3. AF 150mm f/2.8 APO MACRO EX DG OS HSM (Nikon)
    Sigma AF 150mm f/2.8 APO MACRO EX DG OS HSM (Nikon)
    USD $1,099.00
    Out of stock
    SKU: SIG-00366
    Model: 106306
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  4. AF-S NIKKOR 50mm f/1.8G
    Nikon AF-S NIKKOR 50mm f/1.8G
    USD $216.95
    SKU: NIK-12274
    Model: 2199
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  5. Distagon T* 3.5/18 ZF.2 (Nikon)
    Zeiss Distagon T* 3.5/18 ZF.2 (Nikon)
    USD $1,395.00
    Out of stock
    SKU: ZEI-1767822
    Model: 1767-822
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  6. Distagon T* 2/28 ZF.2 (Nikon)
    Zeiss Distagon T* 2/28 ZF.2 (Nikon)
    USD $1,283.00
    Out of stock
    SKU: ZEI-1771844
    Model: 1771-844
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  7. Sigma 15mm F2.8 EX DG Diagonal Fisheye (Nikon)
    USD $609.00
    Out of stock
    SKU: SIG-00052
    Model: 476306
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  8. 4.5mm f/2.8 EX DC HSM Circular Fisheye (Nikon DX)
    SKU: SIG-00005
    Model: 486306
    Condition: New-In-Box
    Mount Type: Nikon F (DX)
  9. Tokina AT-X 100mm f/2.8 Macro (Nikon)
    USD $409.00
    Out of stock
    SKU: TOK-01162
    Model: ATX100PROD-N
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  10. SP AF60mm F2 Di II LD (IF) 1:1 Macro (Nikon Mount)
    SKU: TAN-00371
    Model: AFG005N-700
    Condition: New-In-Box
    Mount Type: Nikon F (DX)
  11. AF DX Fisheye-NIKKOR 10.5mm f/2.8G ED
    Nikon AF DX Fisheye-NIKKOR 10.5mm f/2.8G ED
    USD $774.95
    Out of stock
    SKU: NIK-12065
    Model: 2148
    Condition: New-In-Box
    Mount Type: Nikon F (DX)
  12. AF NIKKOR 14mm f/2.8D ED
    Nikon AF NIKKOR 14mm f/2.8D ED
    USD $1,894.95
    Out of stock
    SKU: NIK-12075
    Model: 1925
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  13. AF NIKKOR 20mm f/2.8D
    Nikon AF NIKKOR 20mm f/2.8D
    USD $624.95
    Out of stock
    SKU: NIK-12185
    Model: 1913
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  14. 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)
  15. AF-S NIKKOR 200-400mm f/4G ED VR II
    Nikon AF-S NIKKOR 200-400mm f/4G ED VR II
    USD $6,996.95
    Out of stock
    SKU: NIK-12490
    Model: 2187
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  16. AF-S DX NIKKOR 35mm f/1.8G
    Nikon AF-S DX NIKKOR 35mm f/1.8G
    USD $196.95
    SKU: NIK-12245
    Model: 2183
    Condition: New-In-Box
    Mount Type: Nikon F (DX)
  17. AF-S NIKKOR 50mm f/1.4G
    Nikon AF-S NIKKOR 50mm f/1.4G
    USD $446.95
    Out of stock
    SKU: NIK-12260
    Model: 2180
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  18. 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)
  19. AF-S NIKKOR 200mm f/2G ED VR II
    Nikon AF-S NIKKOR 200mm f/2G ED VR II
    USD $5,696.95
    Out of stock
    SKU: NIK-12462
    Model: 2188
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  20. Rokinon 8mm f/3.5 Fisheye Lens (Nikon)
    USD $299.00
    Out of stock
    SKU: ROK-00820
    Model: 2661
    Condition: New-In-Box
    Mount Type: Nikon F (DX)
  21. Rokinon 14mm F/2.8 ED (Nikon)
    USD $399.00
    Out of stock
    SKU: ROK-01420
    Model: 2654
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  22. 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)
  23. 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)
  24. APO Macro 180mm f/2.8 EX DG OS HSM (Nikon)
    Sigma APO Macro 180mm f/2.8 EX DG OS HSM (Nikon)
    USD $1,699.00
    Out of stock
    SKU: SIG-00377
    Model: 107306
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  25. Sigma APO Macro 180mm f/2.8 EX DG OS HSM (Sony)
    USD $1,699.00
    Out of stock
    SKU: SIG-00378
    Model: 107205
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  26. 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)
  27. 85mm f/1.4 ZF.2 PLANAR T* (Nikon)
    Zeiss 85mm f/1.4 ZF.2 PLANAR T* (Nikon)
    USD $1,283.00
    Out of stock
    SKU: ZEI-1767826
    Model: 1762-826
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
  28. AF-S DX NIKKOR 40mm f/2.8G Micro
    Nikon AF-S DX NIKKOR 40mm f/2.8G Micro
    USD $276.95
    SKU: NIK-12253
    Model: 2200
    Condition: New-In-Box
    Mount Type: Nikon F (DX)
  29. AF-S DX Zoom-NIKKOR 12-24mm f/4G IF-ED
    Nikon AF-S DX Zoom-NIKKOR 12-24mm f/4G IF-ED
    USD $1,146.95
    Out of stock
    SKU: NIK-12070
    Model: 2144
    Condition: New-In-Box
    Mount Type: Nikon F (DX)
  30. Nikon AF Fisheye-NIKKOR 16mm f/2.8D
    USD $999.95
    Out of stock
    SKU: NIK-12085
    Model: 1910
    Condition: New-In-Box
    Mount Types: Nikon F (DX), Nikon F (FX)
View as Grid List

Items 1-30 of 66

Page
per page
Set Ascending Direction