Finance
At MJ Motors we have a dedicated Finance Team who will shop around our panel of lenders.
Almost every car is available to finance, so when you find the car you like, finance options will be displayed.
35 years in business
A Family Run Business
Over 45,000 Happy Customers
Over 400+ Cars on Site
At MJ Motors we have a dedicated Finance Team who will shop around our panel of lenders.
Almost every car is available to finance, so when you find the car you like, finance options will be displayed.
TFSI E QUATTRO S LINE BLACK EDITION
| 2.0 Hybrid (unspecified) | Hatchback | Automatic | 56 km |
2.2 TD Speciale 180BHP 4DR AUT
| 2.1 Diesel | Saloon | Automatic | 60,000 km |
2.2 TD Speciale 180BHP 4DR AUT
| 2.1 Diesel | Saloon | Automatic | 60,000 km |
2.2 TD Speciale 180BHP 4DR AUT
| 2.1 Diesel | Saloon | Automatic | 60,000 km |
With Hire Purchase you pay for the car in a series of monthly payments. At the end of the term, after all payments and the option to purchase fee is made you take full ownership of the vehicle.
Would you like to pay for your vehicle in full? Or do you already have finance arranged? Search for your perfect car according to your total budget here.
Keep up to date
with our latest stock!
Milltown Lane
Rathnew
Co. Wicklow
| Mon - Sun: | Closed |
We are Closed on Bank Holidays.
| Mon: | 9:30am - 4:30pm |
| Tue - Thu: | 9:30am - 5:30pm |
| Fri: | 9:30am - 4:30pm |
| Sat - Sun: | Closed |
Aftersales is Closed for Lunch from 1pm to 2pm.
Aftersales does not operate on any Bank Holidays.
Copyright © MJ Motors 2026 All Rights Reserved Privacy Policy Terms & Conditions
Thanks!
We have sent a verification email to you. Please click on the verification link in this email to activate the alert.
select text_key, value from c_dealer_site_texts where dealer_id = 544
select
d.display_name,
d.id,
d.use_display_name_for_consent,
d.group_id,
g.name as group_name,
d.facebook_id,
d.facebook_url,
d.youtube_id,
d.youtube_link,
d.twitter_link,
d.instagram_link,
d.linkedin_link,
d.tiktok_url,
d.is_simi,
d.use_km,
d.email_enquiries,
d.opening_hours_extra_text,
d.reservation_days,
d.reservation_option,
d.finance_default_deposit_pct,
d.use_google_reviews,
d.google_reviews_link,
d.google_reviews_avg_rating,
d.google_reviews_total,
d.finance_start_with_personal_details,
d.principal,
d.principal_title,
d.slug,
d.allow_html_description,
d.finance_default_hp_rate,
d.finance_default_pcp_rate,
d.payment_provider,
d.payment_secret_key_enc,
d.square_access_token_enc,
d.square_location_id,
da.address1,
da.address2,
da.address3,
da.address4,
da.address5,
da.postcode,
da.map_lat,
da.map_long,
da.map_zoom,
r.country_code,
r.region,
if (d.reservation_new_option = 0, null, rp.cost_to_reserve) as cost_to_reserve_new
from c_dealers d
left join c_groups g on g.id = d.group_id
left join c_dealer_addresses da on da.dealer_id = d.id
left join c_country_regions r on da.region_id = r.id
left join c_reservation_prices rp on d.reservation_new_price_id = rp.id
where d.id = 544
select
name,
phone,
email,
is_primary_contact
from c_dealer_website_contacts
where dealer_id = 544
and hide_on_website = 0
order by sort_key
select
h.dow,
h.open,
h.closed,
h.optional_text
from c_dealer_hours h
where h.dealer_id = 544
order by 1
select
a.id,
a.s3_image,
a.main_image_id,
ai.template_id,
a.reg_year,
a.price,
a.mileage,
mk.make,
md.model
from c_ads a
inner join c_makes mk on a.make_id = mk.id
inner join c_models md on a.model_id = md.id
left join c_ad_images ai on a.main_image_id = ai.id
where dealer_id = 544
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
and is_dealer_special = 1
select
b.home_title_tag,
b.home_meta_desc,
b.other_title_tag,
b.other_meta_desc,
b.about_us_short,
b.map_key,
ifnull(ifnull(b.map_company_name, b.display_name), d.display_name) as name_for_map,
ba.country_code,
ba.region_id,
ba.address1,
ba.address2,
ba.address3,
ba.address4,
ba.address5,
ba.postcode,
ba.map_lat,
ba.map_long,
ba.map_zoom,
ba.phone,
r.country_code,
r.region
from c_dealer_site_briefs b
inner join c_dealers d on b.dealer_id = d.id
left join c_dealer_site_brief_addresses ba on b.id = ba.brief_id
left join c_country_regions r on ba.region_id = r.id
where d.id = 544
and b.dealer_tag = 'mjmotors'
order by b.id
limit 1SELECT -- featured cars 544
a.id,
a.description,
a.price,
a.s3_image,
a.previous_price,
a.reg_year,
if (ifnull(a.make_text, '') != '', a.make_text, mk.make) as make,
if (ifnull(a.model_text, '') != '', a.model_text, md.model) as model,
a.variant,
a.owners,
a.test_due_date,
a.mileage,
a.kilometres,
a.updated_at,
a.engine_cc,
a.key_location,
ceil( ifnull(fin.monthly_payments, a.finance_price_per_month) ) as finance_price_per_month,
fin.apr as apr,
DATE_FORMAT(a.expires_at,'%r on %d/%m/%Y') AS expiry_date,
f.fuel_type,
t.transmission_type,
b.body_type,
c.rgb_hex,
c.colour,
a.main_image_id,
ai.template_id,
a.youtube_id,
a.video_type,
a.video_id,
d.location_name,
d.location_name,
ct.display as cylinders,
ceil(a.finance_price_per_month_pcp) as finance_price_per_month_pcp,
a.dealer_id as ad_dealer_id,
if(ifnull(a.reservation_id, 0), 1, 0) as is_reserved,
exists (select 1 from c_ad_extra_properties aep where aep.ad_id = a.id) as has_extras,
(SELECT COUNT(*) FROM c_ad_images ai2 WHERE ai2.ad_id = a.id AND ai2.deleted_at IS NULL) AS image_count
FROM c_ads a
INNER JOIN c_models md ON a.model_id = md.id
INNER JOIN c_makes mk ON a.make_id = mk.id
INNER JOIN c_transmission_types t ON a.transmission_type_id = t.id
INNER JOIN c_fuel_types f ON a.fuel_type_id = f.id
INNER JOIN c_ad_images ai ON a.main_image_id = ai.id
INNER JOIN c_dealers d on a.dealer_id = d.id
left join c_cylinder_types ct on a.cylinder_type_id = ct.id
left join c_ad_finance_calc_results fin on a.id = fin.ad_id and fin.is_default_term and fin.is_default
LEFT JOIN c_body_types b ON a.body_type_id = b.id
LEFT JOIN c_colours c ON a.colour_id = c.id
WHERE a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
and a.dealer_id = 544
AND a.highlighted_sort_key IS NOT NULL
ORDER BY highlighted_sort_key
LIMIT 8SELECT -- featured cars 544
a.id,
a.description,
a.price,
a.s3_image,
a.previous_price,
a.reg_year,
if (ifnull(a.make_text, '') != '', a.make_text, mk.make) as make,
if (ifnull(a.model_text, '') != '', a.model_text, md.model) as model,
a.variant,
a.owners,
a.test_due_date,
a.mileage,
a.kilometres,
a.updated_at,
a.engine_cc,
a.key_location,
ceil( ifnull(fin.monthly_payments, a.finance_price_per_month) ) as finance_price_per_month,
fin.apr as apr,
DATE_FORMAT(a.expires_at,'%r on %d/%m/%Y') AS expiry_date,
f.fuel_type,
t.transmission_type,
b.body_type,
c.rgb_hex,
c.colour,
a.main_image_id,
ai.template_id,
a.youtube_id,
a.video_type,
a.video_id,
d.location_name,
d.location_name,
ct.display as cylinders,
ceil(a.finance_price_per_month_pcp) as finance_price_per_month_pcp,
a.dealer_id as ad_dealer_id,
if(ifnull(a.reservation_id, 0), 1, 0) as is_reserved,
exists (select 1 from c_ad_extra_properties aep where aep.ad_id = a.id) as has_extras,
(SELECT COUNT(*) FROM c_ad_images ai2 WHERE ai2.ad_id = a.id AND ai2.deleted_at IS NULL) AS image_count
FROM c_ads a
INNER JOIN c_models md ON a.model_id = md.id
INNER JOIN c_makes mk ON a.make_id = mk.id
INNER JOIN c_transmission_types t ON a.transmission_type_id = t.id
INNER JOIN c_fuel_types f ON a.fuel_type_id = f.id
INNER JOIN c_ad_images ai ON a.main_image_id = ai.id
INNER JOIN c_dealers d on a.dealer_id = d.id
left join c_cylinder_types ct on a.cylinder_type_id = ct.id
left join c_ad_finance_calc_results fin on a.id = fin.ad_id and fin.is_default_term and fin.is_default
LEFT JOIN c_body_types b ON a.body_type_id = b.id
LEFT JOIN c_colours c ON a.colour_id = c.id
WHERE a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
AND a.highlighted_sort_key IS NULL
AND a.main_image_id IS NOT NULL
AND a.reg_year < 2026
and a.dealer_id = 544
ORDER BY price DESC
LIMIT 8
SELECT
r.id,
r.review,
r.reviewer_name,
'' as reviewer_location,
DATE_FORMAT(r.reviewed_at, '%d/%m/%Y') AS created_at,
DATE_FORMAT(r.reviewed_at, '%d/%m/%Y') AS updated_at,
r.rating,
r.dealer_id
FROM c_dealer_reviews_external r
WHERE provider = 'Google'
AND r.dealer_id = 544
ORDER BY reviewed_at DESC LIMIT 0,3
SELECT
id,
COUNT(rating) total_num,
SUM(rating) total_sum
FROM c_dealer_reviews
WHERE STATUS = 'live'
AND dealer_id = 544SELECT DISTINCT
mk.make,
mk.id AS make_id
FROM c_ads a
INNER JOIN c_makes mk ON a.make_id = mk.id
WHERE a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
AND a.dealer_id = '544'
ORDER BY mk.make;SELECT
year(now()) - trading_since as years_in_business,
trading_since_date,
total_cars_sold,
total_reviews,
total_cars_for_sale,
youtube_id
from c_dealers
where id = 544Select * from c_body_types
SELECT SQL_CALC_FOUND_ROWS
a.id,
a.s3_image,
a.description,
a.price,
a.previous_price,
CEIL(fin.monthly_payments) AS monthly_payments,
fin.apr AS apr,
a.reg_year,
IF(IFNULL(a.make_text, '') != '', a.make_text, mk.make) AS make,
IF(IFNULL(a.model_text, '') != '', a.model_text, md.model) AS model,
a.variant,
a.owners,
a.test_due_date,
a.mileage,
a.kilometres,
a.updated_at,
a.engine_cc,
a.doors,
a.seats,
a.youtube_id,
a.video_type,
a.video_id,
a.s3_image,
CEIL(a.finance_price_per_month_pcp) AS finance_price_per_month_pcp,
a.key_location,
CEIL(a.finance_price_per_month) AS finance_price_per_month,
a.fuel_cons_combined,
DATE_FORMAT(a.expires_at, '%r on %d/%m/%Y') AS expiry_date,
a.external_ad_id,
ai.id AS image_id,
ai.template_id,
f.fuel_type,
t.transmission_type,
b.body_type,
c.rgb_hex,
c.colour,
r.region,
l.address1,
l.address2,
l.address3,
d.location_name,
ct.display as cylinders,
a.dealer_id AS ad_dealer_id,
IF(IFNULL(reservation_id, 0), 1, 0) AS is_reserved,
fin.id AS finid,
EXISTS (SELECT 1 FROM c_ad_extra_properties aep WHERE aep.ad_id = a.id) AS has_extras,
(SELECT COUNT(*) FROM c_ad_images ai2 WHERE ai2.ad_id = a.id AND ai2.deleted_at IS NULL) AS image_count
FROM c_ads a
INNER JOIN c_dealers d ON a.dealer_id = d.id
INNER JOIN c_models md ON a.model_id = md.id
INNER JOIN c_makes mk ON a.make_id = mk.id
LEFT JOIN c_ad_finance_calc_results fin ON a.id = fin.ad_id
LEFT JOIN c_groups g ON d.group_id = g.id
LEFT JOIN c_transmission_types t ON a.transmission_type_id = t.id
LEFT JOIN c_fuel_types f ON a.fuel_type_id = f.id
LEFT JOIN c_ad_images ai ON a.main_image_id = ai.id
LEFT JOIN c_body_types b ON a.body_type_id = b.id
LEFT JOIN c_colours c ON a.colour_id = c.id
LEFT JOIN c_dealer_addresses l ON a.dealer_id = l.dealer_id
left join c_cylinder_types ct on a.cylinder_type_id = ct.id
INNER JOIN c_country_regions r ON l.region_id = r.id
WHERE ( fin.deposit_and_trade_in is null or (fin.is_default and fin.is_default_term) )
AND a.expires_at > now()
AND a.paused_at is null
AND a.deleted_at is null
AND a.web_sale_id IS NULL
AND a.dealer_id = 544 order by concat(mk.make,' ',md.model), (ifnull(a.price,0)=0),a.price DESC
LIMIT 0, 48SELECT FOUND_ROWS()select -- mtd_makes 544
mk.id, mk.make
from c_makes mk
inner join c_ads a on a.make_id = mk.id
inner join c_dealers d on a.dealer_id = d.id
where a.dealer_id = 544
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
GROUP BY mk.id, mk.make
order by mk.make
select -- mtd_fuel_types 544
t.id,t.fuel_type
from c_fuel_types t
inner join c_ads a on a.fuel_type_id = t.id
inner join c_dealers d on a.dealer_id = d.id
where a.dealer_id = 544
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
group by t.id,t.fuel_type
order by t.sort_key
select distinct -- mtd_prices 544
FLOOR (a.price) price
from c_ads a
inner join c_dealers d on a.dealer_id = d.id
where a.dealer_id = 544
and a.price is not null
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
and price > 0
order by a.price
SELECT r.id, r.review, r.reviewer_name, r.reviewer_location, r.STATUS, r.created_at, r.updated_at, r.rating, r.dealer_id
FROM c_dealer_reviews r
WHERE r.STATUS = 'live'
AND r.dealer_id = 544
ORDER BY r.created_at DESC limit 1
SELECT
id,
COUNT(rating) total_num,
SUM(rating) total_sum
FROM c_dealer_reviews
WHERE STATUS = 'live'
AND dealer_id = 544 [CACHED]
select
b.home_title_tag,
b.home_meta_desc,
b.other_title_tag,
b.other_meta_desc,
b.about_us_short,
b.map_key,
ifnull(ifnull(b.map_company_name, b.display_name), d.display_name) as name_for_map,
ba.country_code,
ba.region_id,
ba.address1,
ba.address2,
ba.address3,
ba.address4,
ba.address5,
ba.postcode,
ba.map_lat,
ba.map_long,
ba.map_zoom,
ba.phone,
r.country_code,
r.region
from c_dealer_site_briefs b
inner join c_dealers d on b.dealer_id = d.id
left join c_dealer_site_brief_addresses ba on b.id = ba.brief_id
left join c_country_regions r on ba.region_id = r.id
where d.id = 544
and b.dealer_tag = 'mjmotors'
order by b.id
limit 1 [CACHED]
select
b.home_title_tag,
b.home_meta_desc,
b.other_title_tag,
b.other_meta_desc,
b.about_us_short,
b.map_key,
ifnull(ifnull(b.map_company_name, b.display_name), d.display_name) as name_for_map,
ba.country_code,
ba.region_id,
ba.address1,
ba.address2,
ba.address3,
ba.address4,
ba.address5,
ba.postcode,
ba.map_lat,
ba.map_long,
ba.map_zoom,
ba.phone,
r.country_code,
r.region
from c_dealer_site_briefs b
inner join c_dealers d on b.dealer_id = d.id
left join c_dealer_site_brief_addresses ba on b.id = ba.brief_id
left join c_country_regions r on ba.region_id = r.id
where d.id = 544
and b.dealer_tag = 'mjmotors'
order by b.id
limit 1 [CACHED]select -- mtd_makes 544
mk.id, mk.make
from c_makes mk
inner join c_ads a on a.make_id = mk.id
inner join c_dealers d on a.dealer_id = d.id
where a.dealer_id = 544
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
GROUP BY mk.id, mk.make
order by mk.make [CACHED]
select -- mtd_body_types 544
t.id,t.body_type
from c_body_types t
inner join c_ads a on a.body_type_id = t.id
inner join c_dealers d on a.dealer_id = d.id
where a.dealer_id = 544
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
group by t.id,t.body_type
order by t.body_type
select -- mtd_fuel_types 544
t.id,t.fuel_type
from c_fuel_types t
inner join c_ads a on a.fuel_type_id = t.id
inner join c_dealers d on a.dealer_id = d.id
where a.dealer_id = 544
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
group by t.id,t.fuel_type
order by t.sort_key
[CACHED]
select -- mtd_transmission_types 544
t.id,t.transmission_type
from c_transmission_types t
inner join c_ads a on a.transmission_type_id = t.id
inner join c_dealers d on a.dealer_id = d.id
where a.dealer_id = 544
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
group by t.id,t.transmission_type
order by t.transmission_type
SELECT deposit FROM c_finance_deposits ORDER BY deposit
SELECT max(price)
FROM c_ads a
INNER JOIN c_dealers d on a.dealer_id = d.id
WHERE a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
AND a.dealer_id = 544
SELECT min(price)
FROM c_ads a
INNER JOIN c_dealers d on a.dealer_id = d.id
WHERE a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
AND a.dealer_id = 544/var/www/core/www/index.php/var/www/templates/MJMOTORS/www/index.php/var/www/templates/MJMOTORS/www/index.blade.php{
"Accept-Encoding": "br,gzip",
"Via": "2.0 b7a454c5d7e9ad8ba2aca6a02bb25f14.cloudfront.net (CloudFront)",
"User-Agent": "Mozilla\/5.0 AppleWebKit\/537.36 (KHTML, like Gecko; compatible; ClaudeBot\/1.0; +claudebot@anthropic.com)",
"Accept": "*\/*",
"X-Amz-Cf-Id": "Sucv8Hksw9XqKiIkHLfRdy8ZUvekRlm68n-O0vVXttYTK4WlZodqig==",
"X-Amzn-Trace-Id": "Root=1-6aa83d11-0bf176dd571b8aab04c075da",
"Host": "preview2rmbi7.happydealer.ie",
"X-Forwarded-Port": "443",
"X-Forwarded-Proto": "https",
"X-Forwarded-For": "216.73.216.197, 64.252.77.126",
"X-Hd-Debug": "",
"Content-Length": "",
"Content-Type": ""
}