"> ---> "> "> "> "> "> SELECT * FROM qryRelatedProducts WHERE PRODUCT_TYPE = 'ALTERNATE' ",Custom2)> newRow = QueryAddRow(qryTempResults2, 1); temp = QuerySetCell(qryTempResults2, "TOP_SELLER", #locTopSeller#); temp = QuerySetCell(qryTempResults2, "FEATURED", #locFeature#); temp = QuerySetCell(qryTempResults2, "VET_RECOMMENDED", #locVetRecommended#); temp = QuerySetCell(qryTempResults2, "GROUP_GUID", #Key#); temp = QuerySetCell(qryTempResults2, "TITLE", #trim(Title)#); temp = QuerySetCell(qryTempResults2, "BASE_SCORE", #locBaseScore#); temp = QuerySetCell(qryTempResults2, "SCORE", #locScore#); temp = QuerySetCell(qryTempResults2, "IMAGE", #locImage#); temp = QuerySetCell(qryTempResults2, "IMAGE_ALT", #locAlt#); temp = QuerySetCell(qryTempResults2, "IMAGE_HEIGHT", #locHeight#); temp = QuerySetCell(qryTempResults2, "IMAGE_WIDTH", #locWidth#); temp = QuerySetCell(qryTempResults2, "MANUFACTURER_NAME", #locManufacturerName#); temp = QuerySetCell(qryTempResults2, "CUSTOMIZE", #locCustomize#);
class="altrow">
#trim(locPGName)#
by #qryGetItems.Manufacturer_Name#
#qryGetItems.Product_Tagline#
 
This product is currently unavailable for purchase.
 
Product Alternatives:
#Group_Name# (#RELATED_PRODUCT#)
#trim(RELATED_DESCRIPTION)#
 
  Request Additional Information

 


Search
 



SELECT * FROM qryTempResults2 ORDER BY BASE_SCORE DESC, VET_RECOMMENDED DESC, FEATURED DESC, TOP_SELLER DESC, SCORE DESC
#locAlt#
#locGroupTitle#
by #locManufacturerName#
Vet Recommended Customize It!

SELECT BLUE_MESSAGE_USER FROM SW_USER WHERE SW_USER_GUID = '#locUserGUID#' SELECT DISTINCT SALE_DISPLAY_CODE FROM qryGetItems #trim(Product_Copy)#"> "> "> #locSpecialFlag#"> " & trim(Catalog_Item_Number) & ""> " & trim(Color_Description) & "">  "> " & trim(Size_Description) & "">  "> Call for availability"> No longer available"> Custom$"> SELECT REBATE_PRICE, IS_PERCENT, SHOPPING_FEED_BLOCK FROM qryRebate WHERE CATALOG_ITEM_NUMBER = '#trim(Catalog_Item_Number)#' #DollarFormat(locBasePrice)# "> NOW #DollarFormat(locBasePrice)#"> Everyday Low Price #DollarFormat(locBasePrice)#">  " & locPricingText & " "> #locPricingText#"> ","ALL")> Special Price!"> #locMultiPrice#"> Special Price!">  "> #trim(Catalog_item_number)##trim(Color_Description)# #trim(Size_Description)# #INT(UNIT_PER_BOX)#"> *FFC: " & DollarFormat(Additional_Shipping_Each) & ""> Quote"> AIR"> "> "> " & abs(Freight_On_Board_Weight) & "lbs#locExtraShip#"> " & abs(Freight_On_Board_Weight) & "lb#locExtraShip#"> #locTxtDisplay##locExtraShip#"> #locStockStatus#"> "> #locOptionText#"> SELECT IMAGE_PATH, SWATCH_DESCRIPTION FROM qrySwatches WHERE UPPER(DESCRIPTION_TYPE) != 'SI_IMAGES' AND LOWER(CATALOG_ITEM_NUMBER) = '#LCase(Catalog_Item_Number)#' AND ( (LOWER(IMAGE_CODE2) = '#LCase(Size_Code)#' AND LOWER(DESCRIPTION_TYPE) = 'size') OR (LOWER(IMAGE_CODE1) = '#LCase(Color_Code)#' AND LOWER(DESCRIPTION_TYPE) = 'color') OR (LOWER(IMAGE_CODE1) = '#LCase(Color_Code)#' AND LOWER(IMAGE_CODE2) = '#LCase(Size_Code)#' AND LOWER(DESCRIPTION_TYPE) = 'color_size') ) ORDER BY SORT_ORDER, SWATCH_DESCRIPTION SELECT IMAGE_NAME FROM qryGroupImage WHERE LOWER(CATALOG_ITEM_NUMBER) = '#LCase(Catalog_Item_Number)#' AND SORT_LETTER = 'A' ORDER BY SORT_ORDER, SORT_LETTER "> "> function isGUID(guid){ if (REfindNoCase("^[A-Z0-9]{8}-[A-Z0-9]{4}-[A-Z0-9]{4}-[A-Z0-9]{4}-[A-Z0-9]{12}$", guid) gt 0) { return true; } else { return false; } } "> SELECT PROMOTION_ID, PROMO_DESC, PROMO_TYPE FROM qryPromoCopy WHERE DISPLAY_CODE != 'B' AND PROMOTION_ID NOT IN (#PreserveSingleQuotes(locRebateIDs)#) ORDER BY PROMO_TYPE SELECT PROMOTION_ID, PROMO_TITLE, PROMO_IMAGE, ITEM_NUMBER FROM qryPromoCopy WHERE DISPLAY_CODE = 'B' ORDER BY PROMO_TITLE, PROMOTION_ID SELECT DISTINCT PRODUCT_GROUP_GUID FROM qryPriceGroup "> "> "> "> "> "> Up To"> Up To">

