Kia Specials
VehicleIncentiveGroup Object ( [division] => Kia [divisionId] => 29 [divisionZip] => [urlPrefix] => [divisionSplashImage] => [weblink] => www.dickhannahkia.com [model] => [year] => 2016 [output] => [html] => [programs] => [leftIncentiveOutput] => [rightIncentiveOutput] => ) SELECT Distinct cs_IncentiveInfoNew.*, cs_IncentivesToShowAssoc.cs_Division, cs_IncentivesToShowAssoc.cs_IncentiveOrder FROM cs_IncentiveInfoNew, cs_IncentivesToShowAssoc WHERE cs_IncentivesToShowAssoc.cs_Division = cs_IncentiveInfoNew.DivisionID AND cs_IncentivesToShowAssoc.cs_IncentiveValue = 1 AND cs_IncentivesToShowAssoc.cs_IncentiveCatID = cs_IncentiveInfoNew.CategoryID AND cs_IncentiveInfoNew.DivisionID = 29 AND cs_IncentiveInfoNew.Year = '2016' ORDER BY cs_IncentiveInfoNew.Year, cs_IncentiveInfoNew.Model, cs_IncentivesToShowAssoc.cs_IncentiveOrder, cs_IncentiveInfoNew.ProgramDescription

© 2016 Dick Hannah Dealerships
Strive2Drive
Green Auto Dealers in Portland
Giving Back in Portland and Vancouver WA
BBB Seal