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 '1680321540') 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 '1680321540') WHERE (e.entity_id IN (192412, 10018, 7741, 185653, 184888, 186826, 186898, 185620, 185608, 186907, 184882, 186823, 164952, 164949, 164955, 165430, 10492, 36560, 9766, 187095, 184855, 186232, 189545, 188214, 186412, 11599, 11224, 11461, 165133, 11179, 11215, 11194, 185773, 20478, 193087, 190496, 193096, 190499, 190502, 186340, 87907, 162826, 34647, 164658, 10498, 10624, 10753, 36719, 10762, 10771, 19279, 10435)) ORDER BY FIELD(e.entity_id,192412,10018,7741,185653,184888,186826,186898,185620,185608,186907,184882,186823,164952,164949,164955,165430,10492,36560,9766,187095,184855,186232,189545,188214,186412,11599,11224,11461,165133,11179,11215,11194,185773,20478,193087,190496,193096,190499,190502,186340,87907,162826,34647,164658,10498,10624,10753,36719,10762,10771,19279,10435)

Showing - of 73

Page
  1. Charles Albert Lopez: The Sprinter Sculpture
    Best Seller
    Charles Albert Lopez: The Sprinter Sculpture
    $240.00 - $995.00
    As low as $240.00
  2. 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
  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 Bracelet
    Clearance
    American Gilded Age Bracelet
    $150.00|$75.00
    $75.00
  6. Audubon Birds Notecards
    $15.00
    $15.00
    Audubon Birds Notecards 14 4.5 5 1
  7. Samuel Halpert: The Flatiron Building Poster
    $28.00
    $28.00
    Samuel Halpert: The Flatiron Building Poster 7 4.8 5 1
  8. The Favorite Cat Tote
    $35.00
    $35.00
    The Favorite Cat Tote 8 4.8 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
    Best Seller
    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 Grapevine Oblong Silk Scarf
    $69.00
    $69.00
    Louis C. Tiffany Grapevine Oblong Silk Scarf 23 4.9 5 1
  14. Louis C. Tiffany Magnolias and Irises Silk Neckerchief
    $28.00
    $28.00
    Louis C. Tiffany Magnolias and Irises Silk Neckerchief 2 3.5 5 1
  15. Louis C. Tiffany Magnolias Coin Purse
    $28.00
    $28.00
    Louis C. Tiffany Magnolias Coin Purse 3 4 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 3 3.7 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
    Best Seller
    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
    Best Seller
    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. Louis C. Tiffany Stained-Glass Coasters
    $28.00
    $28.00
    Louis C. Tiffany Stained-Glass Coasters 11 4.5 5 1
  24. Louis C. Tiffany Favrile Coasters
    $28.00
    $28.00
    Louis C. Tiffany Favrile Coasters 42 4.6 5 1

Showing - of 73

Page