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 = 12781 LIMIT 0,1 Enquire Now to ARID LAND DEVELOPMENT CO. L.L.C. - UAE Yellow Pages Online
UAE Yellow Pages Online
Home » Enquiry
Business Enquiry Form
Send Business Enquiry to : ARID LAND DEVELOPMENT CO. L.L.C.
   

Enter Your Requirements Subject :

Enter Your Detailed Requirements here such as :

  • Products
  • Specifications
  • Delivery etc

Need Just Quote Need to Purchase
Immediate Within 15-30 days
From UAE From Anywhere

Your Name:*
Your Email:*
Company:
Location:*