select p.products_id, p.products_model, p.products_image, p.products_image_lrg, if (isnull(pg.customers_group_price), p.products_price, pg.customers_group_price) as final_price, p.products_tax_class_id, pd.products_name from (products p left join products_groups pg on p.products_id = pg.products_id and pg.customers_group_id = 'G'), products_description pd where p.products_id = '44' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_group_access like '%G%' The Safari Clothing Store | Dress for Adventure! - Reviews - Akubra Kiandra Fur Felt Hat w/Braided Band
Want Your Items Embroidered? Call Us!
WelcomeShopAboutContactAdvertise With UsGuides
7

Shop By Category

 7
Men's Safari Clothing
Safari Shirts
Safari Shorts
Safari Trousers
Safari Jackets/Vests
Ladies Safari Clothing
Safari Tops
Safari Shorts
Safari Trousers
Safari Accessories
Boots & Shoes
Safari Hats
Safari Belts
Personal Accessories
Go Wild Underwear
Expedition Items
Bug Repellent
Leather & Luggage
Gadgets & Tools
Flashlights & Lanterns
Compasses
more...

Would you prefer ordering through the mail? Click here to print a mail-in order form!

To take advantage of our sales and special offers, please place orders online.
7 7
7

Information

 7

About Us
Shipping and Returns
Privacy Statement
Advertising Opportunities
Our Mission and Vision
How to Find Us
How to Order
Contact Us
Site Map
7 7
7

Articles

 7

Product Care (1)
Useful Guides (2)
7 7
7

Links

 7

The Work Uniform Store

The Work Uniform Store
Click here to visit our parent site for more apparel styles, equipment and custom services including military and public safety uniforms as well as corporate casual wear.

Friends of the Store!
Tour Companies
7 7
 $0.00 
There are currently no product reviews.
Back Write Review
7

Product Search

 7

 
7 7
7 7
Mini Wind-up LED Lantern

Now On Sale

Mini Wind-up LED Lantern
 $54.99  $27.00 View
7 7
7

Shopping Cart   

 7

0 items
7 7
7

Tell A Friend

 7

Family/Friend's Email: 
7 7
The closest thing to a real safari without actually being on safari - click here for more inform
7

Listen to Music

 7
The Safari Clothing Store MP3 Player

A cool player with some really cool tunes!
Launch Player
7 7
7 7

"To fight and conquer in all our battles is not supreme excellence; supreme excellence consists in breaking the enemy's resistance without fighting."

- Sun Tzu -
~500 BC-~400 BC
7 7
7

Store Pictures

 7
Oops!

It looks like you don't have flash player 7 installed. Click here to go to Macromedia download page.
7 7

Thursday September 09, 2010

476416 requests since Friday May 30, 2008

© Copyright 2007-2010 The Safari Clothing Store. All rights reserved. Powered by osCommerce - Phoenix Extended Edition v1.5.1.

Design by The GraphicZoo. Development by NewSite Designs.