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`, `e`.`pricing_details`, `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 '1695614400') 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 '1695614400') WHERE (e.entity_id IN (192412, 10018, 7741, 185653, 185608, 186907, 184882, 186823, 164949, 164946, 165430, 10492, 194899, 188214, 186412, 186433, 184855, 186232, 187095, 87907, 193972, 193984, 193966, 193969, 165133, 11461, 11239, 165130, 11215, 11224, 11284, 11290, 11194, 184888, 186826, 186898, 185620, 193087, 190496, 193813, 190502, 193096, 193810, 190499, 7681, 162826, 34647, 164658, 10624, 10753, 10762, 187599)) ORDER BY FIELD(e.entity_id,192412,10018,7741,185653,185608,186907,184882,186823,164949,164946,165430,10492,194899,188214,186412,186433,184855,186232,187095,87907,193972,193984,193966,193969,165133,11461,11239,165130,11215,11224,11284,11290,11194,184888,186826,186898,185620,193087,190496,193813,190502,193096,193810,190499,7681,162826,34647,164658,10624,10753,10762,187599)

Showing - of 66

Page
  1. 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. Audubon Birds Notecards
    $15.00
    $15.00
    Audubon Birds Notecards 14 4.5 5 1
  6. The Favorite Cat Tote
    Best Seller
    The Favorite Cat Tote
    $38.00
    $38.00
  7. Louis C. Tiffany Gladioli Wool-Blend Shawl
    $89.00
    $89.00
    Louis C. Tiffany Gladioli Wool-Blend Shawl 1 5 5 1
  8. 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 198 4.7 5 1
  9. Louis C. Tiffany White Magnolia Oblong Silk Scarf
    Best Seller
    Louis C. Tiffany White Magnolia Oblong Silk Scarf
    $69.00
    $69.00
    Louis C. Tiffany White Magnolia Oblong Silk Scarf 77 4.9 5 1
  10. Louis C. Tiffany Grapevine Oblong Silk Scarf
    $69.00
    $69.00
    Louis C. Tiffany Grapevine Oblong Silk Scarf 23 4.9 5 1
  11. 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
  12. 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
  13. Louis C. Tiffany Peonies Silk Neckerchief
    $28.00
    $28.00
    Louis C. Tiffany Peonies Silk Neckerchief 12 4.6 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. Pine Needle Openwork Cuff
    $110.00
    $110.00
    Pine Needle Openwork Cuff 11 5 5 1
  16. Louis C. Tiffany: Magnolias and Irises Oversize Puzzle
    $29.95
    $29.95
    Louis C. Tiffany: Magnolias and Irises Oversize Puzzle 5 3 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 13 4.2 5 1
  18. Louis C. Tiffany Peacock Feather Paperweight
    $24.00
    $24.00
    Louis C. Tiffany Peacock Feather Paperweight 14 4.3 5 1
  19. Louis C. Tiffany Stained Glass Domed Magnets
    Best Seller
    Louis C. Tiffany Stained Glass Domed Magnets
    $22.00
    $22.00
    Louis C. Tiffany Stained Glass Domed Magnets 56 4.9 5 1
  20. Louis C. Tiffany Favrile Domed Magnets
    $22.00
    $22.00
    Louis C. Tiffany Favrile Domed Magnets 47 4.9 5 1

Showing - of 66

Page