The American Wing

Inspired by our 1,700 works of fine and decorative American art
FILTERS:

SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`name`, `e`.`sku`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`url_key`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`giftcard_amounts`, `e`.`allow_open_amount`, `e`.`open_amount_min`, `e`.`open_amount_max`, `e`.`tax_class_id`, `e`.`swatch_image`, `e`.`was_price`, `e`.`member_price`, `e`.`member_was_price`, `e`.`launch_date`, `e`.`book_language`, `e`.`book_language_value`, `e`.`giftcard_amt`, `e`.`giftcard_amt_value`, `e`.`more_ways_to_shop`, `e`.`size_2`, `e`.`size_2_value`, `e`.`hover_image`, `e`.`bv_feed_exclude`, `e`.`sale_badge`, `e`.`am_shipping_type`, `e`.`am_shipping_type_value`, `e`.`price_range`, `e`.`bv_category_id`, `e`.`bv_category_id_value`, `e`.`custom_product_badge_block`, `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`, `product_entity`.`row_id`, `stock_status_index`.`stock_status` AS `is_salable`, `e_entity`.`row_id` FROM `catalog_product_flat_1` 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 `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_entity` ON product_entity.entity_id = e.entity_id AND (product_entity.created_in '1669957201') LEFT 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 INNER JOIN `catalog_product_entity` AS `e_entity` ON e_entity.entity_id = e.entity_id AND (e_entity.created_in '1669957201') WHERE (e.entity_id IN (10018, 192412, 162829, 7741, 185653, 184888, 186826, 186898, 185608, 186907, 184882, 186823, 164952, 164946, 164949, 164955, 164943, 165430, 8674, 8296, 36836, 10492, 11224, 11461, 165133, 165130, 11179, 11284, 185773, 186340, 186358, 186331, 20478, 13900, 87907, 162826, 34647, 164658, 10498, 10624, 10753, 187599, 36719, 10762, 10771, 163606, 7681, 93321, 93312, 93324, 93282, 93276)) ORDER BY FIELD(e.entity_id,10018,192412,162829,7741,185653,184888,186826,186898,185608,186907,184882,186823,164952,164946,164949,164955,164943,165430,8674,8296,36836,10492,11224,11461,165133,165130,11179,11284,185773,186340,186358,186331,20478,13900,87907,162826,34647,164658,10498,10624,10753,187599,36719,10762,10771,163606,7681,93321,93312,93324,93282,93276)

Showing 1 - of 72

Page
  1. Augustus Saint-Gaudens: Diana Sculpture
    Best Seller
    Augustus Saint-Gaudens: Diana Sculpture
    $495.00
    $495.00
    Augustus Saint-Gaudens: Diana Sculpture 17 4 5 1
  2. Leutze: Washington Crossing the Delaware Puzzle
    Clearance
    Leutze: Washington Crossing the Delaware Puzzle
    $29.95|$14.98
    $14.98
    Leutze: Washington Crossing the Delaware Puzzle 1 1 5 1
  3. Can You Find It? America
    $16.95
    $16.95
    Can You Find It? America 3 5 5 1
  4. American Gilded Age Pendant Necklace
    $98.00
    $98.00
    American Gilded Age Pendant Necklace 1 2 5 1
  5. American Gilded Age Stud Earrings
    $65.00
    $65.00
    American Gilded Age Stud Earrings 1 5 5 1
  6. Arts and Crafts Lapis Pendant Necklace
    $165.00
    $165.00
    Arts and Crafts Lapis Pendant Necklace 33 4.3 5 1
  7. Arts and Crafts Enamel Drop Earrings
    $55.00
    $55.00
    Arts and Crafts Enamel Drop Earrings 11 4.1 5 1
  8. Audubon Birds Notecards
    Best Seller
    Audubon Birds Notecards
    $15.00
    $15.00
    Audubon Birds Notecards 14 4.5 5 1
  9. Louis C. Tiffany Irises Oblong Silk Scarf
    Best Seller
    Louis C. Tiffany Irises Oblong Silk Scarf
    $69.00
    $69.00
    Louis C. Tiffany Irises Oblong Silk Scarf 107 4.9 5 1
  10. Louis C. Tiffany Peacock Feather Wool-Blend Shawl
    Best Seller
    Louis C. Tiffany Peacock Feather Wool-Blend Shawl
    $89.00
    $89.00
    Louis C. Tiffany Peacock Feather Wool-Blend Shawl 197 4.7 5 1
  11. Louis C. Tiffany Gladioli Wool-Blend Shawl
    $89.00
    $89.00
    Louis C. Tiffany Gladioli Wool-Blend Shawl 1 5 5 1
  12. Louis C. Tiffany Peony Silk Neckerchief
    $28.00
    $28.00
    Louis C. Tiffany Peony Silk Neckerchief 16 4.9 5 1
  13. Louis C. Tiffany Clematis Oblong Silk Scarf
    Best Seller
    Louis C. Tiffany Clematis Oblong Silk Scarf
    $69.00
    $69.00
    Louis C. Tiffany Clematis Oblong Silk Scarf 29 5 5 1
  14. Louis C. Tiffany Magnolias Coin Purse
    $28.00
    $28.00
    Louis C. Tiffany Magnolias Coin Purse 3 4 5 1
  15. Louis C. Tiffany Dragonfly Enamel Pin
    $10.00
    $10.00
    Louis C. Tiffany Dragonfly Enamel Pin 3 5 5 1
  16. Louis C. Tiffany: Magnolias and Irises Oversize Puzzle
    Best Seller
    Louis C. Tiffany: Magnolias and Irises Oversize Puzzle
    $29.95
    $29.95
    Louis C. Tiffany: Magnolias and Irises Oversize Puzzle 2 4 5 1
  17. Louis C. Tiffany Dragonflies Correspondence Cards
    Best Seller
    Louis C. Tiffany Dragonflies Correspondence Cards
    $28.00
    $28.00
    Louis C. Tiffany Dragonflies Correspondence Cards 12 4.5 5 1
  18. Louis C. Tiffany Glass Notecards
    $15.00
    $15.00
    Louis C. Tiffany Glass Notecards 16 4.7 5 1
  19. Louis C. Tiffany Peacock Feather Paperweight
    $24.00
    $24.00
    Louis C. Tiffany Peacock Feather Paperweight 14 4.3 5 1
  20. Louis C. Tiffany Stained Glass Domed Magnets
    $22.00
    $22.00
    Louis C. Tiffany Stained Glass Domed Magnets 56 4.9 5 1
  21. Louis C. Tiffany Favrile Domed Magnets
    $22.00
    $22.00
    Louis C. Tiffany Favrile Domed Magnets 47 4.9 5 1
  22. Louis C. Tiffany Lamps Domed Magnets
    $22.00
    $22.00
    Louis C. Tiffany Lamps Domed Magnets 8 4.8 5 1
  23. Pine Needle Openwork Cuff
    $95.00
    $95.00
    Pine Needle Openwork Cuff 11 5 5 1
  24. Mosaic Column Pendant Necklace
    $85.00
    $85.00
    Mosaic Column Pendant Necklace 1 2 5 1

Showing 1 - of 72

Page