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 = 1198275 LIMIT 0,1 Awards and Achievements of LA MAMA RESTAURANT - Nigeria Yellow Pages Online
Nigeria Yellow Pages Online
LA MAMA RESTAURANT

LA MAMA RESTAURANT - | E-Showroom

Home » Awards
Awards

About Us

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

Contact Nigeria Yellow Pages Online

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