SELECT art.estretail, art.id FROM artitems art WHERE ( art.objectcat = 70) AND ( 1 ) AND ( 1 ) AND ( 1 ) AND ( 1 ) AND (art.publish = 1 AND art.hidden = 0) AND (status = 0 OR (status > 4 AND status < 10)) ORDER BY (CASE WHEN STATUS='0' THEN 0 WHEN STATUS='a' THEN 0 WHEN STATUS='5' THEN 2 WHEN STATUS='a5' THEN 2 WHEN STATUS='10' THEN 3 WHEN STATUS='aa' THEN 3 WHEN STATUS='9' THEN 2 WHEN STATUS='a9' THEN 2 ELSE 3 END), `status` ASC, art.when_published_timestamp DESC LIMIT 0,9
Search Color:
Mool: call415-776-0104
Mool: call-415-776-0104
Mool: call-415-776-0104
Debug item 5420 color: a80000
page: 0
items per page: 9number of items: 18
5420
6307
6495
6494
5790
5002
5793
5792
5791
5595
5487
5006
5005
5004
5000
5001
5594
5593
page: 0
items per page: 9number of items: 18
5420
6307
6495
6494
5790
5002
5793
5792
5791
5595
5487
5006
5005
5004
5000
5001
5594
5593
page: 0
items per page: 9number of items: 18
5420
6307
6495
6494
5790
5002
5793
5792
5791
5595
5487
5006
5005
5004
5000
5001
5594
5593
page: 0
items per page: 9number of items: 18
5420
6307
6495
6494
5790
5002
5793
5792
5791
5595
5487
5006
5005
5004
5000
5001
5594
5593
page: 0
items per page: 9number of items: 18
5420
6307
6495
6494
5790
5002
5793
5792
5791
5595
5487
5006
5005
5004
5000
5001
5594
5593
page: 0
items per page: 9number of items: 18
5420
6307
6495
6494
5790
5002
5793
5792
5791
5595
5487
5006
5005
5004
5000
5001
5594
5593
page: 0
items per page: 9number of items: 18
5420
6307
6495
6494
5790
5002
5793
5792
5791
5595
5487
5006
5005
5004
5000
5001
5594
5593
page: 0
items per page: 9number of items: 18
5420
6307
6495
6494
5790
5002
5793
5792
5791
5595
5487
5006
5005
5004
5000
5001
5594
5593
page: 0
items per page: 9number of items: 18
5420
6307
6495
6494
5790
5002
5793
5792
5791
5595
5487
5006
5005
5004
5000
5001
5594
5593
For Sale
Video
Story
Origin
Category:
Furniture / Cabinets
Title:
Antique Chinese Red Hand Painted Lacquer Wood Cabinet Dresser
Price $2,850.00
Item Number 5420
Description:
Gorgeous, One of the best Chinese antique wooden cabinets I have seen. Red and black lacquered in red with hand painted gold design. Chinese red lacquered and gilt decorated table cabinet, 19th century. with original red & gil more..
Details
Add to Cart