string(690) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 54.13480), 2) + pow(42.5*(classifieds.lon - -0.79633), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('54.13480' - 50/69.0) AND ('54.13480' + 50/69.0)) AND (classifieds.lon BETWEEN ('-0.79633' - 50/42.5) AND ('-0.79633' + 50/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.doors = 4 AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '50'
"
string(992) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 54.13480), 2) + pow(42.5*(classifieds.lon - -0.79633), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('54.13480' - 50/69.0) AND ('54.13480' + 50/69.0)) AND (classifieds.lon BETWEEN ('-0.79633' - 50/42.5) AND ('-0.79633' + 50/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.doors = 4 AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) 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(690) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 54.13480), 2) + pow(42.5*(classifieds.lon - -0.79633), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('54.13480' - 90/69.0) AND ('54.13480' + 90/69.0)) AND (classifieds.lon BETWEEN ('-0.79633' - 90/42.5) AND ('-0.79633' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.doors = 4 AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(992) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 54.13480), 2) + pow(42.5*(classifieds.lon - -0.79633), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('54.13480' - 90/69.0) AND ('54.13480' + 90/69.0)) AND (classifieds.lon BETWEEN ('-0.79633' - 90/42.5) AND ('-0.79633' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.doors = 4 AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) 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(690) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 54.13480), 2) + pow(42.5*(classifieds.lon - -0.79633), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('54.13480' - 90/69.0) AND ('54.13480' + 90/69.0)) AND (classifieds.lon BETWEEN ('-0.79633' - 90/42.5) AND ('-0.79633' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 225000) AND classifieds.doors = 4 AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(992) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 54.13480), 2) + pow(42.5*(classifieds.lon - -0.79633), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('54.13480' - 90/69.0) AND ('54.13480' + 90/69.0)) AND (classifieds.lon BETWEEN ('-0.79633' - 90/42.5) AND ('-0.79633' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 225000) AND classifieds.doors = 4 AND classifieds.engine >= 951 AND (classifieds.engine IS NOT NULL AND classifieds.engine <= 1950) 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(566) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 54.13480), 2) + pow(42.5*(classifieds.lon - -0.79633), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('54.13480' - 90/69.0) AND ('54.13480' + 90/69.0)) AND (classifieds.lon BETWEEN ('-0.79633' - 90/42.5) AND ('-0.79633' + 90/42.5)) AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 225000) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
Cheap 1.0 - 1.9L Cars For Sale In Malton, North Yorkshire With Less Than 150,000 Miles | Cheapmoto.co.uk
This Volkswagen Passat 1.9 TDI S is a part exchange we have got in that does not fit our retail criteria and is priced to go as seen. It starts and drives very well, it has 2 keys, a current MOT until 03 11 2025, however will come with a fresh MOT. Has a good partial service record with 9 recorded services, Last done by Kwik Fit at 103,116 miles on 04 11 2024. Timing belt and waterpump replaced at 61,394 miles on 14 01 2021 Safety Belt Pretensioners
Mazda 6, Clean car throughout, drives as it should, comes with MOT, Test drive available, Deposit secures, Full V5c present, service history V5 Registration Document; Safety Belt Pretensioners