SELECT art.estretail, art.id FROM artitems art WHERE ( art.objectcat = 209) 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 9,9
Search Color:
Mool: call-415-776-0104
Mool: call415-215-6533
Mool: call-415-776-0104
Mool: call-415-776-0104
Mool: call-415-776-0104
Debug item 3220 color: 8a6030
page: 1
items per page: 9number of items: 21
6788
6781
1023
5230
5229
4943
5228
5451
5380
5232
3220
5453
1020
6136
5455
5454
5452
5231
1019
1021
1011
page: 1
items per page: 9number of items: 21
6788
6781
1023
5230
5229
4943
5228
5451
5380
5232
3220
5453
1020
6136
5455
5454
5452
5231
1019
1021
1011
page: 1
items per page: 9number of items: 21
6788
6781
1023
5230
5229
4943
5228
5451
5380
5232
3220
5453
1020
6136
5455
5454
5452
5231
1019
1021
1011
page: 1
items per page: 9number of items: 21
6788
6781
1023
5230
5229
4943
5228
5451
5380
5232
3220
5453
1020
6136
5455
5454
5452
5231
1019
1021
1011
page: 1
items per page: 9number of items: 21
6788
6781
1023
5230
5229
4943
5228
5451
5380
5232
3220
5453
1020
6136
5455
5454
5452
5231
1019
1021
1011
page: 1
items per page: 9number of items: 21
6788
6781
1023
5230
5229
4943
5228
5451
5380
5232
3220
5453
1020
6136
5455
5454
5452
5231
1019
1021
1011
page: 1
items per page: 9number of items: 21
6788
6781
1023
5230
5229
4943
5228
5451
5380
5232
3220
5453
1020
6136
5455
5454
5452
5231
1019
1021
1011
page: 1
items per page: 9number of items: 21
6788
6781
1023
5230
5229
4943
5228
5451
5380
5232
3220
5453
1020
6136
5455
5454
5452
5231
1019
1021
1011
page: 1
items per page: 9number of items: 21
6788
6781
1023
5230
5229
4943
5228
5451
5380
5232
3220
5453
1020
6136
5455
5454
5452
5231
1019
1021
1011
SOLD
Video
Story
Origin
Category:
Stone / Fossils
Title:
Very Rare Large Robust Fossil Ammonite
Price $1,285.00
Item Number 3220
{SOLD}
Description:
Wow, Few of the ammonites reach a size exceeding (9 inches) in diameter, this one is over that! This is an example of a huge world class AAA grade Ammonite Specimen! Gorgeous! Vary hard to find one this big! Ammonite is a fos more..
Details