string(622) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 51.45615), 2) + pow(42.5*(classifieds.lon - -2.55600), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.45615' - 50/69.0) AND ('51.45615' + 50/69.0)) AND (classifieds.lon BETWEEN ('-2.55600' - 50/42.5) AND ('-2.55600' + 50/42.5)) AND classifieds.make = "seat" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.mpg >= 30 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '50'
"
string(924) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 51.45615), 2) + pow(42.5*(classifieds.lon - -2.55600), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.45615' - 50/69.0) AND ('51.45615' + 50/69.0)) AND (classifieds.lon BETWEEN ('-2.55600' - 50/42.5) AND ('-2.55600' + 50/42.5)) AND classifieds.make = "seat" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.mpg >= 30 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(622) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 51.45615), 2) + pow(42.5*(classifieds.lon - -2.55600), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.45615' - 90/69.0) AND ('51.45615' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.55600' - 90/42.5) AND ('-2.55600' + 90/42.5)) AND classifieds.make = "seat" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.mpg >= 30 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(924) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 51.45615), 2) + pow(42.5*(classifieds.lon - -2.55600), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.45615' - 90/69.0) AND ('51.45615' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.55600' - 90/42.5) AND ('-2.55600' + 90/42.5)) AND classifieds.make = "seat" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.mpg >= 30 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(622) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 51.45615), 2) + pow(42.5*(classifieds.lon - -2.55600), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.45615' - 90/69.0) AND ('51.45615' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.55600' - 90/42.5) AND ('-2.55600' + 90/42.5)) AND classifieds.make = "seat" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.mpg >= 21 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(924) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 51.45615), 2) + pow(42.5*(classifieds.lon - -2.55600), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.45615' - 90/69.0) AND ('51.45615' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.55600' - 90/42.5) AND ('-2.55600' + 90/42.5)) AND classifieds.make = "seat" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND classifieds.mpg >= 21 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(622) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 51.45615), 2) + pow(42.5*(classifieds.lon - -2.55600), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.45615' - 90/69.0) AND ('51.45615' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.55600' - 90/42.5) AND ('-2.55600' + 90/42.5)) AND classifieds.make = "seat" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 225000) AND classifieds.mpg >= 21 AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(924) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 51.45615), 2) + pow(42.5*(classifieds.lon - -2.55600), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.45615' - 90/69.0) AND ('51.45615' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.55600' - 90/42.5) AND ('-2.55600' + 90/42.5)) AND classifieds.make = "seat" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 225000) AND classifieds.mpg >= 21 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.45615), 2) + pow(42.5*(classifieds.lon - -2.55600), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.45615' - 90/69.0) AND ('51.45615' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.55600' - 90/42.5) AND ('-2.55600' + 90/42.5)) AND classifieds.make = "seat" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 225000) 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.45615), 2) + pow(42.5*(classifieds.lon - -2.55600), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('51.45615' - 90/69.0) AND ('51.45615' + 90/69.0)) AND (classifieds.lon BETWEEN ('-2.55600' - 90/42.5) AND ('-2.55600' + 90/42.5)) AND classifieds.make = "seat" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 225000) 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 30+ MPG Seat Cars For Sale In Redfield, Bristol With Less Than 150,000 Miles | Cheapmoto.co.uk
Seat arosa 1.4 2003 Automatic Runs and drives revs high sometimes as doesn't go into 4th but still driving, been told it could just need fluids topping up 4 good tyres Everything works Body not the best as you can see Cheap run around for someone Ideal learner car Full log book, part service history, mot till next year (end of march) £450 sold as seen no offers Collection only ready to drive away
ULEZ compliance,Looks and drive superb, alloys with new tyres,12 month mot,CD sound system ,two keys,Electric windows,Air condition,Cheap to run and insured as 1.4 engine,Ideal first car,Abosulutely reduced for clearance
Seat ibiza 1.4L SE 5dr Petrol hatchback in blue. No issues, being driven daily to and from work so mileage will go up. Has service history/receipts and all booklets, full service done in August 2025. Mot till Apr 2026, no advisories. New battery fitted in June 2025. The car is ULEZ free and comes with 2 keys. The bodywork is clean no dents or marks, well looked after, had car since July 2022. Please no timewasters. Will accept near offer
SEAT ALTEA XL + 1.9L DIESEL + MANUAL + SERVICE HISTORY + CRUISE CONTROL + CLOTH SEATS + BLUETOOTH CONNECTIVITY + ACCPETING PART EXCHANGES + DELIVERY AVAILABLE + ACCEPTING CARD PAYMENTS + WARRANTY AVAILABLE UPON REQUEST Cruise Control; Safety Belt Pretensioners
HPi clear 3 previous owners new MOT on purchase 2 keys ice cold air conditioning cruise control trip computer power steering remote central locking with full closure/opening electric windows and mirrors sport model new rear shocks cleaned egr NO DPF starts and drives perfectly up to 60 mpg warranty available T.