SELECT art.estretail, art.id FROM artitems art WHERE ( art.objectcat = 164) 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: Quote415-215-6533
Mool: Quote415-215-6532
Mool: Callforquote415-215-65
Debug item 23 color: 934109
page: 0
items per page: 9number of items: 13
23
21
1386
3935
3822
3816
3618
3532
3497
3530
3523
3516
3494
page: 0
items per page: 9number of items: 13
23
21
1386
3935
3822
3816
3618
3532
3497
3530
3523
3516
3494
page: 0
items per page: 9number of items: 13
23
21
1386
3935
3822
3816
3618
3532
3497
3530
3523
3516
3494
page: 0
items per page: 9number of items: 13
23
21
1386
3935
3822
3816
3618
3532
3497
3530
3523
3516
3494
page: 0
items per page: 9number of items: 13
23
21
1386
3935
3822
3816
3618
3532
3497
3530
3523
3516
3494
page: 0
items per page: 9number of items: 13
23
21
1386
3935
3822
3816
3618
3532
3497
3530
3523
3516
3494
page: 0
items per page: 9number of items: 13
23
21
1386
3935
3822
3816
3618
3532
3497
3530
3523
3516
3494
page: 0
items per page: 9number of items: 13
23
21
1386
3935
3822
3816
3618
3532
3497
3530
3523
3516
3494
page: 0
items per page: 9number of items: 13
23
21
1386
3935
3822
3816
3618
3532
3497
3530
3523
3516
3494
For Sale
Zoom
Story
Origin
Category:
Textiles / Rugs
Title:
Geometric Orange Design Rugs By Bunting
Price CALL 415-776-0104 for a quote
Item Number 23
Description:
Custom Design Rug, Made From Cowhide Fur. All sizes And shapes / All designs are one-of-a-kind pieces of art and are available for a limited time, so quantities are limited. Call for a quote 415-215-6533 / Interior design applicat more..
Details
Add to Cart