1st Cav 2BCT "Blackjack"

larger image

$2,675.00

Wood Type Desired: Poplar
Stain Desired: Walnut
Shape of Board Desired: Rectangular (Horizontal Layout)
Frame Style Desired: Clear Acrylic
Frame Sizes: 8"x10"
Engraving: Engraved tags attached to board permanently
Material/Color: Gold tag w/ black lettering
Lettering: 1/8" thick acrylic (lacquer finish TBA)
Command Art, Logos, and Images: Art required
Free standing or wall mount: Wall mount

Instructions/Message:

1st Cavalry Division patch in top left corner.
Brigade patch (similar to 1ST CAV patch) in top right corner.

4 rows of pictures if possible.
1st row (L-R: CSA, CSMA, SECDEF, POTUS, SECARMY, FORSCOM CG, CORSCOM
CSM
2nd Row: III Corps CG, III Corps CSM, 1CD CG, 1CD CSM, BDE CDR, BDe
CSM
3rd ROW: 7x BN CDRs
4th ROW: 7x BN CSMs

We would permanently engrave positions/call signs on the board under
the
pictures. On the top of the board would read; 2nd ARMORED BRIGADE
COMBAT
TEAM with 1st CAVALRY DIVISION underneath. Across the bottom of the
board
would be the brigade motto "BLACKJACK".

Add to Cart:

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'armytrai_militau4_znc1.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from znc_orders_products opa, znc_orders_products opb, znc_orders o, znc_products p where opa.products_id = '75227' and opa.orders_id = opb.orders_id and opb.products_id != '75227' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 group by p.products_id order by o.date_purchased desc limit 6]