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 = 809

NISSAN PATHFINDER - PATHFINDER DIESEL STATION WAGON, PATHFINDER STATION WAGON, PATHFINDER STATION WAGON SPECIAL EDS

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=809 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=809 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 = 809) ORDER BY C.cmod_name ASC

Search Results - No Vehicles in Selected Range

Internal Error

A server error has occurred