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 = 1281404 LIMIT 0,1 Air Cleaning & Purifying Eqpt from Your maid building cleaning & Technical Service in Dubai, United Arab Emirates
Your maid building cleaning & Technical Service - | E-Showroom
Your maid building cleaning & Technical Service
Ground Floor, Building R-12 Shop # 5, France Cluster, International City dubai Dubai
United Arab Emirates
We are the Professional Maid Supply Company for Home Cleaning, Office Cleaning, General Cleaning, Ironing, Baby-Sitting, Pet Care, Party Assistance and Party Cleaning. We also undertakes Building Maintenance, AC & Chiller Cleaning Projects. - See more at: http://www.yellowpages.ae/l-df-01-03-00045189-your-maid-building-cleaning-technical-services-llc.html#sthash.RKH8asTo.dpuf
