oing it!!!!

ci-nui:[1457]-cnui:[1457]-anui:[1457]-fosr:[0]-perpage:[20]-numfilters:[]-foscount:[0]-equalanui:[1]-snui:[]-asnui:[]
select * from (select @reta:=1 AS reta, a.item_order as corder, a.item_id, a.availoption, a.item_code, a.item_order, a.item_ship_cat, a.cat2order, a.cat3order, a.cat4order, a.cat5order, a.incat2, a.incat3, a.incat4, a.incat5, a.isgroup, a.timeadded, a.timeupdated, a.in_cat, a.item_name, a.item_price_online, CASE WHEN(a.isgroup = 1) THEN a.item_price_online ELSE @groupprice := 0 END AS groupprice, CASE WHEN(a.isgroup = 1) THEN b.item_price_online ELSE @groupmemberprice := 0 END AS groupmemberprice, CASE WHEN(a.isgroup = 1) THEN @singleitemprice := 0 ELSE a.item_price_online END AS singleitemprice, CASE WHEN(a.isgroup = 1) THEN (SELECT MIN(b.item_price_online)FROM items b where ((a.item_id=b.ingroup) AND ((b.item_display=1)AND (!(b.availability = 'HideFromLists')))) ) ELSE a.item_price_online END AS ordprice, CASE WHEN(a.isgroup = 1) THEN b.ingroup ELSE @ingroup := 0 END AS groupmemberingroup FROM items a left join items b on b.ingroup = a.item_id AND a.isgroup=1 AND b.ingroup>0 where (a.in_cat IN(111) OR a.incat2 IN(111) OR a.incat3 IN(111) OR a.incat4 IN(111) OR a.incat5 IN(111) ) AND CASE WHEN(a.isgroup = 1)AND(b.ingroup>0) THEN ((((a.item_display=1)AND (!(a.availability = 'HideFromLists')))AND((b.item_display=1)AND (!(b.availability = 'HideFromLists')))) AND(b.ingroup = a.item_id) AND(b.item_price_online > 0)) ELSE (((a.item_display=1)AND (!(a.availability = 'HideFromLists')))AND((a.isgroup = 0)AND(a.ingroup=0))AND(a.item_price_online>0)) END ) suba group by item_id order by availoption ASC, case when incat2 in(111) then cat2order when incat3 in(111) then cat3order when incat4 in(111) then cat4order when incat5 in(111) then cat5order else item_order end ASC , timeupdated DESC, timeadded DESC, item_id DESC LIMIT 480, 20;Happy Endings - Adopt | Happy Paws Haven

General Enquiry[popupcont_prodenq1.p][formcode:genenq()]General Enquiry[popupcont_prodenq1.p][formcode:genenq()]General Enquiry (genenq) - [petenq1.]

Your message was not sent. (09:12:48 11-7-2026) Please correct the problems and try again. (09:12:48 11-7-2026)

Close

Close

Your message was sent successfully. (09:12:48 11-7-2026) We will be in touch ASAP - Thank you! (09:12:48 11-7-2026)

Close

Close

We will SHOW this div on success!

usecontactformcode:D[genenq]
thiscontactformcode:D[]
contactformcode:D[]
contactformdata[id]:D[9]09:12:48 11-7-2026

General Enquiry [C: INCS/d7-custommessageform_inc_popup] [we will now be loading:custommessageform_general_enquiry.php]

Close Reset formMessage AagainSend Message

Set Shipping Destination- To see shipping costs, set your destination, or select pick-up.Set Suburb/CityORPick Up from warehouse

Remind in 1 minRemind in 1 hour

Remind in 1 minRemind in 1 hour

OK to Checkout- When you are finished adding items to your order, please proceed to checkout.Go to Checkout

Remind in 1 minRemind in 1 hour

Remind in 1 minRemind in 1 hour

Order OK to Submit- When you are finished adding items to your order, please proceed to checkout.Go to Checkout

Remind in 1 minRemind in 1 hour

Remind in 1 minRemind in 1 hour

Shipping Weight exceeded

The total weight of this order exceeds what can be calculated automatically. You may remove some items from your order, save them for later, or choose to Pick Up or your order. Alternatively please contact us to discuss your requirements.Click here to contact us

Remind in 1 minRemind in 1 hour

Remind in 1 minRemind in 1 hour

Item limit exceeded

The total number of products in your order exceeds the maximum that can be processed automatically. You may remove some items from your order, or save them for later. Alternatively, .Click here to contact us

Remind in 1 minRemind in 1 hour

Remind in 1 minRemind in 1 hour

For all enquiries please phone0419 404 766Main number (Sally Rogers)ORMessage UsFast Enquiry

For all enquiries please phone0419 404 766Main number (Sally Rogers)ORMessage UsFast Enquiry

AccountSign in 0/0$0.00Set Shipping$0.00Checkout$0.00

enquiry call us contact menu

Set Your Shipping DestinationSet Your Shipping DestinationSet Your Shipping Destination

Currently showing Shipping to

Currently selected option isPick Up from Warehouse

Shipping Cost:$0.00

Please either enter a shipping Suburb/City or select Pick Up

Step 1: Choose Delivery or Pickup

SelectedDeliverySelectedPick Up

You have selected to pick up your order. No shipping details are needed. Thank you.

Step 2: Enter shipping destination

Shipping Destination

Suburb/City:

Not Set

To Enter a new suburb/city, please start typing into the field below then select from the list.

Street number and Street name:

Not Set

This is OptionalIt is not necessary to enter your Street Name and Street Number if you only want to see shipping prices. If you do not enter it now we will ask for it at the checkout.To enter a Street Number and Street Name, type it into the box below.

Example:23/101 Smith Streetor50 Sunrise Drive

Save this address

You can save this address for later use by selecting an option from this list.

Change Shipping Destination

Please choose your shipping options.

Choose Saved Shipping Address

To set your delivery address please enter your street and number below.
Current Street Address: Please provide shipping Street Name and Street Number Current Shipping Suburb/City: None Selected Current Shipping Service: Standard Shipping (Our choice of courier)

Please wait

C

C

xv1 started msgnotces for contactformcodea:[]

Your message was not sent. (09:12:48 11-7-2026) Please correct the problems and try again. (09:12:48 11-7-2026)

[xcv1 (errormsgcontent) ++ - msgnotices]

Close

Close

Your message was sent successfully. (09:12:48 11-7-2026) We will be in touch ASAP - Thank you! (09:12:48 11-7-2026)

(xv1 done in msgnotices.p )

Close

Close

Adopt

Adopt a Dog Adopt a Cat Happy Endings Why Adopt The Adoption Process

Help Our Paws Help Their Paws

Happy Endings

xcv1[prodnav_view_normal]

Products In Category: 1457total

481-500of1457results

See all results on one page

Previous Page Next Page

does not exist

Help Our Paws Help Their Paws

Keep Informed!

Keep updated with our newsletter...

Search Comclean Australia

Search the Comclean Australia Ltd website

Load Info: Client IP: 18.97.14.87TotalTime: 1614ms Load Status: [Executed](1614ms)