string(825) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 52.96955), 2) + pow(42.5*(classifieds.lon - -2.68417), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('52.96955' - 50/69.0) AND ('52.96955' + 50/69.0)) AND (classifieds.lon BETWEEN ('-2.68417' - 50/42.5) AND ('-2.68417' + 50/42.5)) AND classifieds.make = "citroën" AND classifieds.model = "c2" 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
HAVING distance <= '50'
"
string(1127) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 52.96955), 2) + pow(42.5*(classifieds.lon - -2.68417), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('52.96955' - 50/69.0) AND ('52.96955' + 50/69.0)) AND (classifieds.lon BETWEEN ('-2.68417' - 50/42.5) AND ('-2.68417' + 50/42.5)) AND classifieds.make = "citroën" AND classifieds.model = "c2" 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
GROUP BY classifieds.id
HAVING distance <= '50' ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(825) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 52.96955), 2) + pow(42.5*(classifieds.lon - -2.68417), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('52.96955' - 90/69.0) AND ('52.96955' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.68417' - 90/42.5) AND ('-2.68417' + 90/42.5)) AND classifieds.make = "citroën" AND classifieds.model = "c2" 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
HAVING distance <= '90'
"
string(1127) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 52.96955), 2) + pow(42.5*(classifieds.lon - -2.68417), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('52.96955' - 90/69.0) AND ('52.96955' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.68417' - 90/42.5) AND ('-2.68417' + 90/42.5)) AND classifieds.make = "citroën" AND classifieds.model = "c2" 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
GROUP BY classifieds.id
HAVING distance <= '90' ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(825) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 52.96955), 2) + pow(42.5*(classifieds.lon - -2.68417), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('52.96955' - 90/69.0) AND ('52.96955' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.68417' - 90/42.5) AND ('-2.68417' + 90/42.5)) AND classifieds.make = "citroën" AND classifieds.model = "c2" 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
HAVING distance <= '90'
"
string(1127) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 52.96955), 2) + pow(42.5*(classifieds.lon - -2.68417), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('52.96955' - 90/69.0) AND ('52.96955' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.68417' - 90/42.5) AND ('-2.68417' + 90/42.5)) AND classifieds.make = "citroën" AND classifieds.model = "c2" 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
GROUP BY classifieds.id
HAVING distance <= '90' ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
Cheap Citroën C2 Cars For Sale In Whitchurch, Shropshire With Valid MOT | Cheapmoto.co.uk
⭐CITROEN C2 1.4 DIESEL MANUAL⭐ ✅MOT:- MARCH 2026 ✅TAX:- £35/ YEAR ✅HPI CLEAR ✅VERY CHEAP TO RUN, TAX AND INSURE. ✅IDEAL FIRST CAR. ✅STARTS AND DRIVES AS IT SHOULD. DISCOUNTED NATIONWIDE DELIVERY. VIEWING BY APPOINTMENT ONLY. CALL TO ARRANGE VEWING. P/X WELCOME AT TRADE VALUE. Safety Belt Pretensioners
Sadly having to sell my little car. It’s got full service history and belonged to a husband and wife, before myself. They had it from new. It’s only £35 per year road tax. It drives well and the body work is in nice condition. It’s very economical. Mot until November. Registered in my name and address. Any inspection. I’m actually in Bradford, not Halifax. I moved over a year ago but unable to change address on here. £900 ono