string(594) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 51.92993), 2) + pow(42.5*(classifieds.lon - -1.72238), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.92993' - 75/69.0) AND ('51.92993' + 50/69.0)) AND (classifieds.lon BETWEEN ('-1.72238' - 75/42.5) AND ('-1.72238' + 50/42.5)) AND classifieds.make = "citroën" AND classifieds.model = "c3 picasso" AND classifieds.mpg >= 50 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '50'
"
string(896) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 51.92993), 2) + pow(42.5*(classifieds.lon - -1.72238), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.92993' - 75/69.0) AND ('51.92993' + 50/69.0)) AND (classifieds.lon BETWEEN ('-1.72238' - 75/42.5) AND ('-1.72238' + 50/42.5)) AND classifieds.make = "citroën" AND classifieds.model = "c3 picasso" AND classifieds.mpg >= 50 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(596) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 51.92993), 2) + pow(42.5*(classifieds.lon - -1.72238), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.92993' - 135/69.0) AND ('51.92993' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.72238' - 135/42.5) AND ('-1.72238' + 90/42.5)) AND classifieds.make = "citroën" AND classifieds.model = "c3 picasso" AND classifieds.mpg >= 50 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(898) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 51.92993), 2) + pow(42.5*(classifieds.lon - -1.72238), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.92993' - 135/69.0) AND ('51.92993' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.72238' - 135/42.5) AND ('-1.72238' + 90/42.5)) AND classifieds.make = "citroën" AND classifieds.model = "c3 picasso" AND classifieds.mpg >= 50 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(596) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 51.92993), 2) + pow(42.5*(classifieds.lon - -1.72238), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.92993' - 135/69.0) AND ('51.92993' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.72238' - 135/42.5) AND ('-1.72238' + 90/42.5)) AND classifieds.make = "citroën" AND classifieds.model = "c3 picasso" AND classifieds.mpg >= 35 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(898) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 51.92993), 2) + pow(42.5*(classifieds.lon - -1.72238), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.92993' - 135/69.0) AND ('51.92993' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.72238' - 135/42.5) AND ('-1.72238' + 90/42.5)) AND classifieds.make = "citroën" AND classifieds.model = "c3 picasso" AND classifieds.mpg >= 35 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(570) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 51.92993), 2) + pow(42.5*(classifieds.lon - -1.72238), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.92993' - 135/69.0) AND ('51.92993' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.72238' - 135/42.5) AND ('-1.72238' + 90/42.5)) AND classifieds.make = "citroën" AND classifieds.model = "c3 picasso" AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(872) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 51.92993), 2) + pow(42.5*(classifieds.lon - -1.72238), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.92993' - 135/69.0) AND ('51.92993' + 90/69.0)) AND (classifieds.lon BETWEEN ('-1.72238' - 135/42.5) AND ('-1.72238' + 90/42.5)) AND classifieds.make = "citroën" AND classifieds.model = "c3 picasso" 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 Economical (50+ MPG) Citroën C3 Picasso Cars For Sale In Stow-on-the-Wold, Gloucestershire | Cheapmoto.co.uk
Cheap Economical (50+ MPG) Citroën C3 Picasso Cars For Sale In Stow-on-the-Wold, Gloucestershire
1 Cheap Economical (50+ MPG) Citroën C3 Picasso Cars For Sale In Stow-on-the-Wold, Gloucestershire
Looking for economical cars with 50+ mpg? These vehicles are perfect for saving on fuel costs while reducing your environmental impact. High-mileage cars often include efficient diesel, hybrid, or small petrol engines designed for long journeys and city driving. When searching for 50+ mpg cars, consider factors like maintenance history, overall condition, and running costs to ensure long-term savings. Make sure to compare models and check fuel economy ratings carefully. Always see the car in person and inspect it thoroughly to confirm it meets your expectations.
STARTS AND DRIVES FINE - HPI CLEAR - 3 FORMER KEEPERS - BODY WORK ISNâ?¬T THE BEST & HAS MARKS ALL OVER - NO WARRANTY - TRADE SALE Safety Belt Pretensioners