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 = 1064758 LIMIT 0,1 Enquire Now to Lahlou Chakib (medecin) - Gulf Yellow Pages Online
Gulf Yellow Pages Online
Home » Enquiry
Business Enquiry Form
Send Business Enquiry to : Lahlou Chakib (medecin)
   

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 United Arab Emirates From Anywhere

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