SELECT parentProd.*, IF(parentProd.`pd_offer_price`, parentProd.`pd_offer_price`, parentProd.`pd_price`) AS `price` FROM `mod_shop_product_parent` AS `parentProd`LEFT JOIN `mod_shop_product_child` AS childProd ON parentProd.`pd_id` = childProd.`pd_parent_id` LEFT JOIN `mod_shop_prod_cat` AS prodCat ON parentProd.`pd_id` = prodCat.`pdID` WHERE parentProd.`pd_hide` = 0 AND parentProd.`pd_status` = 'live' AND parentProd.`pd_start_date` < NOW() AND (parentProd.`pd_end_date` = 0 OR parentProd.`pd_end_date` > NOW()) ORDER BY RAND(), `pd_order` ASC
Array
(
)

SELECT parentProd.*, IF(parentProd.`pd_offer_price`, parentProd.`pd_offer_price`, parentProd.`pd_price`) AS `price` FROM `mod_shop_product_parent` AS `parentProd`LEFT JOIN `mod_shop_product_child` AS childProd ON parentProd.`pd_id` = childProd.`pd_parent_id` LEFT JOIN `mod_shop_prod_cat` AS prodCat ON parentProd.`pd_id` = prodCat.`pdID` WHERE parentProd.`pd_hide` = 0 AND parentProd.`pd_status` = 'live' AND parentProd.`pd_start_date` < NOW() AND (parentProd.`pd_end_date` = 0 OR parentProd.`pd_end_date` > NOW()) ORDER BY RAND(), `pd_order` ASC

cars-abstract.jpg [cars-abstract.jpg.webp]

Selling a Car

When you want to sell your car, our dealers will provide you with the best, fairest price for its condition, pay you in cash, and collect your vehicle from your property within an hour for a cash payment.

Sell Your Car
winter servicing image

Winter Servicing

  • Tyre Inspection
  • Battery Test
  • Coolant and Antifreeze Top-up
  • Windscreen Wiper Check
  • Lights Assessment
  • Oil and Filter Check
Book Now

Contact Us:

Fill out the form below and we will be in contact with you as soon as we can.

We look forward to hearing from you!