LG Showroom

Address

LGEIL, 105/106,

Premium Point, JM Road, Opposite Modern High School, 3rd floor

Deccan Gymkhana

Pune

Phone No

020-39010909

Website

- www.lgindia.com

With over 1000 service stations and nearly 7500 service engineers across India - LG is a famous Electroic and home appliences company in India.

Address given is the official shop of LG India. Telephone number can also be used for customer care for LG Products in Pune, Maharashtra. Customers can also send their problems/question on (Email) lgservice@lgindia.com for quick response.

Other Categories in pune

Computer Repair, Sales, accessories

BPO Consultancy - Trainning

Study Abroad consultancy

Tax Consultants

List of BPO Company

Dance & Music Class

Kindergartens-Day Care

IT - Software Consultancy

Medical Specialists

Colleges

Software Companies

Tours and Travel Agency

Rent a Car, Bus

Electronic & home appliances

Transportation : Vehicles, Household

Bank Branch, ATM Location & Money Transfer

Health, Fitness, Beauty

Bus/Train/Flight Reservations

Yellow Pages (Service Providers)

0.004	SELECT "locallistings_listing"."id","locallistings_listing"."title","locallistings_listing"."slug","locallistings_listing"."desc","locallistings_listing"."address_id","locallistings_listing"."website","locallistings_listing"."added" FROM "locallistings_listing" WHERE ("locallistings_listing"."slug" = lg-showroom)
0.000	SELECT "locallistings_tag"."id","locallistings_tag"."name","locallistings_tag"."slug","locallistings_tag"."display_name","locallistings_tag"."image" FROM "locallistings_tag" WHERE ("locallistings_tag"."slug" = electronic-home-appliances)
0.000	SELECT "locallistings_address"."id","locallistings_address"."first_line","locallistings_address"."second_line","locallistings_address"."location_id" FROM "locallistings_address" WHERE ("locallistings_address"."id" = 173)
0.000	SELECT "locallistings_location"."id","locallistings_location"."name","locallistings_location"."slug","locallistings_location"."city_id" FROM "locallistings_location" WHERE ("locallistings_location"."id" = 10)
0.001	SELECT "locallistings_tag"."id","locallistings_tag"."name","locallistings_tag"."slug","locallistings_tag"."display_name","locallistings_tag"."image" FROM "locallistings_tag" WHERE ((NOT ("locallistings_tag"."image" = )))
0.000	SELECT "locallistings_city"."id","locallistings_city"."name","locallistings_city"."slug" FROM "locallistings_city" WHERE ("locallistings_city"."id" = 1)
0.002	SELECT "locallistings_phone"."id","locallistings_phone"."no" FROM "locallistings_phone" LEFT OUTER JOIN "locallistings_listing_phone" AS "m2m_locallistings_phone__listing" ON "locallistings_phone"."id" = "m2m_locallistings_phone__listing"."phone_id" WHERE ("m2m_locallistings_phone__listing"."listing_id" = 184)
0.004	SELECT "locallistings_listing"."id","locallistings_listing"."title","locallistings_listing"."slug","locallistings_listing"."desc","locallistings_listing"."address_id","locallistings_listing"."website","locallistings_listing"."added" FROM "locallistings_listing" INNER JOIN "locallistings_address" AS "locallistings_listing__address" ON "locallistings_listing"."address_id" = "locallistings_listing__address"."id" INNER JOIN "locallistings_location" AS "locallistings_listing__address__location" ON "locallistings_listing__address"."location_id" = "locallistings_listing__address__location"."id" LEFT OUTER JOIN "locallistings_listing_tags" AS "m2m_locallistings_listing__tags" ON "locallistings_listing"."id" = "m2m_locallistings_listing__tags"."listing_id" WHERE ("locallistings_listing__address__location"."slug" = deccan-gymkhana AND "m2m_locallistings_listing__tags"."tag_id" = 40)