Internet Explorer users please use the submit button

SELECT ref, field9 FROM "tbl_index entries" where "index 1e" like '%#product#%' or "index 2e" like '%#product#%' or "index 3e" like '%#product#%' or "index 4e" like '%#product#%' or "index 5e" like '%#product#%' or "index 6e" like '%#product#%'

We found #productsearch.Recordcount# record(s) containing #product#

#productsearch.field9# Click here for more details
SELECT "model no" as modelno, page, "description 1" as desc1, "description 2" as desc2 FROM "searchmodel" where "model no" like '%#product#%'

We found #searchmodelno.Recordcount# record(s)

The item was not found in our buyer's guide
but please call 1-800-661-2400 to inquire about availability

 SELECT "Mfg", page, "description 1" as desc1, "description 2" as desc2 FROM "searchmodel" where "mfg" like '%#product#%'

We found #searchmodelno.Recordcount# record(s)
#searchmodelno.modelno# #desc1# #desc2# Page. #searchmodelno.page#

The item was not found in our buyer's guide
but please call 1-800-661-2400 to inquire about availability

 SELECT "Vendor","Brand","Mfg", "model no" as modelno, page, "description 1" as desc1, "description 2" as desc2 FROM "searchmodel" where "vendor" like '%#product#%' or "brand" like '%#product#%'

We found #searchmodelno.Recordcount# record(s)
#searchmodelno.mfg# #desc1# #desc2# Page. #searchmodelno.page#

The item was not found in our buyer's guide
but please call 1-800-661-2400 to inquire about availability

 SELECT "model no" as modelno, page, "description 1" as desc1, "description 2" as desc2 FROM searchmodel WHERE cat = '#url.cat#'

We found #searchmodelno.Recordcount# record(s)
#searchmodelno.modelno# #desc1# #desc2# Page. #searchmodelno.page#

The item was not found in our buyer's guide
but please call 1-800-661-2400 to inquire about availability

 SELECT "model no" as modelno, page, "description 1" as desc1, "description 2" as desc2 FROM searchmodel WHERE ref = #url.ref#

We found #searchmodelno.Recordcount# record(s)
#searchmodelno.modelno# #desc1# #desc2# Page. #searchmodelno.page#

The item was not found in our buyer's guide
but please call 1-800-661-2400 to inquire about availability



#searchmodelno.modelno# #desc1# #desc2# #searchmodelno.page#