SELECT art.estretail, art.id FROM artitems art WHERE ( art.objectcat = 137) 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: Call/Quote*415-776-0104
Debug item 1728 color: f9eedc
page: 0
items per page: 9number of items: 13
1728
6479
1603
6478
6476
6474
6453
5921
3100
2186
2183
1609
2084
page: 0
items per page: 9number of items: 13
1728
6479
1603
6478
6476
6474
6453
5921
3100
2186
2183
1609
2084
page: 0
items per page: 9number of items: 13
1728
6479
1603
6478
6476
6474
6453
5921
3100
2186
2183
1609
2084
page: 0
items per page: 9number of items: 13
1728
6479
1603
6478
6476
6474
6453
5921
3100
2186
2183
1609
2084
page: 0
items per page: 9number of items: 13
1728
6479
1603
6478
6476
6474
6453
5921
3100
2186
2183
1609
2084
page: 0
items per page: 9number of items: 13
1728
6479
1603
6478
6476
6474
6453
5921
3100
2186
2183
1609
2084
page: 0
items per page: 9number of items: 13
1728
6479
1603
6478
6476
6474
6453
5921
3100
2186
2183
1609
2084
page: 0
items per page: 9number of items: 13
1728
6479
1603
6478
6476
6474
6453
5921
3100
2186
2183
1609
2084
page: 0
items per page: 9number of items: 13
1728
6479
1603
6478
6476
6474
6453
5921
3100
2186
2183
1609
2084
For Sale
Video
Story
Origin
Category:
Paintings / Landscapes
Title:
Original Watercolor of a Mediterranean Coastal Home By Angelo Asti
Price $3,950.00
Item Number 1728
Description:
By Angelo Asti. A great 19th century rare watercolor painting of a mediterranean coastal home, signed by the artist in the lower right. Artist, A. Asti. It's a lovely feeling when you finally find a picture from a master waterco more..
Details
Add to Cart