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

KIA RIO - RIO DIESEL HATCHBACK, RIO HATCHBACK, RIO HATCHBACK SPECIAL EDITIONS, RIO HATCHBACK 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=645 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=645 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 = 645) ORDER BY C.cmod_name ASC

KIA RIO

    Search for a new Car

     

    Insurance Information

    Click here for your Car insurance quote

    Go Compare Insurance Quotes for New Cars

    Our Guarantee

    • Brand new UK Main Dealer Supplied
    • Full manufacturers warranty
    • FREE DELIVERY
    • 12 months Road Fund Licence
    • 1st Registration Fee
    • Number Plates
    • Manufacturer Breakdown Cover
    • Excellent finance rates

    Sonnauto UK Ltd is an active member of the Federation of Small Businesses