SELECT art.estretail, art.id FROM artitems art WHERE ( art.objectcat = 71) 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: call415-776-0104
Mool: Call/Quote*415-776-0104
Mool: Call/Quote*415-776-0104
Mool: Call/Quote*415-776-0104
Mool:
Mool: call415-776-0104
Mool: call*415-776-0104
Debug item 5766 color: 8e004a
page: 0
items per page: 9number of items: 23
5766
5767
5765
6520
6518
6434
6433
1707
4906
6117
6114
5160
4309
4312
3241
4261
4315
4314
3330
4313
4311
3399
4954
page: 0
items per page: 9number of items: 23
5766
5767
5765
6520
6518
6434
6433
1707
4906
6117
6114
5160
4309
4312
3241
4261
4315
4314
3330
4313
4311
3399
4954
page: 0
items per page: 9number of items: 23
5766
5767
5765
6520
6518
6434
6433
1707
4906
6117
6114
5160
4309
4312
3241
4261
4315
4314
3330
4313
4311
3399
4954
page: 0
items per page: 9number of items: 23
5766
5767
5765
6520
6518
6434
6433
1707
4906
6117
6114
5160
4309
4312
3241
4261
4315
4314
3330
4313
4311
3399
4954
page: 0
items per page: 9number of items: 23
5766
5767
5765
6520
6518
6434
6433
1707
4906
6117
6114
5160
4309
4312
3241
4261
4315
4314
3330
4313
4311
3399
4954
page: 0
items per page: 9number of items: 23
5766
5767
5765
6520
6518
6434
6433
1707
4906
6117
6114
5160
4309
4312
3241
4261
4315
4314
3330
4313
4311
3399
4954
page: 0
items per page: 9number of items: 23
5766
5767
5765
6520
6518
6434
6433
1707
4906
6117
6114
5160
4309
4312
3241
4261
4315
4314
3330
4313
4311
3399
4954
page: 0
items per page: 9number of items: 23
5766
5767
5765
6520
6518
6434
6433
1707
4906
6117
6114
5160
4309
4312
3241
4261
4315
4314
3330
4313
4311
3399
4954
page: 0
items per page: 9number of items: 23
5766
5767
5765
6520
6518
6434
6433
1707
4906
6117
6114
5160
4309
4312
3241
4261
4315
4314
3330
4313
4311
3399
4954
For Sale
Video
Story
Origin
Category:
Furniture / Chairs
Title:
Custom Hide Chairs By Kyle Bunting Interior Design Applications
Price CALL 415-776-0104 for a quote
Item Number 5766
Description:
Cozy up this winter in a Kyle Bunting hide chair! A Fantastic Custom Chair, Get a quote in any color. The designer Kyle Bunting, uses a pioneering technique. He is a famed designer of amazing rugs, furniture, and upholstery more..
Details
Add to Cart