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 = 86076 LIMIT 0,1 Gift And Novelty Dealers from BIN HASSAN GIFTS & ANTIQUES SHOP W L L in Abu Dhabi, United Arab Emirates
Oman Yellow Pages Online
Home » Products »  GIFT AND NOVELTY DEALERS

GIFT AND NOVELTY DEALERS

Add Review
Price : On Request


Novelties & Gifts
  • Product Details
  • Brand :
  • Place of Origin : Not Given
  • FOB Price : On Request
  • Minimum Order Quantity : Not Given
  • Supply Ability :
  • Packaging & Delivery
  • Packaging Detail : Not Given
  • Delivery Detail : Not Given
Not Given