Roberts and UsedPhotoPro will be closed Monday December 25th. Online orders may still be placed but won't process to ship until we open again at 9am December 26th.
Whether you need great low-light performance, shallow depth of field with creamy bokeh, long reach, wide-angle, low distortion, or simply a great all-purpose zoom, the selection of lenses below will surely meet your demands.
Both Nikon and Canon offer every imaginable type of lens – their range consists of great value kit zoom lenses through to high quality zooms and primes for professional work. From the humble 18-55mm kit zooms to the Canon EF 800mm f/5.6L and the Nikon AF-S 800mm f/5.6E. High quality lenses from every other major brand are available in our store for your perusal, and include products from Fuji, Sony, Panasonic, Sigma, Tamron, Olympus, Zeiss and many more. Take a look at the amazing selection below.
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 (11712, 11714, 461927, 491259, 327140, 238705, 65278, 17732, 17733, 79468)) 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,11712,11714,461927,491259,327140,238705,65278,17732,17733,79468)