string(816) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 55.95439), 2) + pow(42.5*(classifieds.lon - -4.92800), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.95439' - 50/69.0) AND ('55.95439' + 50/69.0)) AND (classifieds.lon BETWEEN ('-4.92800' - 50/42.5) AND ('-4.92800' + 50/42.5)) AND classifieds.make = "citroën" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 100000) AND NOT (MATCH(title) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR MATCH(description) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR title LIKE '%no mot%' OR description LIKE '%no mot%') AND expiry >= NOW() AND ingested = 1
"
string(1095) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 55.95439), 2) + pow(42.5*(classifieds.lon - -4.92800), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.95439' - 50/69.0) AND ('55.95439' + 50/69.0)) AND (classifieds.lon BETWEEN ('-4.92800' - 50/42.5) AND ('-4.92800' + 50/42.5)) AND classifieds.make = "citroën" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 100000) AND NOT (MATCH(title) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR MATCH(description) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR title LIKE '%no mot%' OR description LIKE '%no mot%') AND expiry >= NOW() AND ingested = 1
ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(816) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 55.95439), 2) + pow(42.5*(classifieds.lon - -4.92800), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.95439' - 90/69.0) AND ('55.95439' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.92800' - 90/42.5) AND ('-4.92800' + 90/42.5)) AND classifieds.make = "citroën" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 100000) AND NOT (MATCH(title) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR MATCH(description) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR title LIKE '%no mot%' OR description LIKE '%no mot%') AND expiry >= NOW() AND ingested = 1
"
string(1095) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 55.95439), 2) + pow(42.5*(classifieds.lon - -4.92800), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.95439' - 90/69.0) AND ('55.95439' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.92800' - 90/42.5) AND ('-4.92800' + 90/42.5)) AND classifieds.make = "citroën" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 100000) AND NOT (MATCH(title) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR MATCH(description) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR title LIKE '%no mot%' OR description LIKE '%no mot%') AND expiry >= NOW() AND ingested = 1
ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(816) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 55.95439), 2) + pow(42.5*(classifieds.lon - -4.92800), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.95439' - 90/69.0) AND ('55.95439' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.92800' - 90/42.5) AND ('-4.92800' + 90/42.5)) AND classifieds.make = "citroën" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND NOT (MATCH(title) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR MATCH(description) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR title LIKE '%no mot%' OR description LIKE '%no mot%') AND expiry >= NOW() AND ingested = 1
"
string(1095) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 55.95439), 2) + pow(42.5*(classifieds.lon - -4.92800), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.95439' - 90/69.0) AND ('55.95439' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.92800' - 90/42.5) AND ('-4.92800' + 90/42.5)) AND classifieds.make = "citroën" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND NOT (MATCH(title) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR MATCH(description) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR title LIKE '%no mot%' OR description LIKE '%no mot%') AND expiry >= NOW() AND ingested = 1
ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(816) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 55.95439), 2) + pow(42.5*(classifieds.lon - -4.92800), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.95439' - 90/69.0) AND ('55.95439' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.92800' - 90/42.5) AND ('-4.92800' + 90/42.5)) AND classifieds.make = "citroën" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND NOT (MATCH(title) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR MATCH(description) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR title LIKE '%no mot%' OR description LIKE '%no mot%') AND expiry >= NOW() AND ingested = 1
"
string(1095) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 55.95439), 2) + pow(42.5*(classifieds.lon - -4.92800), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('55.95439' - 90/69.0) AND ('55.95439' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.92800' - 90/42.5) AND ('-4.92800' + 90/42.5)) AND classifieds.make = "citroën" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND NOT (MATCH(title) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR MATCH(description) AGAINST('(+(mot m.o.t m.o.t.) +(fail failed expired "run out"))' IN BOOLEAN MODE) OR title LIKE '%no mot%' OR description LIKE '%no mot%') AND expiry >= NOW() AND ingested = 1
ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
Cheap Citroën Cars For Sale In Dunoon / Dùn Obhainn, Argyll And Bute With Less Than 100,000 Miles And Valid MOT | Cheapmoto.co.uk
MOT until 13th November 2025 - Warranties available for purchase - Full v5 - Service history - Low miles for age - No knocks or bangs - Very reliable and economical car -Good mot history - A great car with with few exterior marks to be expected with age. - Interior is in good condition - Car is mechanically great - Engine, gearbox and clutch have all been looked after and