Steel's Fudge

Steel's Fudge Online Store: Search Results For $10 and Below

Caramel Popcorn

Try our caramel popcorn as it has been a boardwalk staple for years.  There is nothing ...

Irish Potatoes

Steels Homemade Irish Potatoes.

...

Kookaburra Licorice - Assorted Box

Please try Kookaburra Licorice and satisfy your sweet tooth.  Bring back your childhood...

Red, White and Blue Vanilla Yogurt Doggie Treats

Order our delicious pet treats and your dog will love you that much more! These pet treats ...

Strawberry Laces

Delicious Red Shoe String licorice. 

...

Irish Potatoes

Try STEEL'S homemade Irish Potatoes.

...

Kookaburra Licorice – Red

Please try Kookaburra Licorice and satisfy your sweet tooth.  Bring back your childhood...

Kookaburra Licorice – Black

Please try Kookaburra Licorice and satisfy your sweet tooth.  Bring back your childhood...

Peanut

Select our world famous Peanut brittle and you will be in candy heaven. Try one of our britt...

Cashew

Select our world famous Cashew brittle and you will be in candy heaven. Try one of our britt...

Creamy Mint Sticks

Try our refreshing creamy mint sticks where you taste and feel a winter breeze across your t...

Fruit Flavored Licorice

Please try Fruit Flavored Licorice and satisfy your sweet tooth.  Bring back your child...

Mini Coconut

Order the delicious Mini Coconut macaroon and you will not be sorry.  These little slic...

Sugar Free Salt Water Variety Box

Select the assorted variety box of Sugar Free Salt Water Taffy which contains all of your fa...

Molasses Paddles

Please try Molasses Paddles and satisfy your sweet tooth.  Bring back your childhood me...

Mini Chocolate Covered

Order the delicious Mini Chocolate Covered macaroon and you will not be sorry.  These l...

Rainbow Whirly Pops

Please try Rainbow Whirly Pops and satisfy your sweet tooth.  Bring back your childhood...

