Blank Firing Guns :: Movie Prop Guns :: Stage-Props-Blank-Guns.com

INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'ON'
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='111' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.product_type <> 'B' AND (xcart_pricing.variantid = 0 OR (xcart_variants.variantid = xcart_pricing.variantid)) AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_products.forsale='Y' GROUP BY xcart_products.productid
INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'ON'
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price, xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.product_type <> 'B' AND (xcart_pricing.variantid = 0 OR (xcart_variants.variantid = xcart_pricing.variantid)) AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_products_categories.categoryid='111' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND xcart_products.forsale='Y' GROUP BY xcart_products.productid
Blank Firing Guns :: Movie Prop Guns :: Stage-Props-Blank-Guns.com

Stage Props - Movie Props - Blank Guns Header.jpg

***MOVIE PROPS - STAGE PROPS - BLANK GUNS - MOVIE WEAPONS - FAKE GUNS*** THE DIRECTOR'S CHOICE MOVIE PROP AND STAGE PROP WEAPONS HOUSE! ***REEL DEALS ON BLANK GUNS *** CALL TOLL FREE: (866) 712-PROP (7767) 8 AM to 5 PM Central...

Search:

Advanced search

HOME | MY ACCOUNT | HELP | CONTACT US

Printable Version

Categories

Movie Prop Blank Guns

Blank Firing Gun Ammunition

Old West Movie Props

Civil War Props and Collectibles

Colonial Stage Props and Collectibles

Pirate Stage Props

Medieval Stage Props

World War II Movie Props

Movie Prop Guns

BB Guns
Blank Firing Guns
Modern Non Firing Hand Guns
Prop and Collectible Replica Flintlock Rifles Non Firing
Replica Collectible Non Firing Flintlock Pistols
Replica Derringers, Non Firing
Replica Muskets and Muzzle Loaders
Replica Rifles, Non Firing
Replica World War II, WWI and other Military Guns
Single Action Revolvers, Prop and Collectible

Movie Prop Swords, Daggers, and Knives

Collectibles Displays and Gifts

Display Cannons

Authentication

Secure login

Recover password

If Javascript is disabled in your browser click here

Your cart

	Cart is empty

View cart
Checkout

Help

131 Greenbriar Dr.
West Monroe La.
71291
Fax: (318) 397-7828
Toll Free Phone:
866 712-PROP (7767)
8 AM to 5 PM Central
Mon.Thru Fri.
Email Us

*We Accept:*

Stage-Props-Blank-Guns.com :: Movie Prop Guns :: Blank Firing Guns

Blank Firing Guns

YES WE ARE OPEN FOR BUSINESS AND SHIP MONDAY THROUGH FRIDAY; We have blank guns sometimes called blank shooting guns, blank firers, replica handguns that fire blanks, cap guns and blank fireing guns for reenactments, movie, stage, and film props, armed forces and military training, police and law enforcement training, display and just having fun. We have every type blank gun that is available in America in both Top Firing Blank Guns and Front Firing blank guns. Our replica blank guns are made of metal not plastic. You can buy your blank guns online here. We have the Walther P99 Blank Gun in Front Firing. Zoraki blank guns are back in front firing. View several pages by changing pages at the bottom of each page.

25% discount on blank guns tabulated at check out, YES WE ARE OPEN FOR BUSINESS AND SHIP MONDAY THROUGH FRIDAY.

CLICK ON ANY CATEGORY BELOW TO VIEW

NEW Retay Front Firing Blank Guns, 9MMPA

Modern Blank Firing Guns

Front Fire Blank Guns

Western Old West Blank Firing Guns

World War II Blank Guns

Fully Automatic Blank Guns

Blank Firing Revolvers

Western Holsters and Scabbards

Blank Firing Pocket Hand Guns

Blanks for Blank Firing Guns

Holsters-Modern

Blank Gun Magazines

Blank Firing Derringers

Accept Credit Cards