select PRODUCT_NAME_INFO.product_info_name as product_info FROM PRICE_VARIANT_VALUES,PRODUCT_NAME_INFO,PRODUCT_MASTER where 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(6) 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
Maruti Suzuki Cars in India - Explore Maruti suzuki Cars Models with Price in India | OnCars.in

Maruti Suzuki Cars

Maruti Suzuki
Maruti doesn't need an introduction in India. The most successful manufacturer still has almost 50 per cent share in the market and will continue to hold its position for a while. Cheap, reliable, economical, fuel efficient and easy to maintain are the attributes that make them the most sought brand in India.
SHARE

THIS

New Maruti Suzuki Cars in India

Filter by: 
Price  

Advertisement