string(633) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 53.70382), 2) + pow(42.5*(classifieds.lon - -0.87130), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.70382' - 50/69.0) AND ('53.70382' + 50/69.0)) AND (classifieds.lon BETWEEN ('-0.87130' - 50/42.5) AND ('-0.87130' + 50/42.5)) AND classifieds.make = "vauxhall" AND classifieds.model = "zafira" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 100000) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '50'
"
string(935) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 53.70382), 2) + pow(42.5*(classifieds.lon - -0.87130), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.70382' - 50/69.0) AND ('53.70382' + 50/69.0)) AND (classifieds.lon BETWEEN ('-0.87130' - 50/42.5) AND ('-0.87130' + 50/42.5)) AND classifieds.make = "vauxhall" AND classifieds.model = "zafira" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 100000) 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(633) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 53.70382), 2) + pow(42.5*(classifieds.lon - -0.87130), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.70382' - 90/69.0) AND ('53.70382' + 90/69.0)) AND (classifieds.lon BETWEEN ('-0.87130' - 90/42.5) AND ('-0.87130' + 90/42.5)) AND classifieds.make = "vauxhall" AND classifieds.model = "zafira" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 100000) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(935) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 53.70382), 2) + pow(42.5*(classifieds.lon - -0.87130), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.70382' - 90/69.0) AND ('53.70382' + 90/69.0)) AND (classifieds.lon BETWEEN ('-0.87130' - 90/42.5) AND ('-0.87130' + 90/42.5)) AND classifieds.make = "vauxhall" AND classifieds.model = "zafira" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 100000) 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(633) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 53.70382), 2) + pow(42.5*(classifieds.lon - -0.87130), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.70382' - 90/69.0) AND ('53.70382' + 90/69.0)) AND (classifieds.lon BETWEEN ('-0.87130' - 90/42.5) AND ('-0.87130' + 90/42.5)) AND classifieds.make = "vauxhall" AND classifieds.model = "zafira" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(935) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 53.70382), 2) + pow(42.5*(classifieds.lon - -0.87130), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.70382' - 90/69.0) AND ('53.70382' + 90/69.0)) AND (classifieds.lon BETWEEN ('-0.87130' - 90/42.5) AND ('-0.87130' + 90/42.5)) AND classifieds.make = "vauxhall" AND classifieds.model = "zafira" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) 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(633) "SELECT COUNT(*) AS count,
sqrt(pow(69*(classifieds.lat - 53.70382), 2) + pow(42.5*(classifieds.lon - -0.87130), 2)) AS distance
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.70382' - 90/69.0) AND ('53.70382' + 90/69.0)) AND (classifieds.lon BETWEEN ('-0.87130' - 90/42.5) AND ('-0.87130' + 90/42.5)) AND classifieds.make = "vauxhall" AND classifieds.model = "zafira" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) AND expiry >= NOW() AND ingested = 1
HAVING distance <= '90'
"
string(935) "SELECT classifieds.*,
classifieds.seller as user_name,
NULL as user_email,
NULL as seller_id,
sqrt(pow(69*(classifieds.lat - 53.70382), 2) + pow(42.5*(classifieds.lon - -0.87130), 2)) AS distance , 0 AS title_match, 0 AS desc_match
FROM classifieds
WHERE 1 AND (classifieds.lat BETWEEN ('53.70382' - 90/69.0) AND ('53.70382' + 90/69.0)) AND (classifieds.lon BETWEEN ('-0.87130' - 90/42.5) AND ('-0.87130' + 90/42.5)) AND classifieds.make = "vauxhall" AND classifieds.model = "zafira" AND (classifieds.mileage >= 10000 AND classifieds.mileage <= 150000) 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 Vauxhall Zafira Cars For Sale In Goole, East Riding Of Yorkshire With Less Than 100,000 Miles | Cheapmoto.co.uk
FREE DELIVERY ON ALL VEHICLES - IN SUPERB CONDITION FOR ITS AGE - LONG MOT - HPI CLEAR - SERVICE HISTORY - 2 KEYS - CHEAP 7 SEATER - WARRANTIES AVAILABLE - ALL PART EXCHANGE WELCOME REGARDLESS OF AGE AND CONDITION - TEST DRIVES AND MECHANICAL INSPECTIONS WELCOME - CONTACT US ON 07392216265! Safety Belt Pretensioners
The 2012 Vauxhall Zafira 1.6 CDTi ecoFLEX Design Euro 5 5dr MPV Diesel Manual is a spacious and efficient vehicle with a practical body type suitable for transporting a large number of passengers. Bought an automatic for partner who cannot drive a manual. 3 cars within the home hence surplus to requirement. This Vauxhall Zafira also has a valid MOT until January 2026, making
Insurance Group 17, 2 Previous Owners, 2006 VAUXHALL ZAFIRA 2.2 CLUB PETROL AUTOMATIC MPV IN RED, FREE DELIVERY WITHIN 30 MILES (NATIONWIDE AT ADDITIONAL COST) ULEZ COMPLIANT, 3 OWNERS, MOT UNTIL MARCH 2026, 134,000 MILES FROM NEW, RUNS AND DRIVES, PART EXCHANGE TO CLEAR, ALL OUR PART EXCHANGE TO CLEAR CARS ARE SOLD FOR SPARES OR REPAIRS PURPOSES ONLY DUE TO AGE/MILEAGE, CD