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 = 501890 LIMIT 0,1 Product Catalog of HSMD MIDDLE EAST - UAE Yellow Pages Online
UAE Yellow Pages Online
HSMD MIDDLE EAST

HSMD MIDDLE EAST - | E-Showroom

Home » Catalogue
Products Catalogue

About Us

UAE Yellow Pages Online is a Local Business to Business Directory in UAE offering business list of more than 250,000 companies. You can find Hotels in UAE , Companies in UAE , Properties in UAE , Travel info in UAE through this Site. Yellow Pages UAE Updated in 2025 Get Maximum Benefit for your Business Visit YP MarketPlaces

Our Policies

Privacy Policy
Refund Policy
Dispute & Resolution Policy
Terms

Follow Us

Top Brands in UAE
Top Countries (Gulf)
Top Cities (Africa)
Top Cities (India)

Contact UAE Yellow Pages Online

  • Ajman Free Zone, Ajman , United Arab Emirates
  • Sales & Support Contact: 00971 56 129 4091
  • support@gulfyp.com
  • India Office of UAE Yellow Pages Online
  • Contact: +91 7977 00 5636 / 7977 08 1292
  • support@gulfyp.com
HOME l PRODUCT CATEGORIES l B2B MARKETPLACE l ADVERTISE l ADD COMPANY l ABOUT UAE | CONTACT US
Privacy Policy - Terms of Use - 2020-2025 UAE Yellow Pages Online
Copyright Notice 2020-2025 UAE Yellow Pages Online All rights reserved.
UAE Yellow Pages Online