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 = 171698 LIMIT 0,1 Product Catalog of AVANT RESTAURANTS (L.L.C) - Gulf Yellow Pages Online
Gulf Yellow Pages Online
AVANT RESTAURANTS (L.L.C)

AVANT RESTAURANTS (L.L.C) - | E-Showroom

Home » Catalogue
Products Catalogue

About Us

Gulf Yellow Pages Online is a Local Business to Business Directory in Gulf offering business list of more than 250,000 companies. You can find Hotels in Gulf , Companies in Gulf , Properties in Gulf , Travel info in Gulf through this Site. Yellow Pages Gulf 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 Gulf
Top Countries (Gulf)
Top Cities (Africa)
Top Cities (India)

Contact Gulf Yellow Pages Online

  • Ajman Free Zone, Ajman , United Arab Emirates
  • Sales & Support Contact: 00971 56 129 4091
  • support@gulfyp.com
  • India Office of Gulf 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 UNITED ARAB EMIRATES | CONTACT US
Privacy Policy - Terms of Use - 2020-2025 Gulf Yellow Pages Online
Copyright Notice 2020-2025 Gulf Yellow Pages Online All rights reserved.
Gulf Yellow Pages Online