Figures, Portraits
SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `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` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index` 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='1432'
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_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_product_index_eav` AS `layered_nav_name_of_artist` ON `layered_nav_name_of_artist`.`entity_id` = `e`.`entity_id` AND `layered_nav_name_of_artist`.`attribute_id` = '190' AND `layered_nav_name_of_artist`.`store_id` = '1' AND `layered_nav_name_of_artist`.`value` IN (3994,2731,2808) ORDER BY `cat_index`.`position` ASC
LIMIT 32
-
-
-
Gerard Razzia-Poster Auction-1992 Offset Lithograph-SIGNEDNow Only $2,125.00 Regular Price $2,500.00
-
/Subject/Figures, Portraits
Shop By
Now Shopping by
Shopping Options
- Artist Razzia Remove This Item
- Artist Schmidt Remove This Item
- Artist Gould Remove This Item
Artist
- Gainsborough 1 item
- Valdes 1 item
- Adami 1 item
- Artschwager 1 item
- Aubert 1 item
- Baird 12 items
- Baj 4 items
- Barford 1 item
- Barnet 5 items
- Barney 1 item
- Basquiat 2 items
- Bearden 1 item
- Beardsley 1 item
- Beaulieu 1 item
- Ben-Zion 2 items
- Berard 2 items
- Blake 1 item
- Blum 2 items
- Blumenfeld 2 items
- Bonnard 5 items
- Botero 15 items
- Boudet 1 item
- Brianchon 3 items
- Bridge 1 item
- Britto 1 item
- Britz 4 items
- Brouwer 1 item
- Bull 1 item
- Cahen 1 item
- Cassatt 1 item
- Cathelin 1 item
- Cesar 1 item
- Chagall 50 items
- Chardin 1 item
- Cheret 1 item
- Christus 1 item
- Chwast 2 items
- Clarke 1 item
- Clerisse 1 item
- Colbert 6 items
- Crook 1 item
- Croswell 1 item
- Da Correggio 1 item
- Da Vinci 3 items
- Dali 6 items
- Danby 1 item
- Darfeuil 1 item
- Daumier 1 item
- Davies and Douglas 1 item
- Davis 1 item
- De Saint 1 item
- De Stael 1 item
- Degas 3 items
- Delaunay 1 item
- Depero 1 item
- Derain 2 items
- Dine 6 items
- Doisneau 2 items
- Draeger 2 items
- Dubin 2 items
- Dubuffet 2 items
- Duchamp 1 item
- Dufour 1 item
- Durer 1 item
- Edwards 5 items
- Eggleston 1 item
- Ernst 1 item
- Erte 32 items
- Esler 1 item
- Farland 1 item
- Fischl 2 items
- Folon 3 items
- Fragonard 1 item
- Frasconi 1 item
- Garache 1 item
- Geddes 1 item
- Giacometti 3 items
- Glaser 6 items
- Godunow 1 item
- Gonzales 1 item
- Gorman 4 items
- Gossaert 1 item
- Graf 1 item
- Graham 1 item
- Grau 1 item
- Greenblat 1 item
- Gruau 1 item
- Guys 2 items
- Halsman 1 item
- Hamilton 1 item
- Haring 5 items
- Helnwein 10 items
- Herge 5 items
- Hey 1 item
- Hiroshige 2 items
- Hockney 18 items
- Holbein 1 item
- Homer 1 item
- Hopper 1 item
- Hughes 1 item
- Indiana 3 items
- Ingres 2 items
- Jenkins 1 item
- Jichosai 1 item
- Kahlo 1 item
- Katz 2 items
- Keller 1 item
- Kirchner 1 item
- Klee 3 items
- Klimt 2 items
- Lalande 1 item
- Laurencin 3 items
- Lavreince 2 items
- Lawrence 1 item
- Leger 6 items
- Leu 1 item
- Lichtenstein 13 items
- Macke 1 item
- Magnelli 1 item
- Magritte 10 items
- Maillol 4 items
- Man Hoi 1 item
- Man Ray 3 items
- Manet 2 items
- Masson 1 item
- Matieu 1 item
- McMullan 1 item
- Meisel 1 item
- Menzel 1 item
- Miller 1 item
- Minaux 1 item
- Miralda 1 item
- Modigliani 7 items
- Monahan 1 item
- Moore 2 items
- Moreau 1 item
- Mori 1 item
- Munch 1 item
- Nagel 3 items
- Nauman 1 item
- Neiman 3 items
- Oldenburg 1 item
- Patterson 1 item
- Peyton 1 item
- Pfeffer 1 item
- Picasso 67 items
- Porter 1 item
- Prendergast 2 items
- Ramos 1 item
- Rauschenberg 2 items
- Razzia 2 items
- Rebeyrolle 3 items
- Rembrandt 10 items
- Renoir 4 items
- Richter 1 item
- Ritts 1 item
- Rivera 9 items
- Rockwell 16 items
- Rodin 2 items
- Rosenquist 2 items
- Rouault 10 items
- Rousseau 3 items
- Saint Exupery 10 items
- Saint Phalle 3 items
- Salle 1 item
- Sandler 1 item
- Santi 2 items
- Saura 1 item
- Schiele 1 item
- Schlemmer 1 item
- Schmidt 1 item
- Schnabel 4 items
- Schonzeit 1 item
- Shahn 13 items
- Sherman 3 items
- Sieff 1 item
- Signac 1 item
- Simpson 1 item
- Smith 1 item
- Sorrenti 1 item
- Soyer 1 item
- Spruance 13 items
- Steinberg 2 items
- Sum 2 items
- Tarkay 1 item
- Tatafiore 5 items
- Thomas 2 items
- Ting 1 item
- Tobiasse 3 items
- Toulouse-Lautrec 27 items
- Tremois 1 item
- Trova 2 items
- van Dongen 1 item
- van Gogh 1 item
- van Velde 2 items
- Various Artists 1 item
- Velazquez 1 item
- Vernet 1 item
- Villon 1 item
- Vincent 1 item
- Voinquel 1 item
- Warhol 47 items
- Weber 3 items
- Wesselmann 7 items
- Wilson 3 items
- Wood 2 items
- Wunderlich 1 item
- Yokoo 1 item
- Chanel 1 item
- Blais 1 item
- Cassandre 5 items
- Miro 1 item
- Calder 3 items
- Bacon 12 items
- Chagall 6 items
- Matisse 29 items
- Mucha 10 items
- Braque 3 items
- Lindner 7 items
- Rivers 2 items
- Close 3 items
- Baldessari 1 item
- Marshall 3 items
- Halsband 1 item
- Le Yaouanc 1 item
- Malevich 1 item
- Kand 1 item
- Farin 1 item
- Echo 1 item
- Riefenstahl 2 items
- Field 1 item
- Cunningham 1 item
- Marini 4 items
- German School 1 item
- Flemish School 1 item
- Leclercq 1 item
- Unknown 81 items
- Auld 1 item
- Nathon 1 item
- Boisrond 1 item
- Laurens 1 item
- Pongracz 1 item
- Tuymans 1 item
- Piccillo 2 items
- Cortez 1 item
- Brueghel 1 item
- Raphael 1 item
- Starn 1 item
- Gould 1 item
- Carlu 1 item
- Heckel 1 item
- Beham 1 item
- Currin 1 item
- Abramovic 1 item
- Seidner 1 item
- Greenfield-Sanders 1 item
- Tanner 1 item
- Riml 1 item
- Bruehl 1 item
- V.N. 1 item
- Coupon 1 item
- De Clerck 1 item
- Holston 1 item
- Stark 1 item
- Tomek & Eryk 3 items
- Sikora 1 item
- Quijano 6 items
- Rafuse 1 item
- de Brunhoff 1 item
- Schoefft 1 item
- IIani 1 item
- Lombardo 1 item
- McCavitt 1 item
- Victors 1 item
- Pann 3 items
- de Haan 1 item
- Barrat 1 item
- Satok 1 item
- Hadi 1 item
- Carmi 1 item
- Amotz 1 item
- Coffin 1 item
- Kratzman 1 item
- Sharir 1 item
- Bachs 1 item
- McKowen 1 item
Price
Color Profile
Shape
Space
Wish List
