 |
Categories |
 |
|
 |
Site Features |
|
|
|
Manufacturers |
|
|
|
|
|
Quick Find |
|
|
|
Shop By Price |
|
|
|
Information |
|
|
|
Welcome to Island Hobbies!  |
 |
|
|
| Welcome Guest! Would you like to log yourself in? Or would you prefer to create an account? |
|
Don't forget to sign up for an account now and subscribe to our newsletter! It will keep you up to date on our specials and new arrivals!
|
|
| - Wednesday 28 November, 2007 |
Viewed:419 |
|
We have Transformers, as well as Moon Sand. New Stock now in on Premium Brands Like: Barbie, Bratz, Fisher Price, LeapFrog, Lego, Scooters, Costumes, PowerWheels, Uncle Milton, Jada, Maisto, Thunder Tiger, Raptor, Shakspeer Fishing Rods, TV Games, X-Box 360, Nintendo WII, Ps-2, PSP, Nintendo DS, Ninja Stars, Knives, Swords, Tool Boxes, Scientific Explorer, LOTS of Board Games, and MUCH MUCH MORE
|
|
|
|
|
|
[Read More]
|
|
|
|
| - Wednesday 28 November, 2007 |
Viewed:447 |
|
| Dear Customers, Please be Advised that only about 5% of our items are on this web site, please come in to any of our 2 locations, in the north or the south. We Promise, you will FREAK OUT. |
|
|
|
|
|
[Read More]
|
|
|
|
| - Wednesday 28 November, 2007 |
Viewed:470 |
|
EXPAND YOUR CHILDS MIND, INSTEAD OF STICKING BEHIND TV GAMES ALL DAY, GET THEM INVOLED IN A CONSTRUCTIVE HOBBY. ANYTHING FROM RADIO CONTROL AIRPLANES, BOATS, HELI'S, CARS OR
TRUCKS, TO MODEL ROCKETRY, MODEL BUILDING AND LOTS MORE. WE AT ISLAND HOBBIES SUPPLY IT ALL AND SAY: IT'S TIME TO GO OUTDOORS. COME HAVE A CHAT WITH US. |
|
|
|
|
|
[Read More]
|
|
|
|
|
|
News and Information |
|
|
Associated in stock- Wednesday 02 May, 2007
|
Viewed:954 |
|
|
|
CONTACT INFO- Thursday 16 November, 2006
|
Viewed:1273 |
|
ISLAND HOBBIES CONTACT INFO. P.O.S. -(868)624-9409, SOUTH- (868)653-7526.
EMAL- islandhobbies@opus.co.tt |
|
| [Read More] |
|
|
|
|
NEW ASSOCIATED STOCK IN- Saturday 05 August, 2006
|
Viewed:971 |
|
| ASSOCIATED STOCK JUST ARRIVED and the Prices, Unbelievable. LIKE THE TC-4 RTR, JUST $1,999.99A MUST READ |
|
| [Read More] |
|
|
|
|
|
1054 - Unknown column 'p.products_id' in 'on clause'
select p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_description, pd.products_short, p.products_image, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.manufacturer_featured_until, mi.manufacturers_id, mi.languages_id, mi.manufacturers_url from products p, products_description pd, manufacturers m, manufacturers_info mi left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '1' and m.manufacturer_featured = '1' order by rand() DESC limit 3
[TEP STOP]
| | |
