WARNING: SM: SELECT DISTINCT CapRange.cran_name, CapMan.cman_name, CapMod.cmod_name FROM CapDer INNER JOIN CapRange ON CapDer.cder_rancode = CapRange.cran_code INNER JOIN CapMan ON CapDer.cder_mancode = CapMan.cman_code INNER JOIN CapMod ON CapDer.cder_modcode = CapMod.cmod_code WHERE CapDer.cder_rancode = 866

PEUGEOT 207 - 207 COUPE CABRIOLET, 207 COUPE CABRIOLET SPECIAL EDITION, 207 DIESEL COUPE CABRIOLET, 207 DIESEL HATCHBACK, 207 DIESEL SW ESTATE, 207 HATCHBACK, 207 HATCHBACK SPECIAL EDITIONS, 207 SW ESTATE, 207 SW ESTATE SPECIAL EDITIONS

Skip Links

“The Cheaper Route to your New Car or Commercial Vehicle”

0845 612 3341

WARNING: SELECT DISTINCT C.cmod_code, C.cmod_name, CapRange.cran_code, CapRange.cran_name, CapMan.cman_name, (SELECT COUNT(*) FROM tbl_Vehicles LEFT JOIN CapMod AS intCapMod ON tbl_Vehicles.VE_Mod_Code = C.cmod_code LEFT JOIN CapDer ON tbl_Vehicles.VE_cder_ID=CapDer.cder_ID WHERE tbl_Vehicles.VE_ManLive=1 AND tbl_Vehicles.VE_ModLive=1 AND tbl_Vehicles.VE_Live=1 AND tbl_Vehicles.VE_RanLive=1 AND tbl_Vehicles.VE_Mod_Code=C.cmod_code AND IsNull(CapDer.cder_discontinued,'')='' AND VE_Ran_Code=866 AND intCapMod.cmod_code = C.cmod_code) AS VehicleCount, (SELECT TOP 1 VE_cder_ID FROM tbl_Vehicles LEFT JOIN CapMod ON tbl_Vehicles.VE_Mod_Code = C.cmod_code LEFT JOIN CapDer ON tbl_Vehicles.VE_cder_ID=CapDer.cder_ID WHERE tbl_Vehicles.VE_ManLive=1 AND tbl_Vehicles.VE_ModLive=1 AND tbl_Vehicles.VE_Live=1 AND tbl_Vehicles.VE_RanLive=1 AND tbl_Vehicles.VE_Ran_Code=866 AND tbl_Vehicles.VE_mod_code=C.cmod_code AND IsNull(CapDer.cder_discontinued,'')='' ORDER BY NewID()) AS VehicleID FROM CapMod AS C INNER JOIN CapRange ON CapRange.cran_code=C.cmod_rancode INNER JOIN CapMan ON CapMan.cman_code=C.cmod_mancode WHERE (cmod_discontinued = 0) AND (C.cmod_rancode = 866) ORDER BY C.cmod_name ASC

Search Results - No Vehicles in Selected Range

Internal Error

A server error has occurred