Search
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.
Get Our Latest Stock - Sent to your inbox
Milltown Lane,
Rathnew,
Co. Wicklow
| Mon - Sun: | Closed |
| Mon - Fri: | 8.30am - 5.00pm |
| Sat: | Closed |
| Sun: | Closed |
Copyright © MJ Motors 2026 All Rights Reserved Privacy Policy Terms & Conditions
Stock Alerts
Thanks!
We have sent a verification email to you. Please click on the verification link in this email to activate the alert.
Shortlist
Stock Alerts
select id,title,image_url,short_description,promotion_type,title_slug from c_blogs where dealer_id = 544 and promotion_type in ('mercedes promotion','seat promotion','cupra promotion','workshop promotion') order by id desc
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 = 'boc2'
order by b.id
limit 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 = 'boc2'
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
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
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/var/www/templates/BOC2/www/offers.blade.php{
"type": "workshop"
}{
"X-Amz-Cf-Id": "6-to88gTmI_kYGsM4L-urRAIGhSF5XAh0r_U_uBoe6YkNA_2Om5f1Q==",
"Via": "2.0 8561a26680f6afe2aa31e2d44e762026.cloudfront.net (CloudFront)",
"User-Agent": "Amazon CloudFront",
"Accept-Encoding": "gzip",
"X-Amzn-Trace-Id": "Root=1-698678dd-5aa2223362c3cbb05f4a8354",
"Host": "preview2rmbi7.happydealer.ie",
"X-Forwarded-Port": "443",
"X-Forwarded-Proto": "https",
"X-Forwarded-For": "216.73.216.14, 64.252.114.249",
"X-Hd-Debug": "",
"Content-Length": "",
"Content-Type": ""
}