string(740) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 54.59195), 2) + pow(42.5*(classifieds.lon - -1.01953), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('54.59195' - 50/69.0) AND ('54.59195' + 50/69.0)) AND (classifieds.lon BETWEEN ('-1.01953' - 50/42.5) AND ('-1.01953' + 50/42.5)) AND classifieds.make = "citroen" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 50000) AND (classifieds.year IS NOT NULL AND (2025 - classifieds.year) >= 15) AND (classifieds.year IS NOT NULL AND (2025 - classifieds.year) <= 20) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '50'
"
string(1042) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 54.59195), 2) + pow(42.5*(classifieds.lon - -1.01953), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('54.59195' - 50/69.0) AND ('54.59195' + 50/69.0)) AND (classifieds.lon BETWEEN ('-1.01953' - 50/42.5) AND ('-1.01953' + 50/42.5)) AND classifieds.make = "citroen" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 50000) AND (classifieds.year IS NOT NULL AND (2025 - classifieds.year) >= 15) AND (classifieds.year IS NOT NULL AND (2025 - classifieds.year) <= 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(598) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 54.59195), 2) + pow(42.5*(classifieds.lon - -1.01953), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('54.59195' - 90/69.0) AND ('54.59195' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.01953' - 90/42.5) AND ('-1.01953' + 90/42.5)) AND classifieds.make = "citroen" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 50000) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(900) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 54.59195), 2) + pow(42.5*(classifieds.lon - -1.01953), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('54.59195' - 90/69.0) AND ('54.59195' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.01953' - 90/42.5) AND ('-1.01953' + 90/42.5)) AND classifieds.make = "citroen" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 50000) 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(598) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 54.59195), 2) + pow(42.5*(classifieds.lon - -1.01953), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('54.59195' - 90/69.0) AND ('54.59195' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.01953' - 90/42.5) AND ('-1.01953' + 90/42.5)) AND classifieds.make = "citroen" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 75000) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(900) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 54.59195), 2) + pow(42.5*(classifieds.lon - -1.01953), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('54.59195' - 90/69.0) AND ('54.59195' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.01953' - 90/42.5) AND ('-1.01953' + 90/42.5)) AND classifieds.make = "citroen" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 75000) 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(598) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 54.59195), 2) + pow(42.5*(classifieds.lon - -1.01953), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('54.59195' - 90/69.0) AND ('54.59195' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.01953' - 90/42.5) AND ('-1.01953' + 90/42.5)) AND classifieds.make = "citroen" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 75000) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(900) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 54.59195), 2) + pow(42.5*(classifieds.lon - -1.01953), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('54.59195' - 90/69.0) AND ('54.59195' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.01953' - 90/42.5) AND ('-1.01953' + 90/42.5)) AND classifieds.make = "citroen" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 75000) 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 Citroen Cars For Sale In Marske-by-the-Sea, North Yorkshire With Less Than 50,000 Miles | Cheapmoto.co.uk
Insurance Group 10, Franchise Approved, 2009 59 citroen c3 picasso 1.4 vtr plus in grey covered only 49000 miles , good condition inside and out , drives as it should , cheap to run and insure . very spacious and a higher from grond car for easy access, spec includes, front fog lights, alloy wheels, roof rails, remote central locking, electric windows, electric mirrors, aircon, cd/tuner/mp3 player , trip computer and much more part ex welcome warranties available