Query
Template: /z_search.cfm:269
Execution Time: 16.7 ms
Record Count: 17
Cached: No
Lazy: No
SQL:
SELECT
item_2_cat_tb.is2c_cat1,
items_matrix_tb.i2z_price,
items_cat1_tb.i1_name,
items_tb.is_name,
items_tb.is_price,
items_tb.is_id,
items_tb.is_description,
items_tb.is_cat1,
items_tb.is_inactive,
items_tb.is_deleted,
items_tb.is_deleteddate,
items_tb.is_deletedby,
items_tb.is_dateadded,
items_tb.is_lastmodified,
items_tb.is_photo1,
items_tb.is_photo3,
items_tb.is_photo2,
items_tb.is_cat2,
items_tb.is_onsale,
items_tb.is_onsaleprice,
items_tb.is_type,
items_tb.is_coupon,
items_tb.is_coupontype,
items_tb.is_couponpercent,
items_tb.is_sortorder,
items_tb.is_couponcode,
items_tb.is_usship,
items_tb.is_worldship,
items_tb.is_saleexpdate,
items_tb.is_weight,
items_tb.is_length,
items_tb.is_height,
items_tb.is_width,
items_tb.is_cost,
items_tb.is_taxable,
items_tb.is_sku,
items_tb.is_manufacturer,
items_tb.is_catalogYear,
items_tb.is_divID,
items_tb.is_featured,
items_tb.is_apparel,
items_tb.is_fixedPrice,
items_tb.is_vendorCatID,
items_tb.is_color,
items_tb.is_noShipping,
items_tb.is_minimumOrderQty,
items_tb.is_itemFinePrint,
items_tb.is_flavor,
items_tb.is_size,
items_tb.is_details,
items_cat1_tb.i1_inactive
FROM
items_matrix_tb
RIGHT OUTER JOIN items_tb ON items_tb.is_id = items_matrix_tb.i2z_itemID
INNER JOIN item_2_cat_tb ON items_tb.is_id = item_2_cat_tb.is2c_item
INNER JOIN items_cat1_tb ON items_cat1_tb.i1_id = item_2_cat_tb.is2c_cat1
WHERE (items_tb.is_inactive NOT LIKE 1 AND
items_cat1_tb.i1_inactive = 0 AND
items_tb.is_deleted = 0)
AND ((i2z_price < 10) OR (is_price BETWEEN '10' AND '1'))
GROUP BY is_id
ORDER BY is2c_sortorder ASC, is_name ASC
is2c_cat1i2z_pricei1_nameis_nameis_priceis_idis_descriptionis_cat1is_inactiveis_deletedis_deleteddateis_deletedbyis_dateaddedis_lastmodifiedis_photo1is_photo3is_photo2is_cat2is_onsaleis_onsalepriceis_typeis_couponis_coupontypeis_couponpercentis_sortorderis_couponcodeis_usshipis_worldshipis_saleexpdateis_weightis_lengthis_heightis_widthis_costis_taxableis_skuis_manufactureris_catalogYearis_divIDis_featuredis_apparelis_fixedPriceis_vendorCatIDis_coloris_noShippingis_minimumOrderQtyis_itemFinePrintis_flavoris_sizeis_detailsi1_inactive
1126.99PopcornCaramel Popcorn052<p>Try our caramel popcorn as it has been a boardwalk staple for years.&nbsp; There is nothing sweeter than having a small tub of caramel popcorn on the boardwalk on a warm summer evening!</p>00{ts '2014-03-17 17:08:47'}{ts '2014-09-27 10:06:24'}caramel_popcorn.jpg00000000{ts '2014-09-28 00:00:00'}01110110000
2156.99CandiesIrish Potatoes 0155<p>Steels Homemade Irish Potatoes.</p>00{ts '2020-02-06 21:23:07'}{ts '2020-12-02 13:43:49'}ishpotato.jpgishpotato-148x148.jpg00000000001001000<p>Purchase these handmade treats today. These coconut cream base rolled in cinnimon &amp; cocoa powder make the perfect treat.</p>0
3156.99CandiesKookaburra Licorice - Assorted Box0138<p>Please try Kookaburra Licorice and satisfy your sweet tooth.&nbsp; Bring back your childhood memories of the good old days, when these candies were at your local corner store, and don't forget some for your friends and loved ones.</p>00{ts '2014-06-22 15:49:43'}{ts '2014-08-13 14:25:22'}Kookaburra_Assorted.jpg0000000001110110000
4105.49Yogurt Pet TreatsRed, White and Blue Vanilla Yogurt Doggie Treats047<p>Order our delicious pet treats and your dog will love you that much more! These pet treats also make a great gift for those that you know who love their dogs and pets as much as you.</p>00{ts '2014-03-16 14:43:06'}{ts '2014-03-20 11:33:28'}yogurt_dog_treats.jpg0000000001110110000
5154.25CandiesStrawberry Laces0151<p>Delicious Red Shoe String licorice.&nbsp;</p>00{ts '2016-06-03 18:44:35'}{ts '2020-06-04 11:46:01'}IMG_0062.JPGIMG_0062-148x148.JPG00000000001001000<p>Try our delicious Red shoe String Licorice. These wonderingful tasting laces will keep you coming back for more. black laces also available Please indicate in special instructions if you prefer Black laces.</p>0
676.99Turtles & Other FavoritesIrish Potatoes0150<p>Try STEEL'S homemade Irish Potatoes.</p>30{ts '2015-03-02 17:02:27'}{ts '2021-08-06 22:00:30'}ishpotato.jpgishpotato-148x148.jpg00000000001001000<p>Try STEEL'S homemade Irish Potatoes today. These delicious coconut/cinnamon treats are a St. Patricks holiday favorite.</p>0
7157.99CandiesKookaburra Licorice – Red0114<p>Please try Kookaburra Licorice and satisfy your sweet tooth.&nbsp; Bring back your childhood memories of the good old days, when these candies were at your local corner store, and don't forget some for your friends and loved ones.</p>00{ts '2014-04-21 15:59:08'}{ts '2014-08-13 14:25:29'}Kookaburra_red.jpg000000001110110000
8157.99CandiesKookaburra Licorice – Black0116<p>Please try Kookaburra Licorice and satisfy your sweet tooth.&nbsp; Bring back your childhood memories of the good old days, when these candies were at your local corner store, and don't forget some for your friends and loved ones.</p>00{ts '2014-04-21 16:01:37'}{ts '2014-08-13 14:25:38'}Kookaburra_black.jpg000000001110110000
945.49BrittlesPeanut034<p>Select our world famous Peanut brittle and you will be in candy heaven. Try one of our brittles and you will want to try them all. You can buy in half pound and pound containers and please remember to offer some to family and friends!!!</p>00{ts '2014-03-16 14:28:06'}{ts '2014-05-01 01:36:26'}peanut_brittle.jpg0000000001110110010
1046.49BrittlesCashew035<p>Select our world famous Cashew brittle and you will be in candy heaven. Try one of our brittles and you will want to try them all. You can buy in half pound and pound containers and please remember to offer some to family and friends!!!</p>00{ts '2014-03-16 14:28:15'}{ts '2014-05-01 01:36:40'}cashew_brittle.jpg0000000001110110010
1127.99Salt Water TaffyCreamy Mint Sticks0140<p>Try our refreshing creamy mint sticks where you taste and feel a winter breeze across your taste buds.&nbsp; They are shaped and easily eaten like a piece of taffy, but have a creamy texture and are a pure mint pleasure!</p>00{ts '2014-06-26 12:55:16'}{ts '2016-05-17 16:45:00'}creamyMintSticks.jpg0000000001110110000
12156.99CandiesFruit Flavored Licorice0115<p>Please try Fruit Flavored Licorice and satisfy your sweet tooth.&nbsp; Bring back your childhood memories of the good old days, when these candies were at your local corner store, and don't forget some for your friends and loved ones. Assorted Flavors</p>30{ts '2014-04-21 16:01:30'}{ts '2020-10-01 10:40:29'}FruitFlavoredLic.jpg0000000001110110000
1336.99MacaroonsMini Coconut031<p>Order the delicious Mini Coconut macaroon and you will not be sorry.&nbsp; These little slices of heaven are sure to satisfy the sweet tooth and bring a smile to the person who is eating them!</p>30{ts '2014-03-16 14:18:44'}{ts '2019-12-08 21:47:20'}mini_cocount_macaroon.jpg0000000001110110000
1426.99Salt Water TaffySugar Free Salt Water Variety Box0135<p>Select the assorted variety box of Sugar Free Salt Water Taffy which contains all of your favorites from the shore.&nbsp; Our Salt Water Taffy y is guaranteed to satisfy your sweet tooth and leave you wanting for more.</p>00{ts '2014-04-30 22:02:32'}{ts '2014-07-25 11:56:06'}photo 3.JPGphoto 3-148x148.JPG0000000001110110000
15156.99CandiesMolasses Paddles0118<p>Please try Molasses Paddles and satisfy your sweet tooth.&nbsp; Bring back your childhood memories of the good old days, when these candies were at your local corner store, and don't forget some for your friends and loved ones.</p>00{ts '2014-04-21 16:01:51'}{ts '2019-09-21 09:26:59'}MolassesPaddles.jpg000000001110110000
1636.99MacaroonsMini Chocolate Covered033<p>Order the delicious Mini Chocolate Covered macaroon and you will not be sorry.&nbsp; These little slices of heaven are sure to satisfy the sweet tooth and bring a smile to the person who is eating them!</p>30{ts '2014-03-16 14:19:01'}{ts '2019-12-08 21:47:53'}mini_chocolate_macaroon.jpg0000000001110110000
17156.99CandiesRainbow Whirly Pops0127<p>Please try Rainbow Whirly Pops and satisfy your sweet tooth.&nbsp; Bring back your childhood memories of the good old days, when these candies were at your local corner store, and don't forget some for your friends and loved ones.</p>00{ts '2014-04-29 15:46:12'}{ts '2014-08-13 14:23:05'}whirlly_pop.jpg000000001110110000
Steel's Fudge | 2719 Boardwalk | Atlantic City, NJ 08401 | (609) 345-4051
Steel’s Fudge Caramel Fudge Delight
steel's fudge instagram
Facebook
Twitter