select PRODUCT_NAME_INFO.product_info_name as product_info FROM PRICE_VARIANT_VALUES,PRODUCT_NAME_INFO,PRODUCT_MASTER where PRODUCT_MASTER.product_id in (select product_id from PRODUCT_FEATURE where feature_id in (93)) and PRICE_VARIANT_VALUES.variant_id = 1 and PRICE_VARIANT_VALUES.status = 1 and PRODUCT_MASTER.product_id = PRICE_VARIANT_VALUES.product_id and PRICE_VARIANT_VALUES.default_city=1 and PRODUCT_MASTER.product_name = PRODUCT_NAME_INFO.product_info_name and PRODUCT_NAME_INFO.status=1 and PRICE_VARIANT_VALUES.color_id = 0 and PRODUCT_MASTER.category_id in(1) and PRODUCT_MASTER.brand_id in(44) and PRODUCT_MASTER.status=1 and (PRODUCT_MASTER.discontinue_date >= '2015-02-28 00:00:00' OR PRODUCT_MASTER.discontinue_date = '0000-00-00 00:00:00') order by CAST(PRICE_VARIANT_VALUES.variant_value AS UNSIGNED) asc
Ashok Leyland Suv Cars in India - Explore Ashok leyland Suv Cars Models with Price in India | OnCars.in

Ashok Leyland Cars

Ashok Leyland
Ashok Leyland is the second largest commercial vehicle manufacturer in the Indian automotive industry. It sells about 60,000 vehicles and about 7,000 engines annually. The company recently forayed into the personal transportation space with the Stile MPV which is basically a restyled Nissan Evalia.
SHARE

THIS

New Suv  Ashok Leyland Cars in India

Filter by: 
Price  

Advertisement