INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='0' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_categories.avail = 'Y' AND xcart_products.forsale='Y' GROUP BY xcart_products.productid

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/powercle/public_html/store/include/func.php on line 102
Carpet Cleaning Equipment & Carpet Cleaning Machine :: Power Clean Industries
  Product Search: 
 
  + Advanced
Power Clean Industries > General Info


Finlease - We'll get the finance so you can get on with business

Equipment Finance Australia Wide

As a premier Finance Brokering firm in Australia, FINLEASE has been active in the Finance Industry for over 18 years. Accredited with majority of financiers, FINLEASE is a major finance provider to a this industry. With an annual turnover of over $300 million we are able to effectively source the most appropriate finance package for your requirement.

Finance is a SERVICE industry an d money is no different to any other product or service required by companies. It should be obtained at the right price, in the best structure, with least amount of constraints and conditions and delivered on time in a hassle free manner with NO STRINGS ATTACHED .

FINLEASE is now poised to utilize its funding expertise, commitment to service, in conjunction with POWERCLEAN INDUSTRIES AUSTRALIA to provide you with a competitive financial package on the entire range of cleaning machines offered by POWERCLE AN.

At FINLEASE, we often put in place “pre approved” lines of credit for our clients to cover future anticipated finance requirements. We arrange the facility, deliver the approval and then you decide if and when to use it. Finance is ready for you when need it. There is NO EXTRA COSTS to have this facility and if you don't ultimately use all or part of it, that  is acceptable also.

Finlease - The Total Solution.

Contact Amit Choksi on 0409 264 222 or email him at amit@finlease.com.au for further details.

"We'll get you the finance, so you can get on with business"

Download The Finance Calulator