SELECT CompanyID,CompanyName, ContactPerson, Add1, Add2, Add3, a.CityID, a.CountryID, Pincode, TelStdCode, TelNo, FaxStdCode, FaxNo, email, website, FreeEntry, Activities, MobileNo, isElite, eliteuserfilepath, EliteEnteredDate, EliteValidTillDate, eliteConfirmed, datarefId, entryadddate, AllUAEElite, GCCElite, internationalElite, b.CityID, CityName, b.CountryID, citycode, c.CountryID, CountryName, gulfcountry, countrycode, hostcountry, maincompanyid, branchname,hasBranches,lattitude,longitude,mapzoom, skypeid,facebookpageurl,twitterpageurl,Google_store_applink,Apple_store_applink,rating,whatsappnoforchat,noofreviews,worstrating,bestrating FROM mstcompany a LEFT JOIN mstcity b ON a.CityID = b.CityID LEFT JOIN mstcountry c ON a.CountryID = c.CountryID WHERE a.companyid = 452029 LIMIT 0,1 Enquire Now to CODE FOR ALUMINIUM TRADING LLC - Kuwait Yellow Pages Online
Kuwait Yellow Pages Online
Home » Enquiry
Business Enquiry Form
Send Business Enquiry to : CODE FOR ALUMINIUM TRADING LLC
   

Enter Your Requirements Subject :

Enter Your Detailed Requirements here such as :

  • Products
  • Specifications
  • Delivery etc

Need Just Quote Need to Purchase
Immediate Within 15-30 days
From Kuwait From Anywhere

Your Name:*
Your Email:*
Company:
Location:*