string(853) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.10963), 2) + pow(42.5*(classifieds.lon - -3.16334), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.10963' - 50/69.0) AND ('56.10963' + 50/69.0)) AND (classifieds.lon BETWEEN ('-3.16334' - 50/42.5) AND ('-3.16334' + 50/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 125000) AND (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.mpg >= 20 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '50'
"
string(1155) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.10963), 2) + pow(42.5*(classifieds.lon - -3.16334), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.10963' - 50/69.0) AND ('56.10963' + 50/69.0)) AND (classifieds.lon BETWEEN ('-3.16334' - 50/42.5) AND ('-3.16334' + 50/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 125000) AND (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.mpg >= 20 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(853) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.10963), 2) + pow(42.5*(classifieds.lon - -3.16334), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.10963' - 90/69.0) AND ('56.10963' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.16334' - 90/42.5) AND ('-3.16334' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 125000) AND (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.mpg >= 20 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(1155) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.10963), 2) + pow(42.5*(classifieds.lon - -3.16334), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.10963' - 90/69.0) AND ('56.10963' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.16334' - 90/42.5) AND ('-3.16334' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 125000) AND (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.mpg >= 20 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(853) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.10963), 2) + pow(42.5*(classifieds.lon - -3.16334), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.10963' - 90/69.0) AND ('56.10963' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.16334' - 90/42.5) AND ('-3.16334' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 125000) AND (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.mpg >= 14 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(1155) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.10963), 2) + pow(42.5*(classifieds.lon - -3.16334), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.10963' - 90/69.0) AND ('56.10963' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.16334' - 90/42.5) AND ('-3.16334' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 125000) AND (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.mpg >= 14 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(853) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.10963), 2) + pow(42.5*(classifieds.lon - -3.16334), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.10963' - 90/69.0) AND ('56.10963' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.16334' - 90/42.5) AND ('-3.16334' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 187500) AND (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.mpg >= 14 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(1155) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.10963), 2) + pow(42.5*(classifieds.lon - -3.16334), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.10963' - 90/69.0) AND ('56.10963' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.16334' - 90/42.5) AND ('-3.16334' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 187500) AND (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.mpg >= 14 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(827) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.10963), 2) + pow(42.5*(classifieds.lon - -3.16334), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.10963' - 90/69.0) AND ('56.10963' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.16334' - 90/42.5) AND ('-3.16334' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 187500) AND (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(1129) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.10963), 2) + pow(42.5*(classifieds.lon - -3.16334), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.10963' - 90/69.0) AND ('56.10963' + 90/69.0)) AND (classifieds.lon BETWEEN ('-3.16334' - 90/42.5) AND ('-3.16334' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 187500) AND (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 20+ MPG MOT Failure Cars For Sale In Kirkcaldy, Fife With Less Than 125,000 Miles | Cheapmoto.co.uk
Cheap 20+ MPG MOT Failure Cars For Sale In Kirkcaldy, Fife With Less Than 125,000 Miles
2 Cheap 20+ MPG MOT Failure Cars For Sale In Kirkcaldy, Fife With Less Than 125,000 Miles
Searching for a cheap car without an MOT can save you money upfront, as these vehicles are usually priced significantly lower than those with a valid MOT certificate. Buying a "No MOT" car is ideal for mechanics, enthusiasts, or anyone planning repairs or restoration. However, it’s important to be aware that these cars haven't passed the mandatory safety and emissions tests, so they may require costly repairs or might not be roadworthy immediately. Always factor in potential repair costs and legal requirements before purchasing. Be sure to view the car in person and conduct a thorough inspection before making your decision.
Selling my BMW Z3 for spares or repair / as a project. I bought it last year to put back on the road but never got around to it and it's a shame to just see it sitting. Starts and runs (although it needs a new battery). I can show it running. No MOT or Tax. It's been off the road since July 2022. I've not had it properly checked over so don't know what it will need for an MOT. I do know that a front brake pipe has burst, it sounds like there is a blow in the exhaust and there is a hole in a sill cover / skirt (whole skirt bolts on so you can get a replacement in the same colour instead of welding). The body work is good for the year / for being 25 years old (it's dirty in the photos, I'll try wash it soon). The roof is good, although the plastic rear window has cracked with age, although it zips on so could be easily replaced without having to replace the whole roof. Good spec: red leather interior, alloys, electric windows, cd player, front fog lights etc. Will be a stunning car when put back on the road. Not many of these left and widely considered to be a modern classic. Full v5 in my name and comes with the original wallet/ booklets. It will need towed away with a straight bar or recovered away due to the burst brake pipe. Great project for £595! No lower offers please as it's worth more in parts.
Being sold as spares!! (Accepting offers). Put off road due to MOT. Engine, gearbox, ALMOST NEW CLUTCH, brakes and suspension are all in fantastic condition!! Please double check your spam folder if you get in touch!! All emails I receive with offers initially went to my spam folder and I suspect my responses may be doing the same. Please check spam/junk folders if you get in
2008 Nissan Note 1.4 Acenta 5dr MOT JUNE 2026. Ulez compliant. MPV Petrol Manual Trade in to clear, Mot June, 5dr, 1.4, ulez £ 995.00 Make Nissan Model Note Year 2008 Transmission Manual Fuel Petrol Engine Size 1,386 ccm Mileage 144,088 Miles Emission class 150 A wee trade in to clear, Nissan Note 1.4 Acenta model. Ulez compliant, Euro 4. Mot 8 June 2025. Full V5. 5 door