string(625) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.24328), 2) + pow(42.5*(classifieds.lon - -4.21298), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.24328' - 50/69.0) AND ('56.24328' + 50/69.0)) AND (classifieds.lon BETWEEN ('-4.21298' - 50/42.5) AND ('-4.21298' + 50/42.5)) AND classifieds.make = "citroen" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.mpg >= 20 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '50'
"
string(927) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.24328), 2) + pow(42.5*(classifieds.lon - -4.21298), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.24328' - 50/69.0) AND ('56.24328' + 50/69.0)) AND (classifieds.lon BETWEEN ('-4.21298' - 50/42.5) AND ('-4.21298' + 50/42.5)) AND classifieds.make = "citroen" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) 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(625) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.24328), 2) + pow(42.5*(classifieds.lon - -4.21298), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.24328' - 90/69.0) AND ('56.24328' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.21298' - 90/42.5) AND ('-4.21298' + 90/42.5)) AND classifieds.make = "citroen" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.mpg >= 20 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(927) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.24328), 2) + pow(42.5*(classifieds.lon - -4.21298), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.24328' - 90/69.0) AND ('56.24328' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.21298' - 90/42.5) AND ('-4.21298' + 90/42.5)) AND classifieds.make = "citroen" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) 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(625) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.24328), 2) + pow(42.5*(classifieds.lon - -4.21298), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.24328' - 90/69.0) AND ('56.24328' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.21298' - 90/42.5) AND ('-4.21298' + 90/42.5)) AND classifieds.make = "citroen" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.mpg >= 14 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(927) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.24328), 2) + pow(42.5*(classifieds.lon - -4.21298), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.24328' - 90/69.0) AND ('56.24328' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.21298' - 90/42.5) AND ('-4.21298' + 90/42.5)) AND classifieds.make = "citroen" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) 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(625) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.24328), 2) + pow(42.5*(classifieds.lon - -4.21298), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.24328' - 90/69.0) AND ('56.24328' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.21298' - 90/42.5) AND ('-4.21298' + 90/42.5)) AND classifieds.make = "citroen" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 225000) AND classifieds.mpg >= 14 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(927) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 56.24328), 2) + pow(42.5*(classifieds.lon - -4.21298), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.24328' - 90/69.0) AND ('56.24328' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.21298' - 90/42.5) AND ('-4.21298' + 90/42.5)) AND classifieds.make = "citroen" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 225000) 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(599) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 56.24328), 2) + pow(42.5*(classifieds.lon - -4.21298), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('56.24328' - 90/69.0) AND ('56.24328' + 90/69.0)) AND (classifieds.lon BETWEEN ('-4.21298' - 90/42.5) AND ('-4.21298' + 90/42.5)) AND classifieds.make = "citroen" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 225000) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
Cheap 20+ MPG Citroen Cars For Sale In Callander, Stirling And Falkirk With Less Than 150,000 Miles | Cheapmoto.co.uk
MOT until 13th November 2025 - Warranties available for purchase - Full v5 - Service history - Low miles for age - No knocks or bangs - Very reliable and economical car -Good mot history - A great car with with few exterior marks to be expected with age. - Interior is in good condition - Car is mechanically great - Engine, gearbox and clutch have all been looked after and function without fault. This car is priced to sell - Car gets very good town economy V5 ready to be changed over. Call us - Viewings welcome. Safety Belt Pretensioners
C4 hatchback 1.6 ehdi Manual 92k MOT until November £20 a year tax Panoramic roof Electric folding mirrors Cruise control Drives well Part dealership service history and some independent. A lot of car for little money. Some rust as shown in pictures, drivers window stopped working, probably needs a drop link and rear brake service, everything else works as should Only have new keepers slip but have email confirmation of v5c transfer and full receipt will be given. No time wasters, no group viewings and no test drives unless you have proof of insurance to drive other cars. £1100 strictly no offers so don't waste either of our time Located Hawick, Scottish Borders