Ford Focus* (5 deurs) (2004 - 2008)

5,6 uit 11 beoordelingen

Prijs: 19.000

  

Vergelijk Ford Focus* 1.4 ambiente 59kW met ...

Vergelijk Ford Focus* 1.4 ambiente 59kW met ...

toevoegen
Model/productFord Focus* (5 deurs) (2004 - 2008)Ford Fiesta* (5 deurs) (2005 - 2009) 
UitvoeringFord Focus* 1.4 ambiente 59kW
Wijzig uitvoering
Ford Fiesta* 1.4i ambiente 59kW
Wijzig uitvoering
 
Laagste prijzen
       
      Prijs

       
      Consumentenprijs 19.000,00 14.910,00 
      Prijs exclusief BTW 16.564,00 12.982,00 
      BPM 3.740,00 2.834,00 
      Kosten rijklaar maken 600,00 605,00 
      Milieu / verbruik

       
      BrandstofetiketBC 
      Verbruik 120 km/u5,4 l/100km5,1 l/100km 
      Verbruik stad8,7 l/100km8,6 l/100km 
      CO2 uitstoot159 g/km147 g/km 
      Brandstofloodvrije benzineloodvrije benzine 
      Gecombineerd verbruik6,6 l/100km6,2 l/100km 
      Motor

       
      Cilinderinhoud1.388 cc1.388 cc 
      Aantal cilinders44 
      Kleppen per cilinder44 
      BrandstofsysteemMPIMPI 
      Compressieverhouding1111 
      Prestaties

       
      Topsnelheid164 km/u167 km/u 
      Acceleratie 0-100 km/u14,1 sec13,2 sec 
      Vermogen59 kW59 kW 
      Vermogen (tpm)5.7005.700 
      Koppel125 Nm124 Nm 
      Koppel (tpm)3.5003.500 
      Aandrijving / onderstel

       
      Versnellingsbak55 
      Aandrijvingvoorwielvoorwiel 
      Velgmaat1514 
      Banden achter195/65175/65 
      Banden voor195/65175/65 
      Remmen achterschijftrommel 
      Remmen voorschijfschijf 
      Afmetingen

       
      Lengte4.342 mm3.918 mm 
      Breedte1.991 mm1.905 mm 
      Hoogte1.497 mm1.432 mm 
      Tankinhoud55 liter45 liter 
      Spoorbreedte achter1.531 mm1.434 mm 
      Spoorbreedte voor1.535 mm1.464 mm 
      Wielbasis2.640 mm2.486 mm 
      Inhoud bagageruimte min385 liter284 liter 
      Inhoud bagageruimte max1.245 liter947 liter 
      Draaicirkel10,4 m9,3 m 
      Garantie

       
      Garantie algemeen2 jaar2 jaar 
      Garantie carrosserie12 jaar12 jaar 
      Garantie lak2 jaar2 jaar 
      Olie verversen..10.000 km 
      Grote beurt20.000 km20.000 km 
      Carrosserie

       
      Carrosserrievormhbhb 
      Aantal deuren55 
      Opties

       
      Airconditioning 0,00 900,00 
      Boordcomputer.. 295,00 
      Dakdragers.. 139,00 
      Lichtmetalen velgen 600,00.. 
      Luidsprekers..1 
      Metallic lak 600,00 525,00 
      Parkdistance control achter.. 450,00 
      Radio/cassette 400,00 0,00 
      Radio/CD-speler 600,00 300,00 
      Regensensor.. 295,00 
      Schuifdak electrisch 900,00.. 
      Schuifdak handbediening.. 550,00 
      Spiegels electrisch.. 295,00 
      Spiegels verwarmd.. 295,00 
      Stoelen verwarmd.. 200,00 
      Traction Control 800,00.. 
      Verwarmde voorruit.. 250,00 
      Airbags hoofd 0,00 300,00 
      Overig

       
      Gross Vehicle Weight1.710 kg1.520 kg 
      Rijklaar gewicht1.147 kg1.001 kg 
      Maximum laadvermogen463 kg429 kg 
      Aanhanger ongeremd620 kg500 kg 
      Aanhanger geremd700 kg900 kg 
      Database:0,479 (80) Solr: 0 Other: 0,346 Total: 0,825
      
      -- Query took 0,008sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = '149174' 
      
      -- Query took 0,001sec
      SELECT * FROM subCategories WHERE id = 86
      
      -- Query took 0,001sec
      SELECT * FROM ProductVersions WHERE id = '468792'
      
      -- Query took 0,002sec
      SELECT * FROM youtube WHERE productId = 149174
      
      -- Query took 0,001sec
      SELECT * FROM categories WHERE internalKey = 'auto'
      
      -- Query took 0,001sec
      SELECT html FROM htmlCache WHERE id = '733275db82037029ddbacf091f6422f6' AND timestamp > '2014-10-19 13:19:14' AND  [group] = 'page149174'
      
      -- Query took 0,001sec
      SELECT * FROM categories WHERE id = 1
      
      -- Query took 0,01sec
      SELECT TOP 201 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149174 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149174 
      
      -- Query took 0,001sec
      SELECT * FROM ProductVersions WHERE id = '453633'
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149163 
      
      -- Query took 0,019sec
      SELECT DISTINCT (id) FROM images JOIN pvimage ON (pvimage.imageID = images.id) WHERE pvimage.productVersionID = 468792 
      
      -- Query took 0,02sec
      SELECT DISTINCT TOP 100 imageID AS id FROM pvImage WHERE productVersionID = (
      			SELECT TOP 1 productVersionID
      			FROM pvImage JOIN productVersions ON (productVersions.id = productVersionID)
      			WHERE productID = 149174 
      			GROUP BY pvImage.productVersionID
      			ORDER BY COUNT(pvImage.imageID) DESC);
      
      -- Query took 0,005sec
      SELECT
      				categoryFeature.*,
      				features.id AS feature_id,
      				features.externID AS feature_externID,
      				measures.id AS measureid,
      				featureGroupLang.name AS featureGroup_name,
      				featureGroups.id AS featureGroup_id,
      				featureGroups.externid AS featureGroup_externid,
      				featureGroups.externsource AS featureGroup_externsource,
      				featureGroups.priority AS featureGroup_priority,
      				featureLang.name,
      				featureLang.description,
      				measures.defaultSign AS measure_defaultSign,
      				measureLang.name AS measure_name,
      				measureLang.description AS measure_description,
      				measureLang.sign AS measure_sign
      			FROM categoryFeature
      				LEFT JOIN features ON features.id = categoryFeature.featureID
      				LEFT JOIN measures ON features.measureID = measures.id
      				LEFT JOIN featureGroups ON featureGroups.id = categoryFeature.featureGroupID
      				LEFT JOIN featureGroupLang ON featureGroups.id = featureGroupLang.featureGroupID
      				LEFT JOIN featureLang ON features.id = featureLang.featureID AND featureLang.lang = 'NL'
      				LEFT JOIN measureLang ON measures.id = measureLang.measureID AND measureLang.lang = 'NL'
      			WHERE
      				categoryFeature.subCategoryID = 86
      			 AND searchable = "1"
      			ORDER BY
      				featureGroups.priority DESC, priority DESC, featureLang.name
      			
      
      -- Query took 0,134sec
      SELECT TOP 20 Reviews.*, ReviewRatingsFlat.rate as reviewRating,
      		ReviewRatingsFlat.rate_positive as reviewRatePositive,
      		ReviewRatingsFlat.rate_negative as reviewRateNegative
      			FROM Reviews
      			LEFT JOIN ReviewRatingsFlat ON (ReviewRatingsFlat.reviewID = reviews.id)
      			WHERE
      				(
      					productID = 149174 OR
      					productID IN
      						(SELECT productID FROM similarProducts WHERE groupID IN
      							(SELECT groupID FROM similarProducts WHERE productID = 149174)
      						)
      				)
      				AND onlyRating = 0 AND state & 1 = 1 ORDER BY timestamp DESC
      
      -- Query took 0,002sec
      SELECT html FROM htmlCache WHERE id = 'c57dc692e45eeea978d552e80c7d9844' AND timestamp > '2014-10-20 12:19:14' AND  [group] = 'auto'
      
      -- Query took 0,083sec
      SELECT COUNT(*) AS cnt FROM Reviews
      					WHERE
      				(
      					productID = 149174 OR
      					productID IN
      						(SELECT productID FROM similarProducts WHERE groupID IN
      							(SELECT groupID FROM similarProducts WHERE productID = 149174)
      						)
      				)
      		 AND state & 1 = 1
      
      -- Query took 0,012sec
      SELECT review_rates.id, review_rates.name, AVG(ReviewProductRatings.rate) AS rate FROM ReviewProductRatings JOIN Reviews ON (Reviews.id = ReviewProductRatings.reviewID) JOIN review_rates ON (review_rates.id = ReviewProductRatings.rateID) WHERE Reviews.productID = 149174 AND review_rates.subCategoryID = 86 GROUP BY review_rates.id, review_rates.name, review_rates.weight ORDER BY review_rates.weight
      
      -- Query took 0,005sec
      SELECT
      				categoryFeature.*,
      				features.id AS feature_id,
      				features.externID AS feature_externID,
      				measures.id AS measureid,
      				featureGroupLang.name AS featureGroup_name,
      				featureGroups.id AS featureGroup_id,
      				featureGroups.externid AS featureGroup_externid,
      				featureGroups.externsource AS featureGroup_externsource,
      				featureGroups.priority AS featureGroup_priority,
      				featureLang.name,
      				featureLang.description,
      				measures.defaultSign AS measure_defaultSign,
      				measureLang.name AS measure_name,
      				measureLang.description AS measure_description,
      				measureLang.sign AS measure_sign
      			FROM categoryFeature
      				LEFT JOIN features ON features.id = categoryFeature.featureID
      				LEFT JOIN measures ON features.measureID = measures.id
      				LEFT JOIN featureGroups ON featureGroups.id = categoryFeature.featureGroupID
      				LEFT JOIN featureGroupLang ON featureGroups.id = featureGroupLang.featureGroupID
      				LEFT JOIN featureLang ON features.id = featureLang.featureID AND featureLang.lang = 'NL'
      				LEFT JOIN measureLang ON measures.id = measureLang.measureID AND measureLang.lang = 'NL'
      			WHERE
      				categoryFeature.subCategoryID = 86
      			 AND searchable = "1"
      			ORDER BY
      				featureGroups.priority DESC, priority DESC, featureLang.name
      			
      
      -- Query took 0,002sec
      
      
      
      SELECT TOP 7 productsSearch.*, stats_productsFlat.num AS productStats  FROM productsSearch  LEFT JOIN stats_productsFlat ON (stats_productsFlat.productID = products_id AND stats_productsFlat.site = 1)
      			WHERE products_state & 1 = 1  AND subCategories_id = 86  AND brand_id = 9240  ORDER BY (CASE WHEN products_image IS null THEN 1 ELSE 0 END), (CASE WHEN products_endyear IS NULL THEN 3000 ELSE products_endyear END) DESC, stats_productsFlat.num DESC, products_stats DESC, products_id
      
      -- Query took 0,021sec
      
      		DECLARE @ids TABLE
      			(
      				id int
      			)
      			
      		INSERT INTO @ids SELECT id FROM productVersions WHERE productID = 149174
      				
      		
      		
      		SELECT TOP 30 
      			productVersions.productID AS id, SUM(num) 
      		FROM stats_comparedFlat 
      			JOIN @ids AS ids ON (ids.id = productVersionIDA) 
      			JOIN productVersions ON (stats_comparedFlat.productVersionIDB = productVersions.id) 
      		WHERE site = 1 
      		GROUP BY productVersions.productID 
      		ORDER BY SUM(num) DESC 
      		
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72216 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149173 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72272 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149428 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149163 
      
      -- Query took 0,002sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72299 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72059 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 71810 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72156 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149288 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72053 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72138 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72271 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149350 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 71997 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72157 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72141 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149441 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 71820 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149320 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149429 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 160574 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149081 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 71952 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149380 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149077 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149368 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 180158 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72250 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 71967 
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72216 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149173 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,005sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72272 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,004sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149428 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,001sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149163 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72299 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72059 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71810 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72156 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,001sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149288 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72053 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,001sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72138 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,004sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72271 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149350 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71997 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72157 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,001sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72141 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,003sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149441 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,001sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71820 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149320 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,004sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149429 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,001sec
      SELECT * FROM ProductVersions WHERE id = '453633'
      
      -- Query took 0,001sec
      SELECT DISTINCT (id) FROM images JOIN pvimage ON (pvimage.imageID = images.id) WHERE pvimage.productVersionID = 468792 
      
      -- Query took 0,02sec
      SELECT DISTINCT (id) FROM images JOIN pvimage ON (pvimage.imageID = images.id) WHERE pvimage.productVersionID = 453633 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149163 
      
      -- Query took 0,009sec
      SELECT
      			prices_shopProducts.*,
      			prices_shops.id AS shops_id,
      			prices_shops.name AS shops_name,
      			prices_shops.url AS shops_url,
      			prices_shops.address AS shops_address,
      			prices_shops.postcode AS shops_postcode,
      			prices_shops.city AS shops_city ,
      			prices_shops.phone AS shops_phone,
      			prices_shops.email AS shops_email,
      			prices_shops.description AS shops_description,
      			prices_shops.invoiceCompany AS shops_invoiceCompany,
      			prices_shops.invoiceName AS shops_invoiceName,
      			prices_shops.invoiceAddress AS shops_invoiceAddress,
      			prices_shops.invoicePostcode AS shops_invoicePostcode,
      			prices_shops.invoiceCity AS shops_invoiceCity,
      			prices_shops.invoiceTel AS shops_invoiceTel,
      			prices_shops.invoiceEmail AS shops_invoiceEmail,
      			prices_shops.dateAdded AS shops_dateAdded,
      			prices_shops.logo AS shops_logo,
      			prices_shops.state AS shops_state,
      			prices_shops.cost AS shops_cost,
      			prices_shops.keurmerken AS shops_keurmerken,
      			prices_shops.logoimageid as shops_logoimageid,
      			prices_shops.availabilityType AS shops_availabilitytype
      				FROM prices_shopProducts, prices_shops WHERE prices_shopProducts.shopID = prices_shops.id AND prices_shopProducts.productVersionID = 468792 AND prices_shops.state & 2 != 2 ORDER BY prices_shopProducts.priceEx
      
      -- Query took 0,008sec
      SELECT
      			prices_shopProducts.*,
      			prices_shops.id AS shops_id,
      			prices_shops.name AS shops_name,
      			prices_shops.url AS shops_url,
      			prices_shops.address AS shops_address,
      			prices_shops.postcode AS shops_postcode,
      			prices_shops.city AS shops_city ,
      			prices_shops.phone AS shops_phone,
      			prices_shops.email AS shops_email,
      			prices_shops.description AS shops_description,
      			prices_shops.invoiceCompany AS shops_invoiceCompany,
      			prices_shops.invoiceName AS shops_invoiceName,
      			prices_shops.invoiceAddress AS shops_invoiceAddress,
      			prices_shops.invoicePostcode AS shops_invoicePostcode,
      			prices_shops.invoiceCity AS shops_invoiceCity,
      			prices_shops.invoiceTel AS shops_invoiceTel,
      			prices_shops.invoiceEmail AS shops_invoiceEmail,
      			prices_shops.dateAdded AS shops_dateAdded,
      			prices_shops.logo AS shops_logo,
      			prices_shops.state AS shops_state,
      			prices_shops.cost AS shops_cost,
      			prices_shops.keurmerken AS shops_keurmerken,
      			prices_shops.logoimageid as shops_logoimageid,
      			prices_shops.availabilityType AS shops_availabilitytype
      				FROM prices_shopProducts, prices_shops WHERE prices_shopProducts.shopID = prices_shops.id AND prices_shopProducts.productVersionID = 453633 AND prices_shops.state & 2 != 2 ORDER BY prices_shopProducts.priceEx
      
      -- Query took 0,021sec
      SELECT
      				categoryFeature.*,
      				features.id AS feature_id,
      				features.externID AS feature_externID,
      				measures.id AS measureid,
      				featureGroupLang.name AS featureGroup_name,
      				featureGroups.id AS featureGroup_id,
      				featureGroups.externid AS featureGroup_externid,
      				featureGroups.externsource AS featureGroup_externsource,
      				featureGroups.priority AS featureGroup_priority,
      				featureLang.name,
      				featureLang.description,
      				measures.defaultSign AS measure_defaultSign,
      				measureLang.name AS measure_name,
      				measureLang.description AS measure_description,
      				measureLang.sign AS measure_sign
      			FROM categoryFeature
      				LEFT JOIN features ON features.id = categoryFeature.featureID
      				LEFT JOIN measures ON features.measureID = measures.id
      				LEFT JOIN featureGroups ON featureGroups.id = categoryFeature.featureGroupID
      				LEFT JOIN featureGroupLang ON featureGroups.id = featureGroupLang.featureGroupID
      				LEFT JOIN featureLang ON features.id = featureLang.featureID AND featureLang.lang = 'NL'
      				LEFT JOIN measureLang ON measures.id = measureLang.measureID AND measureLang.lang = 'NL'
      			WHERE
      				categoryFeature.subCategoryID = 86
      			
      			ORDER BY
      				featureGroups.priority DESC, priority DESC, featureLang.name
      			
      
      -- Query took 0,021sec
      
      				DELETE FROM htmlCache WHERE id = '733275db82037029ddbacf091f6422f6' AND [group] = 'page149174';
      				INSERT INTO htmlCache (id, html, [group]) VALUES ('733275db82037029ddbacf091f6422f6', '
      		
      		
      			
      
      
      
      
      
      
      
      
      
      
      			
      			
      			
      			
      			Vergelijk Ford Focus* 1.4 ambiente 59kW  met Ford Fiesta* 1.4i ambiente 59kW op prijs en technische specificaties
      
      			
      
      
      			
      
      			
      			
      
      			
      			
      			
      
      
      			
      
      			
      			
      			
      			
      
      			
      
      						
      			
      					
      
      					
      		
      		
      		

      Ford Focus* (5 deurs) (2004 - 2008)

      5,6 uit 11 beoordelingen

      Prijs: 19.000

        

      Vergelijk Ford Focus* 1.4 ambiente 59kW met ...

      Vergelijk Ford Focus* 1.4 ambiente 59kW met ...

      toevoegen
      Model/productFord Focus* (5 deurs) (2004 - 2008)Ford Fiesta* (5 deurs) (2005 - 2009) 
      UitvoeringFord Focus* 1.4 ambiente 59kW
      Wijzig uitvoering
      Ford Fiesta* 1.4i ambiente 59kW
      Wijzig uitvoering
       
      Laagste prijzen
           
          Prijs

           
          Consumentenprijs 19.000,00 14.910,00 
          Prijs exclusief BTW 16.564,00 12.982,00 
          BPM 3.740,00 2.834,00 
          Kosten rijklaar maken 600,00 605,00 
          Milieu / verbruik

           
          BrandstofetiketBC 
          Verbruik 120 km/u5,4 l/100km5,1 l/100km 
          Verbruik stad8,7 l/100km8,6 l/100km 
          CO2 uitstoot159 g/km147 g/km 
          Brandstofloodvrije benzineloodvrije benzine 
          Gecombineerd verbruik6,6 l/100km6,2 l/100km 
          Motor

           
          Cilinderinhoud1.388 cc1.388 cc 
          Aantal cilinders44 
          Kleppen per cilinder44 
          BrandstofsysteemMPIMPI 
          Compressieverhouding1111 
          Prestaties

           
          Topsnelheid164 km/u167 km/u 
          Acceleratie 0-100 km/u14,1 sec13,2 sec 
          Vermogen59 kW59 kW 
          Vermogen (tpm)5.7005.700 
          Koppel125 Nm124 Nm 
          Koppel (tpm)3.5003.500 
          Aandrijving / onderstel

           
          Versnellingsbak55 
          Aandrijvingvoorwielvoorwiel 
          Velgmaat1514 
          Banden achter195/65175/65 
          Banden voor195/65175/65 
          Remmen achterschijftrommel 
          Remmen voorschijfschijf 
          Afmetingen

           
          Lengte4.342 mm3.918 mm 
          Breedte1.991 mm1.905 mm 
          Hoogte1.497 mm1.432 mm 
          Tankinhoud55 liter45 liter 
          Spoorbreedte achter1.531 mm1.434 mm 
          Spoorbreedte voor1.535 mm1.464 mm 
          Wielbasis2.640 mm2.486 mm 
          Inhoud bagageruimte min385 liter284 liter 
          Inhoud bagageruimte max1.245 liter947 liter 
          Draaicirkel10,4 m9,3 m 
          Garantie

           
          Garantie algemeen2 jaar2 jaar 
          Garantie carrosserie12 jaar12 jaar 
          Garantie lak2 jaar2 jaar 
          Olie verversen..10.000 km 
          Grote beurt20.000 km20.000 km 
          Carrosserie

           
          Carrosserrievormhbhb 
          Aantal deuren55 
          Opties

           
          Airconditioning 0,00 900,00 
          Boordcomputer.. 295,00 
          Dakdragers.. 139,00 
          Lichtmetalen velgen 600,00.. 
          Luidsprekers..1 
          Metallic lak 600,00 525,00 
          Parkdistance control achter.. 450,00 
          Radio/cassette 400,00 0,00 
          Radio/CD-speler 600,00 300,00 
          Regensensor.. 295,00 
          Schuifdak electrisch 900,00.. 
          Schuifdak handbediening.. 550,00 
          Spiegels electrisch.. 295,00 
          Spiegels verwarmd.. 295,00 
          Stoelen verwarmd.. 200,00 
          Traction Control 800,00.. 
          Verwarmde voorruit.. 250,00 
          Airbags hoofd 0,00 300,00 
          Overig

           
          Gross Vehicle Weight1.710 kg1.520 kg 
          Rijklaar gewicht1.147 kg1.001 kg 
          Maximum laadvermogen463 kg429 kg 
          Aanhanger ongeremd620 kg500 kg 
          Aanhanger geremd700 kg900 kg 
          ', 'page149174')