string(880) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 51.73037), 2) + pow(42.5*(classifieds.lon - -3.13386), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.73037' - 50/69.0) AND ('51.73037' + 50/69.0)) AND (classifieds.lon BETWEEN ('-3.13386' - 50/42.5) AND ('-3.13386' + 50/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 40000) 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 classifieds.engine >= 1951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 2950) AND expiry >= NOW() AND ingested = 1
"
string(1159) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 51.73037), 2) + pow(42.5*(classifieds.lon - -3.13386), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.73037' - 50/69.0) AND ('51.73037' + 50/69.0)) AND (classifieds.lon BETWEEN ('-3.13386' - 50/42.5) AND ('-3.13386' + 50/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 40000) 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 classifieds.engine >= 1951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 2950) AND expiry >= NOW() AND ingested = 1
ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(880) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 51.73037), 2) + pow(42.5*(classifieds.lon - -3.13386), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.73037' - 90/69.0) AND ('51.73037' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.13386' - 90/42.5) AND ('-3.13386' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 40000) 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 classifieds.engine >= 1951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 2950) AND expiry >= NOW() AND ingested = 1
"
string(1159) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 51.73037), 2) + pow(42.5*(classifieds.lon - -3.13386), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.73037' - 90/69.0) AND ('51.73037' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.13386' - 90/42.5) AND ('-3.13386' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 40000) 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 classifieds.engine >= 1951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 2950) AND expiry >= NOW() AND ingested = 1
ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(880) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 51.73037), 2) + pow(42.5*(classifieds.lon - -3.13386), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.73037' - 90/69.0) AND ('51.73037' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.13386' - 90/42.5) AND ('-3.13386' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 60000) 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 classifieds.engine >= 1951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 2950) AND expiry >= NOW() AND ingested = 1
"
string(1159) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 51.73037), 2) + pow(42.5*(classifieds.lon - -3.13386), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.73037' - 90/69.0) AND ('51.73037' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.13386' - 90/42.5) AND ('-3.13386' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 60000) 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 classifieds.engine >= 1951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 2950) AND expiry >= NOW() AND ingested = 1
ORDER BY posted DESC, (title_match+desc_match) DESC LIMIT 0,20"
string(781) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 51.73037), 2) + pow(42.5*(classifieds.lon - -3.13386), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.73037' - 90/69.0) AND ('51.73037' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.13386' - 90/42.5) AND ('-3.13386' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 60000) 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(1060) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 51.73037), 2) + pow(42.5*(classifieds.lon - -3.13386), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.73037' - 90/69.0) AND ('51.73037' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.13386' - 90/42.5) AND ('-3.13386' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 60000) 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 2.0 - 2.9L Cars For Sale In Abertillery / Abertyleri, Gwent With Less Than 40,000 Miles And Valid MOT | Cheapmoto.co.uk
For sale very nice and cheap CHEVROLET AVEO 1.2 petrol. 2009 model. Only 4 previous owners. Fited with Air condition AC Electrick windows Power sterring Extremely economical and cheap to insure. Perfect car for new driver or delivery service. MOT 09.03.2026
For sale nissan Micra s k12 58890 miles just had full service plus new battery in nice condition all-round interior perfect no rips or marks 6 cd changer and radio just a few age related marks and one small dink as in pictures ideal first car12 months MOT first to see will buy no offers thanks
2008 Vauxhall Zafira Sri xp Minivan Driven 132,000 kilometres Zafira 1.8 Sri 9 months mot new clutch in January good condition has a scratch passenger side see pictures someone kindly done it and drove off if you are looking for a brand new car in immaculate condition please scroll on but if you are after a reliable car with 7 seats with a long mot with the usual marks you
Full service history, Discover the perfect blend of style, efficiency, and performance with the Vauxhall Corsa 1.2i 16v SXi Hatchback 3dr Petrol Manual, available at TT Motorgroup in Didcot, Oxfordshire. This sleek black beauty is not just a car it s a statement. With its modern design and sporty accents, the Corsa SXi exudes confidence on the road. Powered by a responsive 1.2