For Now & Forever

Hamilton American Classic

Founded in Lancaster, Pennsylvania, in 1892, Hamilton’s pioneering spirit is displayed in it’s American Classic collection. With vintage designs and signature style, these are timepieces with personality.
Loading...
Filter Your Selection
Navigation instructions: Press tab to skip through filters; press down and up arrow keys to navigate filter options; press space to select or unselect an option; press enter to apply all filters at once; press escape to close filters panel; press del to clear all filters

Price

  • Entering values in the input field will update the content below.

Jewelry Type

Metal Color

Metal Type

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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`, `stock_status_index`.`is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=1243 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' INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id AND (product.created_in '1617253141') INNER JOIN `inventory_stock_6` AS `stock_status_index` ON product.sku = stock_status_index.sku LEFT JOIN `catalog_product_entity_int` AS `sw_featured_t` ON e.row_id=sw_featured_t.row_id AND sw_featured_t.attribute_id='173' AND sw_featured_t.store_id='0' WHERE ((stock_status_index.is_salable = 1) AND (e.entity_id IN (1302, 8897, 11929, 17280, 20170, 976, 1170, 36526, 36247, 36133, 36136, 36139, 2278, 31337))) AND (e.created_in '1617253141') ORDER BY `sw_featured_t`.`value` DESC, `cat_index`.`position` ASC, `e`.`entity_id` DESC

14 Items

14 Items