#showUpTo##locPricingMaxPer#% OFFMSRP

"> ">

#showUpTo##locPricingMaxPer#% OFF

">

#showUpTo#$#locPricingMaxDol# OFF

"> "> "> ">
"> "> "> "> "> --->
">
Let us contact your vet
","","ALL")>

#trim(locPGName)#

 #locPGNameImage#
Read Reviews | Write a review Read Reviews | Write a review
#qryGetItems.Product_Tagline#
(#qryGetItems.Manufacturer_Name#)  Look fashionable while expressing yourself when choosing the design and color of apron that is just right for you! These aprons are quality heavy-weight fabric. Care for your custom apron by laundering without a bleaching agent, using a mild detergent and warm water. Look fashionable while expressing yourself when choosing the design, style and color of #locShirtName1# that is just right for you! These #locShirtName2# are quality heavy-weight fabric. Care for your custom #locShirtName1# by laundering without a bleaching agent, using a mild detergent and warm water.
View style & colors.
#locProductCopy#
View bit level information.

#Site_Message#

Special pricing. Click here!

Click Add to Cart to customize.  See Customization tab below for details. Items marked out of stock can be ordered now and will ship separately when in stock.
#locCustom_OptionText#
  Item # Color/Style Size Price Qty Each Shipping Stock
Item Added to Cart!   View Cart/Checkout
*Shipping - See Shipping section on Information tab below for details. *(ds) - Ships in approximately #locLeadDayRange# day(s). See Shipping section on Information tab below for details. Need Help? Click here.
SELECT DISTINCT PRODUCT_TYPE, RELATED_DESCRIPTION, PRODUCT_GROUP_GUID, GROUP_NAME FROM qryRelatedProducts WHERE PRODUCT_TYPE IN (#PreserveSingleQuotes(locProdType)#)
#locHeader#:
#Group_Name#
#trim(RELATED_DESCRIPTION)#

E-mail: Notify Me
#trim(locNotifyConfirm)#

view #qryRegistry.First_Name#'s gift list
Gift Registry #qryRegistry.Registry_ID#
#qryRegistry.First_Name# #Left(qryRegistry.Last_Name,1)#. (#qryRegistry.Event_Type#)
Gift List
  • #trim(Catalog_Item_Number)# - #trim(color_desc)# #trim(size_desc)# Requested qty met.Qty(#Quantity_Remaining#)  - (#Item_Comment#)

  • To purchase an item for #qryRegistry.First_Name#, select the item above and click the Add to Cart button.

    This site requires that your cookies be turned on. Please see our help or contact us with any questions.
    Need Help? Click here.


     
    SELECT FILE_NAME_SERVER, LINK_TITLE FROM LIBRARY_FILE WHERE FILE_NAME_SERVER LIKE '%LABEL%' AND IS_VVET_ONLY = 0 AND IS_ACTIVE = 1 AND LIBRARY_GUID = '#getLibrary.Library_GUID#' ORDER BY LINK_TITLE ">
    #locCrossSellTitle#
    #Group_Name# By #Manufacturer_Name#
    Top Seller

    Customize It!

    Promotion Available
    #image_alt#